> Your Select...into syntax is incorrect. Move the INTO subclause to

the 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...

EMBEDSQL.pdf says:
. . .
EXEC SQL
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
mistake again.

Thanks to all for your help. Another one step forward, but another 3
miles added to the journey.... ;-)
Cheers,
Steve