RE: Creating a physical AND Logical file

Hopefully your boss is in favor of procedures, and in favor of following
them... 

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

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