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

;-)


"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.