doesn't this need to be:

EXEC SQL SELECT ...
FROM ...
WHERE ...
INTO ...

>From: Peter Faulks <pfaulks@...>
>EXEC SQL SELECT i.rating_factor1, rfa.descr, i.rating_factor2, rfb.descr
>INTO :Hid1, :HrtgFDesc1, :Hid2, :HrtgFDesc2
>FROM instable i, rating_factor rfa, rating_factor rfb
>WHERE i.id = :Hid AND rfa.id = i.rating_factor1 AND rfb.id =
>i.rating_factor2;
>
>
>I get SQLCODE of -104 Invalid token
>
>Any Ideas?

_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com