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

Easy to say - unless the guy running the queries is your boss .-)


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



Holden Tommy wrote:

Simple answer...why allow users to have access to QRY/400... I
definitely wouldn't give unfettered access to SQL.  If they really have
to have output to a file...then write a quick program for production.
If it's a one-off deal run the SQL or query & give them access to the

file. Not only is that safer...it's job security ;-)


Thanks,
Tommy Holden


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jerry Adams
Sent: Friday, January 12, 2007 10:31 AM
To: Midrange Systems Technical Discussion
Subject: Re: Creating a physical AND Logical file

If it's under program(mer) control, Tommy. But if the user is creatingthe file on-the-fly, say from a Query (as you pointed out earlier), "Oh,


I'll just call it CUSTMAST."  Duh...

Personally, when I want to create and/or reference a table in QTEMP, Iexplicitly name QTEMP. At the end of the process (even if it's asubmitted job), I whack it from QTEMP.


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



Holden Tommy wrote:

This is why at the end of processing of the temporary file it should

be

deleted from QTEMP explicitly...which is the standard here.  At the

end

of every process that uses QTEMP for "on the fly" files it has to be

deleted at the end of that job stream.

Thanks,
Tommy Holden

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: Friday, January 12, 2007 9:22 AM
To: Midrange Systems Technical Discussion
Subject: RE: Creating a physical AND Logical file

Dave - with users signing on the first thing in the morning and not
signing
off till they leave (sometimes they forget) and doing a multitude of
tasks
throughout the day, creating a multitude of temporary files form
different
jobs that they run, QTEMP will always be present. Now the chances that

file created in QTEMP from a program written by programmer Fred Bloggs
has
exactly the same name of a file from a different program written by

Joe

Schmo  are slim, however, that being said, I can verify that in one of
my
earlier positions, this has happened three times. The first 2 times,

we

couldn't duplicate the problem the user was seeing. The third time we
drove
over to her office and lo and behold, the program was picking up a
temporary file that had been created in QTEMP (which was at the top of
her
library list) with the same name as a PRODUCTION file in the

PRODUCTION

library list. At that shop it was determined that QTEMP should be

placed

at
the bottom of the library list, and if a temporary file needs to used,
define the library name QTEMP as well.



Alan Shore

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


midrange-l-bounces@xxxxxxxxxxxx wrote on 01/12/2007 10:02:49 AM:

I guess in 35+ years I've never written ANYTHING that expected QTEMP

to

be anywhere but at the top. Currently we create application data

areas

that are created from template data areas in "production". The QTEMP
ones are changed to match the current needs of the job. Job ends -

data

areas gone. No *LIBL issue at all. If QTEMP doesn't contain

information

that is supposed to be unique to that specific job I don't see any

other

purpose for it.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: Friday, January 12, 2007 8:48 AM
To: Midrange Systems Technical Discussion
Subject: RE: Creating a physical AND Logical file

For the reason that I am trying to circumvent If you have to specify

distinct file, with a distinct library, which would you use
QTEMP/LOGICFILE which will only pertain to that jobs QTEMP library or
PRODUCTION/LOGICFILE. Where the name of that library may ( not
necessarily though) change in the future.

For example if your library list is
QTEMP
PRODUCTION
2NDPRODLIB
etc
etc

and you specified
*LIBL/LOGICFILE
QTEMP library is the first library that is going to looked at, and as
this library is the one that is going to house "temporary" files that
are built on the fly, are you sure that library is the one you are

going

to look at?
Hence the reason why QTEMP is last (or at least near the bottom) of

the

library list.
If you want to use the temporary LOGICFILE, there is no problem (at
least in my eyes) to specify the library QTEMP/LOGICFILE, and then I
know that *LIBL/LOGICFILE is going to use a PRODUCTION file (if one
exists).



Alan Shore

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


midrange-l-bounces@xxxxxxxxxxxx wrote on 01/12/2007 09:36:10 AM:

Wow! QTEMP is ONLY used by the current job. Objects in that library
have to be created BY that job for use by that job ONLY. We ALWAYS
have QTEMP at the top of the user portion of the library list. I

don't

know of ANY value for QTEMP that would place it at the end of the
list... ???  What am I missing here??

Dave

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: Friday, January 12, 2007 8:29 AM
To: Midrange Systems Technical Discussion
Subject: RE: Creating a physical AND Logical file

Thanks for your reply Steve
I'm not saying QTEMP cannot be at the top of the library list. I t
looks like I will have to move QTEMP to *FIRST, create the logical<
and move it back to the *LAST. QTEMP being the last in the library
list is just a "rule" at our shop.

Alan Shore

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

midrange-l-bounces@xxxxxxxxxxxx wrote on 01/12/2007 01:51:28 AM:

Why can't QTEMP be at the top of your library list? I have always
thought that because of what it is that is the ideal place for it

to

be.

Steve

-----Oorspronkelijk bericht-----
Van: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]Namens Alan Shore
Verzonden: donderdag 11 januari 2007 22:10
Aan: Midrange Systems Technical Discussion
Onderwerp: RE: Creating a physical AND Logical file


