× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.