I probably should never have read Joe's introduction to REXX, as it's been there longer than me and I've got by up till now without it. But I did and so now come the problems.
What's wrong with my first ever REXX procedure ? :
ADDRESS EXECSQL,
"EXECSQL",
" INSERT INTO QTEMP/ADHRBT ",
" SELECT ADHRBT.* FROM ADHRBT JOIN PAFMT00 ON PA0COP =RRDTID ",
" AND PA0TYP = 'INITIA' ORDER BY SUBSTR(PA0LIB, 68, 4)"
IF RC < 0 THEN SAY SQLCODE
I was getting SQLCODE -206 so I put up double quotes, now I'm getting SQLCODE -7008.
Have checked the corresponding SQL0206 and SQL7008 messages.
TIA.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