Sorry Charles - no go
I end up with the same problem.
Just doesn't like the situation.
I may have to do what someone else has suggested and move the
library

QTEMP

to the top of the library list, create the logical and move QTEMP

back.

There must be some other way to do this. I've got to be doing
something wrong.



Alan Shore

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

midrange-l-bounces@xxxxxxxxxxxx wrote on 01/11/2007 03:27:46 PM:

So just ADDLFM..

Not a big deal, the important thing is that the logical in QTEMP
is pointing to the physical in QTEMP.

Charles Wilt
--
iSeries Systems Administrator / Developer Mitsubishi Electric
Automotive America
ph: 513-573-4343
fax: 513-398-1121

-----Original Message-----
From: midrange-l-bounces+cwilt=meaa.mea.com@xxxxxxxxxxxx
[mailto:midrange-l-bounces+cwilt=meaa.mea.com@xxxxxxxxxxxx]
On Behalf Of Alan Shore
Sent: Thursday, January 11, 2007 3:18 PM
To: Midrange Systems Technical Discussion
Subject: RE: Creating a physical AND Logical file

Thanks NIck - I've already tried that, with the result that

the

logical has NO members.
What release are you on? We are on V5R4. Like I've said

before,

maybe its a PTF I need



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
midrange-l-bounces@xxxxxxxxxxxx wrote on 01/11/2007 03:11:22

PM:

Hi Alan,

Then how about this:


CRTLF FILE(QTEMP/CCA012L1) SRCFILE(XALIB/QDDSSRC)
DTAMBRS((QTEMP/CCA012PF(CCA012PF)))

Instead of specifing DTAMBRS(*ALL), put in your QTEMP/PF
FILE(PF

MBR

NAME)

This works on my system.   I have done this for years this

way.

Good Luck,

Nick



Nick Radich
Sr. Programmer/Analyst
EPC Molding, Inc.
Direct  (320) 679-6683
Toll free  (800) 388-2155  ext. 6683 Fax  (320) 679-4516
nick_radich@xxxxxxxxxxxxxx



Alan Shore <AlanShore@xxxxxxxx> Sent by:
midrange-l-bounces@xxxxxxxxxxxx
01/11/07 01:23 PM
Please respond to
Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxx> cc

Subject
RE: Creating a physical AND Logical file






Thanks Nick, but unfortunately that picks up the physical

file

that resides in an earlier library on the library list



Alan Shore

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

midrange-l-bounces@xxxxxxxxxxxx wrote on 01/11/2007 02:18:38

PM:

Alan,

Try this:

CRTLF FILE(QTEMP/PHYSFILE) SRCFILE(PRODUCTION/QDDSSRC)

DTAMBRS(*ALL)

HTH,

Nick



Nick Radich
Sr. Programmer/Analyst
EPC Molding, Inc.
Direct  (320) 679-6683
Toll free  (800) 388-2155  ext. 6683 Fax  (320) 679-4516
nick_radich@xxxxxxxxxxxxxx



