DB2 FOR LUW / DB2FORLUW / 970 - DB2

While creating  columns of a table - with creating space in the 
column  name it creates wrong db2look output. 
 
If they create a column with the following options. 
 
Example below : 
 
db2 create table test (\"CO  L1 \" varchar(15), \"COL2\"  - 
integer,\"COL3\" integer)  -- 
 
(here  space in between COL1 name) 
 
if after customer do runstats of the table -it create sample 
runstats in db2look output. 
 
 
But while doing runstats with the statement created in db2look- 
it fails to recognize the column.

While creating  columns of a table - with creating space in the 
 
column  name it creates wrong db2look output. 
 
If they create a column with the following options. 
 
Example below : 
 
db2 create table test (\"CO  L1 \" varchar(15), \"COL2\"  - 
integer,\"COL3\" integer)  -- 
 
(here  space in between COL1 name) 
 
if after customer do runstats of the table -it create sample 
runstats in db2look output. 
 
 
But while doing runstats with the statement created in db2look- 
it fails to recognize the column.

Use  double quotes  between the column name.

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Use  double quotes  between the column name.

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

19.02.2010
18.05.2010
18.05.2010