Re: Re-key PF or LF

Marc,

At 04:20 PM 10/14/98 +0100, you wrote:
>Hello -- here is a little question for all you out in AS/400 land.
>
>Is there a way to key a PF without using a LF and not putting K spec in
the PF ?
>
>Heres what I got.
>1 PF that has over 14000 records in it, of which I want 51.
>so I crtdupobj, and sql the records I need. The RPG prog then 
>needs to read this file with keys. but there arn't any ! Must I 
>create a temp LF or is there a way of using opnqryf (or something)
>that can put the keys into the PF.

 You can either (in no particular order):

1)  Use FMTDTA to create a subset of the file.
2)  OPNQRYF / CPYFRMQRYF to create a subset of the file.
3)  Use OPNQRYF and the RPG cycle.  You can then specify the file as keyed.
 The compiler allows that even though the real file is not keyed!  (Chalk
up another one for the cycle!! - no flames, please.)

 -mark

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *