MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2012

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



fixed

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