Re: opnqry file v cpyf

[rob@xxxxxxxxx]

Paul,

There are a thousand ways to handle this.

You can continue to use Query/400.  You may wish to search the archives for
'passing parameters with query'.  I would suggest search MIDRANGE-L and not
the rpg list for a Query question.
http://archive.midrange.com/midrange-l/199912/msg00655.html
http://archive.midrange.com/midrange-l/199806/msg00484.html

You can convert from Query to Query Management.  I had an article published
many moons ago in News/400 on this.

You can use RPG.

You can use embedded SQL in RPG.

And the list goes on...

Rob Berendt

==================
A smart person learns from their mistakes,
but a wise person learns from OTHER peoples mistakes.


                                                                                
                                         
                    "Paul Hepplewhite"                                          
                                         
                    <phepplewhite@madas        To:     <RPG400-L@midrange.com>  
                                         
                    afish.com>                 cc:                              
                                         
                    Sent by:                   Subject:     opnqry file v cpyf  
                                         
                    owner-rpg400-l@midr                                         
                                         
                    ange.com                                                    
                                         
                                                                                
                                         
                                                                                
                                         
                    07/28/2001 07:29 AM                                         
                                         
                    Please respond to                                           
                                         
                    RPG400-L                                                    
                                         
                                                                                
                                         
                                                                                
                                         




hello
when i want to retrieve records from a file with certain criteria is there
a preferred way  rather than using open qry file with selects... perhaps
using cpyf to a file in qtemp and using increl to select records..... as a
novice are there particular performance issues of either way   this relates
to a  particular task where i was asked to  use  query400 (using this file
and another file for the customer name ) to output  a printer file
depending on the user entering date and customer or just date..... or would
doing this in a rpg pgm reading the file have been better
paul h



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