RE: convert LF's to SQL - LF's have Select/Omit

["Anderson, Kurt" <KAnderson@xxxxxxxxxxxx>]

Keep in mind that if your DDS uses VARLEN, the DDL VARCHAR equivalent will cause the format level IDs to be different.  When I reported this to IBM they said it would not be fixed - I believe because it was the DDS compiler that was buggy. 

-Kurt

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of TheBorg
Sent: Tuesday, April 16, 2013 2:07 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: convert LF's to SQL - LF's have Select/Omit

I believe that the record format id problem was fixed with a PTF, but no doubt Mr. Pence will have something to say about this topic.
-sjl


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

On 4/16/2013 1:53 PM, TheBorg wrote:

> You should probably re-create each of the LF's as a view containing the
> select/omit logic.

I was under the impression I needed my LF's to stay as DDS, so to keep
the FormatID correct... (we don't want to recompile programs...)
I was just going to change the LF's to point to the new SQL table, and
use the FORMAT() keyword to point to the DDS logical, which was the
physical...