RE: A really complex SQL statement

["Neill Harper" <neill.harper@xxxxxxxx>]

Agreed, no conflict... 

I didn't get the scope, this is equivalent to "I know nothing about engine
immobilizers but I can sell you a great lock for your garage" sort of thing.

You are not talking about sql injection attacks and the like?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John Earl
Sent: 02 June 2009 20:10
To: Midrange Systems Technical Discussion
Subject: Re: A really complex SQL statement

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