Alan Shore <AlanShore@xxxxxxxx> Sent by:
midrange-l-bounces@xxxxxxxxxxxx
01/11/07 01:05 PM
Please respond to
Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxx> cc

Subject
RE: Creating a physical AND Logical file






Hello everyone
IIIIII'MMMMMM baaack
Okay - due to auditing constraints and other things, I am

not allowed
to

use CRTDUPOBJ
So - I am trying the suggestion put forth by Clyde, and I

am having

problems
I am creating a physical file in QTEMP

CRTPF FILE(QTEMP/PHYSFILE) SRCFILE(PRODUCTION/QDDSSRC)

SRCMBR(PHYSFILE)

and I can populate this file no problem

Then when I create the logical

CRTLF FILE(QTEMP/LOGFILE) DTAMBRS((QTEMP/PHYSFILE)) The
logical file gets created but with NO member The error

that

occurs is File PHYSFILE in QTEMP on DTAMBRS not valid.
An F1 on this message shows
 Message ID . . . . . . :   CPF7356       Severity . . .

. . . . :   30

 Message type . . . . . :   Information
 Date sent  . . . . . . :   01/11/07      Time sent  . . .

.
:

13:58:48
 Message . . . . :   File SLSCOMP in QTEMP on DTAMBRS not

valid.

 Cause . . . . . :   File SLSCOMP in library QTEMP on the

DTAMBRS

parameter
is
   not valid. The physical files on the DTAMBRS parameter

must match
the

   physical files on the PFILE or JFILE keywords in the

DDS for the

logical
   file. In addition, the physical file names cannot be

specified more

often on
   the DTAMBRS parameter than on the PFILE or JFILE

keywords in the DDS

for
the
   logical file.
 Recovery  . . . :   Change the DTAMBRS parameter so the

file names

match

the
   names on the PFILE or JFILE keywords in the DDS for the

logical

file.

Then
   try the request again.
 Technical description . . . . . . . . :   If a library

name was not

specified
   for the physical files on the PFILE or JFILE keywords

in the DDS for

the
logical file, the library list (*LIBL) was used to find

the physical

files.
The physical files specified on the DTAMBRS parameter

must match the

physical files found in the library list.

The name on the DDS is PHYSFILE - so right now I am

drawing a blank on

this

ANY help with this would be greatly appreciated.

Thanks in advance



Alan Shore

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


midrange-l-bounces+alanshore=nbty.com@xxxxxxxxxxxx wrote

on 01/10/2007

12:02:23 PM:

Use the command:

CRTLF FILE(QTEMP/LOGFILE) DTAMBRS((QTEMP/PHYSFILE))

Clyde

-----Original Message-----
From: Troy Foster [mailto:tfoster@xxxxxxxxxx]
Sent: Wednesday, January 10, 2007 10:52 AM
To: Midrange Systems Technical Discussion
Subject: Creating a physical AND Logical file

A          R HDR810

PFILE(POLIB/EDIP810H)

A          K IVNUMB

Troy Foster wrote:

Make sure that your logical points to the PHYSFILE  in

QTEMP.

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 e-mail and any files
transmitted with it are confidential and are intended

solely

for

the use of the individual or entity to whom they are
addressed. If you are not the original recipient or the
person responsible for delivering the

e-mail

to
the

intended
recipient, be advised that you have received this

e-mail in error,

and that any use,

dissemination, forwarding, printing, or copying of this

e-mail is

strictly prohibited. If you
received this e-mail
in error, please immediately notify

Postmaster@xxxxxxxxxxxx

Woodhead Industries, Inc. and its affiliates reserve the
right to monitor all internal and external

communications

at

any time.


***
WARNING *** Any email correspondence including responses

to

this

email

with

Woodhead Industries Inc
or any of its subsidiaries will be scanned for Viruses

and

content deemed inappropriate by Woodhead Industries Inc.

**************************************************************
************************************

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

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

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.