Re: A really complex SQL statement

[John Earl <johntearl@xxxxxxxxxxxxx>]

I don't see the conflict Neill.  My COBOL skills are primitive too, but 
I'm quite accomplished at securing COBOL programs.  My JAVA skills are 
non-existent, yet I've secured or help secure many JAVA applications.  
Over the last decade my RPG and CL skills have atrophied a bit, but 
still I've secured thousands of those programs.

One does not to be a master of the READE statement to comprehend the 
implications of securing the underlying database file.

IMHO,

jte


Neill Harper wrote:
> You are writing an article on securing SQL and your SQL skills are
> primitive?
>
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John Earl
> Sent: 02 June 2009 18:16
> To: midrange-l@xxxxxxxxxxxx
> Subject: A really complex SQL statement
>
> Hey list,
>
> I'm writing an article on securing SQL and I'm looking for a really, really,
> long and complex SQL statement.  Unfortunately my own SQl skills are kind of
> primitive, so I don't know how to generate this statement with the correct
> syntax.
>
> So, has anyone got a copy of one that has multiple file names, multiple 
> SELECT and UPDATE or DELETE statements, etc etc.   The goal is not 
> "un-readability", but rather complexity specifically as it relates to
> multiple tables and verbs in one statement.
>
> Any and all assistance is greatly appreciated,
>
> aTdHvAaNnKcSe,
>
> jte
>
>