MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2012

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



fixed

Gerald -

I didn't have an identity or nullable fields...

By using:

Declare global temporary table FAA5905 like MYLIB/FAA5905
RCDFMT IAA5905

the temporary file now has the same record format level id as the original.

However, it appears that the safe route to take is combining all of these options:

Declare global temporary table FAA5905 like MYLIB/FAA5905
INCLUDING IDENTITY COLUMN ATTRIBUTES
INCLUDING COLUMN DEFAULTS
RCDFMT IAA5905

Thanks!

- sjl

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

I got my example working with adding:
RCDFMT (your_FAA5905_record_format_name)

to Charles' example


On 10/2/2012 4:03 PM, Charles Wilt wrote:
try adding the "copy options"

Declare global
temporary table FAA5905 like MYLIB/FAA5905
INCLUDING IDENTITY COLUMN ATTRIBUTES
INCLUDING COLUMN DEFAULTS

HTH,
CHarles

On Tue, Oct 2, 2012 at 4:08 PM, sjl<sjl_abc@xxxxxxxxxxx> wrote:
(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