× 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. MIDRANGE-L
  3. January 2007

Re: Creating a physical AND Logical file

Not if, as Walden pointed out, both the PF and LF are in the same library *and* the PF is copied first. 


        * Jerry C. Adams
*IBM System i5/iSeries Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
        615.995.7024
fax
        615.995.1201
email
        jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



Alan Shore wrote:

Sorry Brian - I think you are wrong as far as the CRTDUPOBJ of the Logical
is concerned.
I THINK (underline this word) that the logical in QTEMP will in fact be
joined to the physical in the PRODUCTION library and NOT the physical in
QTEMP.


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+alanshore=nbty. <midrange-l@xxxxxxxxxxxx> com@xxxxxxxxxxxx cc Subject 01/10/2007 01:41 Re: Creating a physical AND Logical PM file Please respond to Midrange Systems Technical Discussion <midrange-l@midra nge.com> 



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.





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

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.