Re: urgent

[Jim Langston <jlangston@xxxxxxxxxxxxxxxx>]

Hmm.. let me see if I got this straight.  You have two files, file-a and
file-b.  You then want every record in file-a that has a field the same
as a certain field in file-b.  Neighter of them are keyed on this field,
and you can't create a logical.

Query would work.  SQL would work.  Inbedded SQL is probably
your best bet. My SQL is a bit rusty, but it basically becomes: SELECT
ALL FROM FILEA WHERE FILEA->FIELD1 = FILEB->FIELD1
(syntax is way off on that, but you get the general gist I think)

Regards,

JIm Langston

SAJIV NS wrote:

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