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



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 creating the 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, I explicitly name QTEMP. At the end of the process (even if it's a submitted 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
a
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
a
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
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 ...

Follow-Ups:
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.