In my eval statement
eval M_MSGDATA
=
%trim(%editw(+
X_AUTHAXY:' , , , , , 0 . -'))
if you observe there are two spaces after period in in the above statement
0.(space)(space)-')
SELECT NUMBER FROM DLESTER/RSFILE WHERE CURRENCYISOCD = 'USD'
this gives value for NUMBER.
I want to insert the value of select statement in the two spaces after point (0 . -'))
My program is RPGLE, Iam making it SQLRPGLE by inserting above SQL line.
Please help me with the logic I need to make it work.
Thanks for your help
Donna.
eval M_MSGDATA
=
%trim(%editw(+
X_AUTHAXY:' , , , , , 0 . -'))
if you observe there are two spaces after period in in the above statement
0.(space)(space)-')
SELECT NUMBER FROM DLESTER/RSFILE WHERE CURRENCYISOCD = 'USD'
this gives value for NUMBER.
I want to insert the value of select statement in the two spaces after point (0 . -'))
My program is RPGLE, Iam making it SQLRPGLE by inserting above SQL line.
Please help me with the logic I need to make it work.
Thanks for your help
Donna.
Comment