Re: SQLRPGLE compiles on V5R4 but not on V6R1

David

I'm surprised that compiled at V5R4 - CONST parameters have never worked as host variables. The reason is, they are used to set variables named SQLxxxx where xxxx is some number. And this goes both ways, the SQL* variable is set from the host variable and vice versa. So it can't be a CONST.

The LIKE - well, I find that the pre-compiler likes things pretty simple in your variable declarations. It MIGHT work, but this is kind of messy. Maybe in earlier versions, the LIKE didn't carry the CONST along - maybe at 6.1 it does.

There is usually some additional information in the SQL0312 message - what does it say? As we always say, give us ALL the information!! :-)

HTH
Vern

David.E.Foxwell@xxxxxxxxx wrote:

Hi,

We are migrating to V6R1 and a coworker says this code compiles on the V5R4 box but not on the new one.


SQL0312 Variable wVar not defined or not usable.

P MyProc B
D Parm1 LIKE ( A field in a file declared in the F Specs ) CONST

D wVar S LIKE ( Parm1 )

/FREE
EXEC SQL
SELECT MyField INTO : wVar FROM MyTable
WHERE etc...;


To fix it, wVar was coded like this :
D wVar S LIKE ( A subfield of a global DS )


Any ideas? Thanks.