I have a file created in SQL using Create Table.
I have another file that is defined like that table, yet the format level IDs are different.  I have walked through the DSPFFD output and the files look identical.
The second file I have created as:
CREATE TABLE CdrMiscP2 LIKE CdrMiscP
  INCLUDING IDENTITY COLUMN ATTRIBUTES
  INCLUDING COLUMN DEFAULTS
  INCLUDING IMPLICITLY HIDDEN COLUMN ATTRIBUTES
  INCLUDING ROW CHANGE TIMESTAMP COLUMN ATTRIBUTES
  RCDFMT CdrMiscF;
Format Level ID: 3F61F0D0B2DB3
I have also ran the command without the INCLUDING (I had only added that in later after reading online to try including those) and got the same Level ID.
The original create table:
CREATE TABLE CdrMiscP (
   Edit_ID For
   EditID     INTEGER                     NOT NULL DEFAULT 0,
   CDR_Sequence_Number For
   CDRSeq#    INTEGER                     NOT NULL DEFAULT 0,
   Miscellaneous_Code For
   MiscCode   Char           (5)          NOT NULL DEFAULT ' ',
   Miscellaneous_Value For
   MiscValue  VarChar (100)  ALLOCATE(30) NOT NULL DEFAULT ' ',
   Statement_Date For
   StmDte     Date                        NOT NULL DEFAULT '0001-01-01',
   Primary Key (EditID, CDRSeq#, MiscCode)
   )
   RCDFMT CdrMiscF;
Format Level ID: 3FE1F0D0B35B3
If I do a CRTDUPOBJ the Format Level ID comes out the same.   I suppose I can create the file using CRTDUPOBJ, but I prefer to have source for the files we use.  (I guess it can be source saying, "Hey, create it with crtdupobj.")
I originally ran into this issue with a much larger file (that did not have a Primary Key).  I was testing on a smaller file to see if I still ran into the issue and I did.
I'm on 7.1.
Should I open a ticket with IBM?  Am I missing something?
Thanks,
Kurt Anderson
Sr. Programmer/Analyst at CustomCall Data Systems
[Description: Description: Description: cid:image001.jpg@01CD0CDD.2AC4AAD0]
phone: +1 608 274 3009
web: www.customcall.com<
http://www.customcall.com/> | email: kanderson@xxxxxxxxxxxx<mailto:kanderson@xxxxxxxxxxxx>
A Division of Enghouse Systems Ltd.<
http://www.enghouse.com/> (TSX:ESL)
As an Amazon Associate we earn from qualifying purchases.