RE: A really complex SQL statement

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