RE: Chain

Yes,
We need to see what your example is.  For example you say 
that you have two files and the one you are trying to chain 
to is multiple keyed, but a different keyed sequence.  Give 
us a sample layout, like:

FILEA
        FIELDA1
        FIELDA2
        FIELDA3
        ...
FILEB
        FIELDB1
        FIELBB2
        FIELBB3
Which field from FILEA is trying to chain to which field in 
FILEB?  And what are the key(s) on FILEB?





DBale@lear.com on 05/15/2000 11:43:47 AM
Please respond to RPG400-L@midrange.com@Internet
To:     RPG400-L@midrange.com@Internet
cc:      
Fax to: 
Subject:        RE: urgent

I am not absolutely clear on what you need to do.  But it sounds like what
you're looking to do is to logically join two files.  Short of defining a
new logical file, your options include using OPNQRYF or SQL, possibly even
WRKQRY if you're just creating a report.  If you have more questions on
these, please be more specific about your requirements.  Are you updating
anything?  Is this a report program, interactive inquiry, etc.?  

- Dan Bale

> -----Original Message-----
> From: SAJIV NS [SMTP:saj831@hotmail.com]
> Sent: Monday, May 15, 2000 8:04 AM
> To:   RPG400-L@midrange.com
> Subject:      urgent
> 
> Hi
> 
> 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?
+---
| 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
+---


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