Re: Supported Syntax in SQLRPGLE in V6R1. Changed?

Pete

The manual that will tell you about host variables is not the SQL Reference, it is the Embedded SQL Programming manual - that is the title at V5R4 - man, I hate having to worry about titles at different releases!!! A rose by any other name - sheesh! It's rant day for me, I guess.

Anyhow, here is a paragraph that might help -

"If an error stating that a host variable is not defined or not usable is issued, look at the cross-reference in the precompiler listing to see how the precompiler defined the variable. To generate a cross-reference in the listing, run the precompile command with *XREF specified on the OPTIONS parameter."

That is in a section called "Using host variables in ILE RPG applications that use SQL"

You should probably also look at the V6R1 equivalent, then combine the rules!!

HTH
Vern

Pete Helgren wrote:

Even if none were ever used before? That is, is the Set Option now a required entry in an SQLRPGLE program? I usually set the options at compile time.

Pete


Helge Bichel wrote:

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.