Hello all,
i need your help on explaining the following case.
i have a DB2 file created with the following SQL statement
CREATE TABLE myLib/T2 (
A1 NUMERIC(11, 0) NOT NULL with DEFAULT ,
A2 CHAR(10) NOT NULL with DEFAULT ,
A3 VARCHAR(20) NOT NULL with DEFAULT ,
A4 VARCHAR(30) NOT NULL with DEFAULT )
and also i have the following DDS that i believe it would match the aforementioned SQL
A R T2
A A1 11S 0
A A2 10A
A A3 20A VARLEN
A A4 30A VARLEN
however the T2 file created with DDS, has a different Record Format Identifier.
Both files are in the same system and are created in the same job (fields ccsid is 37).
SQL
Record Format Information
Record format . . . . . . . . . . . . . . . : T2
Format level identifier . . . . . . . . . . : 28F9CEF073F67
Number of fields . . . . . . . . . . . . . : 4
Record length . . . . . . . . . . . . . . . : 75
DDS
Record Format Information
Record format . . . . . . . . . . . . . . . : T2
Format level identifier . . . . . . . . . . : 27F9CEF072F67
Number of fields . . . . . . . . . . . . . : 4
Record length . . . . . . . . . . . . . . . : 75
i need your help on explaining the following case.
i have a DB2 file created with the following SQL statement
CREATE TABLE myLib/T2 (
A1 NUMERIC(11, 0) NOT NULL with DEFAULT ,
A2 CHAR(10) NOT NULL with DEFAULT ,
A3 VARCHAR(20) NOT NULL with DEFAULT ,
A4 VARCHAR(30) NOT NULL with DEFAULT )
and also i have the following DDS that i believe it would match the aforementioned SQL
A R T2
A A1 11S 0
A A2 10A
A A3 20A VARLEN
A A4 30A VARLEN
however the T2 file created with DDS, has a different Record Format Identifier.
Both files are in the same system and are created in the same job (fields ccsid is 37).
SQL
Record Format Information
Record format . . . . . . . . . . . . . . . : T2
Format level identifier . . . . . . . . . . : 28F9CEF073F67
Number of fields . . . . . . . . . . . . . : 4
Record length . . . . . . . . . . . . . . . : 75
DDS
Record Format Information
Record format . . . . . . . . . . . . . . . : T2
Format level identifier . . . . . . . . . . : 27F9CEF072F67
Number of fields . . . . . . . . . . . . . : 4
Record length . . . . . . . . . . . . . . . : 75
Comment