RE: Re-key PF or LF

[Buck Calabro <mcalabro@xxxxxxxxxxxx>]

On Wednesday, October 14, 1998 11:20 AM, ikat@dircon.co.uk 
[SMTP:ikat@dircon.co.uk] wrote:
> 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.

If the RPG is simply reading the selected records input primary,
1) Use the ORDER BY clause of SQL to order the records as they are 
selected.

If the RPG needs to CHAIN/SETLL the selected records by key,
1) Skip the CRTDUPOBJ/SQL bit and use OPNQRYF.
2) Skip the CRTDUPOBJ/SQL bit and use embedded SQL in your RPG program.

Buck Calabro
Commsoft, Albany, NY
mailto:mcalabro@commsoft.net

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* 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          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *