RE: Embedded sql Set Option on V5R4

["Bob Cozzi" <cozzi@xxxxxxxxx>]

Wow! This seems completely backwards from what was supposed to happen.
Prior to r4, the precompiler used the physical sequence of the SQL in your RPG
source member to generate such errors. In r4, it was supposed to allow you to
specify things in a logical sequence, such as inside of *INZSR. 
I'm surprised it used to work for you.

-Bob Cozzi

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On
Behalf Of Wagner, Linda
Sent: Tuesday, July 25, 2006 8:11 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Embedded sql Set Option on V5R4

We have a lot of sqlrpgle programs that use the Set Option in the *inzsr.
Everything worked fine until we upgraded to V5R4 and we get pre-compiler
errors.  The only way around this is if we remove the code from the inzsr
and add it before any sql code.  We put it in the inzsr so we'd be sure it
always ran before any other sql code.  Does anyone know if there's anyway
around this or are we stuck changing all of our programs before the next
time we compile them?

 

Thanks.

Linda Wagner