When user extracts DDL tables with TOAD for DB2 v4.5 often the DEFAULT value is missing.
On the following example, the default value is missing on last 2 column.
CREATE TABLE ELAERO.TXN_TYP (
TXN_TYP_ID SMALLINT NOT NULL,
TXN_TYP VARCHAR(20),
TXN_CAT VARCHAR(16) NOT NULL,
DELETE_IND CHARACTER(1) NOT NULL DEFAULT N,
TXN_CNT INTEGER NOT NULL DEFAULT ,
TXN_CAT_ID SMALLINT NOT NULL DEFAULT
)
IN CDW_D_AERO_DIMENSN
NOT LOGGED INITIALLY;
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center