Re: OPNQRYF

["Repaca Chandrashekhar" <repaca@xxxxxxxxxxx>]

You have to do the following.

1. If you want to join two files and no need to have new file, then
   you can just mention whatever the conditions you need in    Query 
selection and give primary file format on FORMAT.

2. If you want to create new join file with selected fields from both      
files, then
    You need to create that file externally with required fileds.
    In FORMAT you give that new file format.
    Match the fields in Join fileds Specifications (2 old files to New 
files)
    Write required condition in Query selection.
    Mention the fields in Key field specifications that will take care of    
     ORDER BY function.

This new file is created in memory and only programs can read this file, we 
can't see records in this file using OPNQRY or SQL.

hope this will help you.

Chandra


>From: Babu Suresh <SureshB@alfuttaim.co.ae>
>Reply-To: RPG400-L@midrange.com
>To: RPG400-L@midrange.com
>Subject: OPNQRYF
>Date: Mon, 2 Aug 1999 18:11:44 +0400
>
>Hi,
>
>
>       I  wanted to know something  in OPNQRYF command. Please help me out.
>
>
>       How to specify a join of two files in this command. What should be
>the value to the parameter FORMAT . I want to select few fields among the
>two files which are joined. If an example is given, it will be very 
>helpful.
>
>       How to specify the ORDER BY clause in this command.
>
>Expecting help.
>
>Thanks
>Sureshbabu
>
>Help Ever . Hurt Never.
>
>+---
>| This is the RPG/400 Mailing List!
>| To submit a new message, send your mail to RPG400-L@midrange.com.
>| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
>| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator: 
>david@midrange.com
>+---END
>


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---END