RE: format level different with dds/SQL

The DDS compiler has a bug in it when determining the record format level when there is a varying field in the file. SQL creates the format correctly. IBM won't fix this for fear of breaking customers' programs. Not sure if that's the cause of your issue.

-Kurt

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Friday, June 08, 2012 11:14 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: format level different with dds/SQL

On 08 Jun 2012 02:54, Dave wrote:

I wanted to avoid using OPNQRYF and did this:

CREATE TABLE QTEMP/mytable AS
(SELECT * FROM myfile ORDER BY myfield) WITH DATA RCDFMT
myfile_formatname

Making a full permanent [irrespective of "QTEMP"] copy of the data into QTEMP, just to create an ordered copy :-( Sometimes avoidance should be avoided ;-)

But the format levels of mytable and myfile are not the same, despite
using RCDFMT.
Why?

That depends... on what is the exact definition and origins of MYFILE. One example, defaults and identity attributes would not be included in the new TABLE using the given syntax.

Regards, Chuck
--
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.