× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. July 2000

RE: Multiple physical logical

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
                                                           


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.