RE: add file with same name from different AS/400 into pgm

["Stone, Joel" <StoneJ@xxxxxxxxxxxxxxxx>]

Title: RE: add file with same name from different AS/400 into pgm

Thanks for the idea, but Im pretty sure the RENAME fails because there are two files with the same format, and RPG cant figure out which one to rename.

Is this correct?

Any other ideas?

-----Original Message-----
From: Hartman Richard [mailto:richard.hartman@brctsg.com]
Sent: Wednesday, January 26, 2000 7:06 PM
To: 'RPG400-L@midrange.com'
Subject: RE: add file with same name from different AS/400 into pgm

You can try renaming the record format of the file in the file definition
section of the program. You add    RENAME(formatname:formatname2) in the key
words section. 
This is what we do when we use two logical files in our program, that are
based off of the same file.
 I do not know if this works for physical files or not?

Then if you had the same field names in both files you could add a prefix to
the fields on one of the file specs by doing:
PREFIX(xx)

I don't know if this will work for your problem. But it is the best I can
offer at the time.
Richard

> -----Original Message-----
> From: Stone, Joel [SMTP:StoneJ@GourmetAward.com]
> Sent: Wednesday, January 26, 2000 4:29 PM
> To:   'RPG400-L@midrange.com'
> Subject:      RPG: add file with same name from different AS/400 into pgm
>
> I need to add an order file to a inquiry RPG pgm.  The file has the same
> name as a file already in the pgm.  What is an easy way to accomplish
> this???
>
> Only one of the files must be open at any point in time, but a user could
> look at one file and then the other in the same session.
>
> Call qcmdexc to ovrdbf and re-open the file with each read to the orders?
>
> Note: I dont think I can use an LF to combine the files, because the
> second file is on another box using DDM, which is sometimes down.  If the
> DDM file is down, I still want the user to be able to see his local
> orders!
>
> Thanks!
>
+---
| 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
+---