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.
