Re: Creating a physical AND Logical file

The physical file is already keyed. The logical is a different key.
These files already exist, and are being used to supply monthly totals.
However the user wants to be able to create the same reports but specifying
from and thru dates of their own (which may be from the middle of one month
to the middle of this month etc etc)
So to keep things on an even keel, I am creating these files (on the fly)
in QTEMP, but the PRODUCTION files exist in the PRODUCTION library.
Therefore - I CANNOT change the DDS.
Hence my question



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx



                                                                       
             Wayne McAlpine                                            
             <wayne.mcalpine@s                                         
             os.louisiana.gov>                                          To
             Sent by:                  midrange-l@xxxxxxxxxxxx         
             midrange-l-bounce                                          cc
             s@xxxxxxxxxxxx                                            
                                                                   Subject
                                       Re: Creating a physical AND Logical
             01/10/2007 11:54          file                            
             AM                                                        
                                                                       
                                                                       
             Please respond to                                         
             Midrange Systems                                          
                 Technical                                             
                Discussion                                             
             <midrange-l@midra                                         
                 nge.com>                                              
                                                                       
                                                                       




Your DDS can specify a qualified name for the physical file.  If you're
creating the physical file using DDS specs, why not just make the
physical file a keyed file?  That way you wouldn't have to create a
separate logical.

That having been said, it seems to me that a compiled object is not the
best way to retrieve data from your physical file.  Consider using the
OPNQRYF command in a CL program to accomplish the same thing "on the
fly."

Alan Shore wrote:

Mornin' everyone.
Here is my predicament
I need to create a physical file PHYSFILE in QTEMP using the CRTPF. This

is

no problem.
I then need to create a Logical LOGFILE (also in QTEMP) against this
Physical PHYSFILE in QTEMP.
Heres where the problem lies.
The Logical that is created is against a physical file of the same name
PHYSFILE that is in an earlier library on the library list.
How can I create the logical LOGFILE against the physical PHYSFILE that
resides in QTEMP?



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.