Re: Can I build a Logical file over a physical file in QS36F?

Pete, Booth

At 8/11/01 05:57 PM -0500, you wrote:
>At 12:53 08/11/2001, Booth Martin wrote:
>
>>Can I build a Logical file over a physical file in QS36F?   The physical 
>>file is a program-described file and I am wondering about creating a 
>>logical over it with the actual field descriptions and then use the 
>>logical as an Externally described file?
>
>You can create a logical, but you'll need derive the key fields as 
>substrings of the alpha dataspace - do a dspffd on the s/36 file to see 
>what I mean. The entire record will be defined as one field, unless it 
>also has keys, in which case those will be split out as separate fields. 
>You could also use the s36ee bldindex procedure, which will do the dirty 
>work for you, and end up creating just such a logical.

  There is another solution.  Create DDS for the file and make it 
externally described.  This will *not* affect existing 36EE programs.  But 
you can then create any regular *LF over it.

  -mark