Re: Supported Syntax in SQLRPGLE in V6R1. Changed?

The SQL Set Option has to appear first in the source when on V5R4.

exec Sql Set Option Commit = *NONE, CloSQLCsr = *ENDMOD;
Brgds
Helge


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Vern Hamberg
Sent: Friday, December 05, 2008 5:38 AM
To: RPG programming on the IBM i / System i
Subject: Re: Supported Syntax in SQLRPGLE in V6R1. Changed?

Pete

There is something about stuff that has to appear first in source now - might have started in V5R4 - I hope this tickles someone's memory. But it is like DECLARE CURSOR and such need to be at the top of the source.

I dunno!

Vern

Pete Helgren wrote:

Well, I don't get it. Seems like there is something different about the way host variables are defined and used since V5R3M0. I went back to using the 270 I have at V5R3M0 so I could get this fix compiled and out to the customer but it is awfully strange that an SQLRPGLE source member from a V5R3M0 box can't be pulled over and compiled in V6R1M0.

Once I get this out to the customer, I'll call IBM. Seems like it would be something simple but after searching all afternoon on the 'Net, I haven't found anything promising.

Pete


Brian Johnson wrote:

On Thu, Dec 4, 2008 at 3:17 PM, Pete Helgren <Pete@xxxxxxxxxx> wrote:

Thanks Brian.

Do you know if host variable use changed in 6.1?

Sorry, I'm not there yet, still working at V5R3. The work-around for the
problem I'm thinking about was to use CRTSQLRPGI GENLVL(30) to accept the
'error' and allow the compile to continue. Perhaps your command default was
changed at V5R3 but hasn't been propagated to the V6 box.