|Subject||Re: SP question|
> Your Select...into syntax is incorrect. Move the INTO subclause tothe end and it should work.
Aha! I didn't realise there was such a difference in the syntax
between embedded SQL & ISQL....I was following the wrong examples...
. . .
DECLARE IDMATCH CURSOR FOR
SELECT TESTNO INTO :matchid FROM TEST.EMPLOYEE
WHERE TESTNO > 100;
. . .
The LANGREF.pdf is apparently where I should look in future.
I guess I can't put off any longer figuring out the differences
between SQL, DSQL, ISQL & embedded SQL, so I don't make the same
Thanks to all for your help. Another one step forward, but another 3
miles added to the journey.... ;-)