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

Alan,

Let me make it a little more clearer... :)

CRTDUPOBJ OBJ(MYPHYSICAL) FROMLIB(MYLIB) OBJTYPE(*FILE) TOLIB(QTEMP)
DATA(*NO)
CRTDUPOBJ OBJ(MYLOGICAL)  FROMLIB(MYLIB) OBJTYPE(*FILE) TOLIB(QTEMP)

This will give you a duplicate of your physical in qtemp without any records
and a logical in qtemp that is using the physical in qtemp as its based on
physical file. If you are on a late enough release you can also specify
*LIBL for the FROMLIB parameter.

Kind regards,

BJ

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



Sorry Brian - I need BOTH the physical file AND the logical file to be
present.
The physical file data is loaded based upon the physical files keys, and
then the report is generated based upon the logical files keys.
Convoluted - huh!



Alan Shore

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




            Brian
            <system.i.lists@g
            mail.com>                                                  To
            Sent by:                  "Midrange Systems Technical
            midrange-l-bounce         Discussion"
            s@xxxxxxxxxxxx            <midrange-l@xxxxxxxxxxxx>
                                                                       cc

            01/10/2007 01:21                                      Subject
            PM                        Re: Creating a physical AND Logical
                                      file

            Please respond to
            Midrange Systems
                Technical
               Discussion
            <midrange-l@midra
                nge.com>






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