RE: Validating embedded SQL

["Dave Boettcher" <DBoettch@xxxxxxxxxxxxxxxx>]

Definitely handle the error.  Check the SQLCOD and go from there to give
messages back.

my2cents, 

Dave Boettcher

> > > CWilt@xxxxxxxxxxxx 08/10/2006 9:08:06 AM >>>
Well if it we're me.  I'd consider just running it and handling the
error.

But you could look at:
Syntax Check SQL Statement (QSQCHKS) API


HTH,
Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx 
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Beeson, Terry
> Sent: Thursday, August 10, 2006 10:01 AM
> To: RPG programming on the AS400 / iSeries
> Subject: RE: Validating embedded SQL
>
> Hi Charles  
>
> The Statement is dynamic, but the Prepare doesn't perform all the
> validation I need.  If the SQL Statement contains a column 
> that does not
> exist in the table, that error isn't picked up until the Execute.
>
> Any other thoughts?