News
Abstract
Some SQL messages changed to return SQL column names
Content
SQL Column names are much easier to understand than Field names
SQL Language constructs like FOR SYSTEM NAME and FOR COLUMN make it easier to recognize and understand failures, because the name is chosen instead of system generated
A behavior change has been made, to give preference to SQL column names in failure messages. The list of SQL messages changed to return SQL column names is: SQL0190, SQL0196, SQL0197, SQL0404, SQL0406, SQL0407, SQL0415
Note: An environment variable can be used to direct Db2 for i to revert to the previous behavior and return system names for these messages.
ADDENVVAR ENVVAR(QIBM_SQL_COL_SYS_NAME) LEVEL(*SYS)
Was this topic helpful?
Document Information
Modified date:
11 April 2021
UID
ibm11168432