RE: Add flattened subfields after likeds

Try adding 'qualified' to the xds definition and see if that fixes it.

Scott

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Friday, September 26, 2014 1:28 PM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: Re: Add flattened subfields after likeds


It just seems to have a problem with that extra field.
D aaakeyds e ds extname(aaakey) qualified
d xds ds likeds(aaakeyds)
d mysubfield 3p 0
/free
exec sql
select comp into :xds.mysubfield
from aaakey
where comp=1;
xds.mysubfield+=1;
exec sql
update aaakey
set comp=:xds.mysubfield
where comp=:xds.mysubfield-1;
*inlr=*on;
return;
/end-free

From listing:

select comp into :xds.mysubfield
SQL0312: Position 32 Variable MYSUBFIELD not defined or not usable.
SQL0312: Position 28 Variable XDS not defined or not usable.