Re: Funky SQL

James,

I was going to suggest that if you had a newer box you could try the 
following API
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/info/apis/qsqchks.htm

One of the parameters is to what release you want to syntax check the 
statement to.  However I was a little surprised that the V5R3 infocenter 
only listed these possible values:
Target release. The target release for which the statement should be 
syntax checked. If the statement cannot be taken back to the release 
specified, SQL7906 will be returned in the statement information. The 
default is the current release. Valid values include the following:

V2R3M0 The target release is Version 2, Release 3, Modification 0. 
V3R0M5 The target release is Version 3, Release 0, Modification 5. 
V3R1M0 The target release is Version 3, Release 1, Modification 0. 
V3R6M0 The target release is Version 3, Release 6, Modification 0. 

I did click on the pencil icon and question infocenter on this.

Perhaps if write up an interface to this api then I, or the gent from CA 
who is having a tough time with it, could test it out for you.  A google 
search showed that Jorge Moreno expressed an interest in it in 2001. 
Perhaps he has a sample.  He's a regular on these lists.

Rob Berendt