RE: Embedded sql Set Option on V5R4

["Lim Hock-Chai" <Lim.Hock-Chai@xxxxxxxxxxxxxxx>]

Never understand why sql precompiler needs to check for the placement of
the statement. 

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Tuesday, July 25, 2006 8:44 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Embedded sql Set Option on V5R4

Did you read the V5R4 Memo to Users?  Printed page 45, pdf page 55.
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzaq9/rzaq9.
pdf

IBM DB2 Query Manager and SQL Development Kit for iSeries (5722-ST1)

In V5R4, the ILE RPG precompiler will enforce the rule that the SET
OPTION statement must precede any other SQL statement.

This rule is enforced by the other precompilers available with the IBM
DB2 Query Manager and SQL Development Kit for iSeries product, and has
been previously documented in the DB2 UDB for iSeries SQL Reference
topic: "If embedded in an application program, [the SET OPTION
statement] is not executable and must precede any other SQL statements."

Prior to V5R4, you could have used the SET OPTION statement anywhere in
your application program.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Wagner, Linda" <Linda.Wagner@xxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
07/25/2006 09:10 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
rpg400-l@xxxxxxxxxxxx
cc

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