DB2 - Problem description
Problem IT36388 | Status: Closed |
UNEXPECTED SQL206 WHEN COLUMN NAME OR COLUMN NAME QUALIFIER HAS TRAILING SPACES | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
As per the SQL reference, trailing spaces in delimited identifiers are not significant: https://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ib m.db2.luw.sql.ref.doc/doc/r0000720.html A delimited identifier is a sequence of one or more characters enclosed by double quotation marks. Leading blanks in the sequence are significant. Trailing blanks in the sequence are not significant,... In some contexts, the trailing spaces are treated as significant resulting in erroneous SQL0206 errors, e.g.: select "IBMREQD " from sysibm.sysdummy1 SQL0206N "SYSDUMMY1 .IBMREQD " is not valid in the context where it is used. SQLSTATE=42703 select "SYSIBM "."SYSDUMMY1 "."IBMREQD " from sysibm.sysdummy1 SQL0206N "SYSIBM.SYSDUMMY1 .IBMREQD " is not valid in the context where it is used. SQLSTATE=42703 select "TESTDB "."SYSIBM "."SYSDUMMY1 "."IBMREQD " from sysibm.sysdummy1 SQL0206N "TESTDB.SYSIBM.SYSDUMMY1 .IBMREQD " is not valid in the context where it is used. SQLSTATE=42703 Column names in select list, correlation name (no schema allowed) select "IBMREQD " from sysibm.sysdummy1 A SQL0206N "IBMREQD " is not valid in the context where it is used. SQLSTATE=42703 select "A "."IBMREQD " from sysibm.sysdummy1 A SQL0206N "A .IBMREQD " is not valid in the context where it is used. SQLSTATE=42703 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 version 11.5.6.0 * **************************************************************** | |
Local Fix: | |
Remove the trailing spaces | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 version 11.5.6.0 * **************************************************************** | |
Comment | |
First fixed in Db2 version 11.5.6.0 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 29.03.2021 14.06.2021 14.06.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |