DB2 FOR LUW / DB2FORLUW / 970 - DB2

Env: 
OS : Windows XP 
DB2 release: 
DB21085I  Instance "DB2" uses "32" bits and DB2 code release 
"SQL09054" with level identifier "06050107". 
Informational tokens are "DB2 v9.5.400.576", "s090429", 
"WR21449", and Fix Pack "4". 
Product is installed at "C:\SQLLIB" with DB2 Copy Name 
"DB2COPY1". 
 
Problem: 
Abstract: db2cc create table wizard long varchar bad ddl -104 
We have discovered an apparent bug in DB2 ESE v9.5 fp4 in the 
DB2 Control 
Center Create Table Wizard - when creating a table with column 
type LONG 
VARCHAR, specifying a default value requires single quotes to 
surround 
the value in generated ddl, but these quotes are not generated, 
resulting in the following error message: 
 
SQL0104N  An unexpected token "," was found following "AR"  WITH 
DEFAULT ak".  Expected tokens may include:  "<references_spec>

Users affected: All 
Problem Description: See above 
Problem Summary: See above

Recommended workaround: manually enter single quotes around 
values in 
the create table wizard window for any long varchar columns.

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
 

First fixed in DB2 UDB Version 9.7fp2

N/A

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

20.01.2010
30.06.2010
30.06.2010

9.7.FP2