RE: Creating a physical AND Logical file

["Turnidge, Dave" <DTurnidge@xxxxxxxxxxxxxxxxxxxx>]

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