DB2 FOR LUW / DB2FORLUW / 950 - 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 and creating space in the 
column  name - 
If they create a column with the following options. 
db2 create table t_udf (\"CO  L1 \" varchar(15), \"COL2\"      - 
here  space in between COL1 name 
integer,\"COL3\" integer)  -- (i.e space included in COL1 )- 
 
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.5 Fix Pack 6a for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

Use  double quotes  between the column name

Vorgänger  : APAR is sysrouted TO one or more of the following: IC66502 IC66503 
Nachfolger : 

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

14.09.2009
18.05.2010
18.05.2010