Re: Creating a physical AND Logical file -- MIDRANGE-L

Alan,

Then why not just use CRTDUPOBJ with DATA(*NO). If you use CRTDUPOBJ for a
logical file and a physical file with the same name as the logical file's
current based on physical file exists in the target library, the new
logical will use the physical file in the target library as its new based on
physical file.

Kind regards,

BJ


On 1/10/07, Alan Shore <AlanShore@xxxxxxxx> wrote:

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.

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