RE: Multiple physical logical

["Richard Jackson" <richardjackson@xxxxxxxxxxxxxxxxxx>]

Title: Multiple physical logical

Leave the F4211 format name alone.  In the DDS, rename the F42119 format to something else.  In the program, when you do IO to the logical file, use the file name, not the record format name.  You may need to provide key lists for both files.  I don't think that you will have to change the field names. 

 

If you are trying to use your logical for an inquiry over union of the open and closed order files (I recognize the names, I used to work for your application vendor), be careful when using the query tools like OPNQRYF and SQL.  If your query is implemented using a union with select and order by (in the SQL form "SELECT ... FROM F4211 WHERE ... UNION SELECT ... FROM F42119 WHERE ... ORDER BY ...") and if those files are large, you may not like what this does to your system performance.  In fact, I can almost guarantee that you won't like it. 

 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Richard Jackson
mailto:richardjackson@richardjackson.net
http://www.richardjacksonltd.com
Voice: 1 303 808 8058
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

-----Original Message-----
From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On Behalf Of Schlemme, Michael C.
Sent: Wednesday, July 26, 2000 10:08 AM
To: RPG400-L@midrange.com
Subject: Multiple physical logical

Dear List,     

Here are the details connected to a problem I'm having:
                               
1.  I have a logical build over 2 physicals (open and history).  The DDS follows...

     File X

A          R I4211                     PFILE(F4211)               
A                                          PFILE(F42119)              
A          K SDDOCO                                               
A          K SDLNID           

    Creating the file this way merges the both files using one record format.

2.  When I try to create an RPG400 (not ILE), the compile fails saying the following,
     Message . . . . :   Record-format name in externally-described-logical file already defined in file.
    
     I've tried renaming, but without any success.

Any ideas ????????

Thanks