Re: REXX here we go

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

David FOXWELL wrote:
> 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.
>   
It sounds like you're getting there, David.  You fixed the -206 error, 
now you're trying to figure out the -7008 error.  What's the 
second-level text for the SQL7008 error?

Joe