|
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) |
