RE: Creating a physical AND Logical file

Sorry, one smiley coming up ... :-) 

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

Since there was no smiley face at the end of your message, I assume
you're serious.  "Procedures, we don't need no stinking procedures."
.-)

And that, dear children, is why I try (though sometimes fail) to code
for just about every eventuality that I can ponder.  I am convinced that
the users actually sit up late at night trying to figure out new ways to
"get" me.

And, when they're not doing that they're doing something worse -
breeding more users.


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



Turnidge, Dave wrote:

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