suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT29577 Status: Closed

DB2LOOK IS NOT DISPLAYING THE TABLE COMMENTS PROPERLY USING DOUBLE QUOTES

product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem description:
db2look is not displaying the table comments properly when using
double quote at the beginning, end or middle : ie :

CREATE TABLE "COMMENTS" ("ID" INTEGER )ORGANIZE BY ROW
COMMENT ON TABLE "COMMENTS" IS '"new"test"'

select substr(tabname,1,10) as tabname, substr(remarks,1,30) as
remarks  from syscat.tables where tabname='COMMENTS'

TABNAME       REMARKS
--------------- ------------------------------
COMMENTS    "new"test"

But after db2look -d testdb -e -t COMMENTS -o a.out

db2look reported: INCORRECT EXTRA DOUBLE QUOTE at the beginning,
in the middle and at the end:
COMMENT ON TABLE "WANGYUZ9"."COMMENTS" IS '""new""test""'
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
28.06.2019
18.01.2020
18.01.2020
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)