|
Problem IC65691
|
Status: Closed |
ABSTRACT: DB2CC CREATE TABLE WIZARD LONG VARCHAR BAD DDL -104 |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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> |
| Problem Summary: |
Users affected: All
Problem Description: See above
Problem Summary: See above |
| Local Fix: |
Recommended workaround: manually enter single quotes around
values in
the create table wizard window for any long varchar columns. |
| available fix packs: |
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
|
| Solution |
First fixed in DB2 UDB Version 9.7fp2 |
| Workaround |
N/A |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 20.01.2010
30.06.2010
30.06.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
