Re: SQLRPGLE compiles on V5R4 but not on V6R1

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

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.
>