On Wed, 03 Apr 2002 09:11:38 +0000 "Nick Upson" <uebridger@...>
wrote:

>
> doesn't this need to be:
>
> EXEC SQL SELECT ...
> FROM ...
> WHERE ...
> INTO ...

No, SELECT... INTO... FROM.... is definately correct

I have other statements (both cursors and single selects) that work fine.
There is just someting screwy about that particular statement. And yes,
all the host variables have been declared, and set as neccessary.

Regards