RE: CHAIN in RPG WAS:urgent

[Buck Calabro <buck.calabro@xxxxxxxxxxxxxxxxx>]

SAJIV NS wrote:

>I need to chain a field in a file(non-keyed) with a field in another
>file(multiple keyed), but having different keyed sequence. Creating a new
>logical file is not allowed.  Can you help me out?

Could you post the specific business problem that you are trying to solve?
Without that, suggestions can only be guesses.  There are several options
available to you; embedded SQL, loading the file to be searched into a
table/array, using OPNQRYF/CHAIN or a brute force READ/compare.  Of course,
DSPDBR might turn up a logical file that is already available!

Buck Calabro
Aptis; Albany, NY
The IBM manuals for the AS/400 are on-line at http://www.as400.ibm.com
Follow the Library link.
+---
| 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
+---