MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2012

Re: "declare global temporary table" produces different recordformatLevel Id than original file



fixed

Gerald -

The original FAA5905 file has key fields, but having key fields has no bearing on the record format level id.

From what I have learned, the record format level ID is dependent on the
format name and the name, number, placement, length, and attributes of the fields therein.

(NOT whether or not it is a keyed file...)

In other words, if you change any of the following:

1) the record format name specified in the DDS,
2) the name of a field
4) the placement of fields within the file layout
5) length of any field
6) attributes of any field (char, numeric, etc.)

For example:

I created a copy of the DDS used to create FAA5905, except this DDS has NO key fields specified, and when compiled it produces an arrival sequence file which has record format level id of 2729492F22E27, same as the original keyed physical file.

However, I have been wrong on numerous occasions, and I'm sure that someone here will correct me if I am wrong!

- sjl


"Gqcy" wrote in message news:mailman.4529.1349212794.2683.midrange-l@xxxxxxxxxxxx...

Does your MYLIB/FAA5905 file have Keys?
-they don't come across.



On 10/2/2012 4:01 PM, sjl wrote:
;-)


"Dennis Lovelady" wrote in message
news:mailman.4521.1349210699.2683.midrange-l@xxxxxxxxxxxx...

Is there a question in here somewhere?

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"Genius is one per cent inspiration and ninety-nine per cent perspiration."
-- Thomas Edison



(Received the same result on both V5R4M0 and 7.1 systems...)

Permanent file MYLIB/FAA5905 has 19 fields, record length of 133,
record format level identifier 2729492F22E27.

Used green-screen (STRSQL) to execute SQL statement: "Declare global
temporary table FAA5905 like MYLIB/FAA5905"

DSPFD of QTEMP/FAA5905 shows that the file built by the above SQL
statement has 19 fields, record length of 133, but the record format
level identifier is 26F9492F22E27.

( DIFFERENT format level ID...)

- sjl


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact