Hi, I'm new to "modern" RPG, and trying to learn.
I have some code giving the error "Column or global variable VARXYZSav not found.
In my code, I thought I defined it properly:
dcl-s VARXYZSav zoned(5 : 0);
But getting the error here:
exec sql
set VARXYZSav = :VARXYZ;
SQL0206 Position 18 Column or global variable VARXYZSav not found.
==== I also get the error Here with a different field. Trying to update a column in a table from another column in the same table
exec sql
UPDATE TABLEA
SET Field1# = Field2
SQL0206 Position 18 Column or global variable Field2 not found.
WHERE ........
Thanks in advance
I have some code giving the error "Column or global variable VARXYZSav not found.
In my code, I thought I defined it properly:
dcl-s VARXYZSav zoned(5 : 0);
But getting the error here:
exec sql
set VARXYZSav = :VARXYZ;
SQL0206 Position 18 Column or global variable VARXYZSav not found.
==== I also get the error Here with a different field. Trying to update a column in a table from another column in the same table
exec sql
UPDATE TABLEA
SET Field1# = Field2
SQL0206 Position 18 Column or global variable Field2 not found.
WHERE ........
Thanks in advance
Comment