IBM Support

Some SQL messages changed to return SQL column names

News


Abstract

Some SQL messages changed to return SQL column names

Content

You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Database Engineer (DBE) Enhancements > Some SQL messages changed to return SQL column names

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)

image-20200117131551-1

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
11 April 2021

UID

ibm11168432

Page Feedback