RE: Chain

[Rob Berendt <rob@xxxxxxxxx>]

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