DB2 FOR LUW / DB2FORLUW / B10 - DB2

LOAD command fails when column name COMMENTS is used in target
table

db2sampl -xml -sql
db2 "DECLARE mycurs CURSOR FOR SELECT ID, NAME, JOB FROM staff"
db2diag -A
db2 "load from mycurs OF CURSOR insert into
t139790.COMMENT_TEST0(ID,STRING,COMMENTS) nonrecoverable"

$db2 "load from mycurs OF CURSOR insert into
t139790.COMMENT_TEST0(ID,STRING,COMMENTS) nonrecoverable"
SQL0104N  An unexpected token "COMMENTS" was found following
",".  Expected
tokens may include:  "".  SQLSTATE=42601

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher                *
****************************************************************

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

11.04.2018
28.11.2018
28.11.2018