Data type and host variable

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

young - 15 Mar 2007 16:59 GMT

Hello all,
I tried to do a sqc program with a "SELECT column INTO :host_variable
FROM table" statement and got an error SQL4942N="The statement
selects an incompatible data type into host variable"
My column is Decimal(6,2) data type definition, and my host variable
is defined as float

I work on AIX 5.2 with DB2 8.2
Any idea?

Thanks for your help

Y.

Reply to this Message

young - 15 Mar 2007 17:28 GMT

> Hello all,
> I tried to do a sqc program with a "SELECT column INTO :host_variable
[quoted text clipped - 9 lines]
>
> Y.

Please ignore this message. The problem was that my host variable was
not in DECLARE section
Thanks

Y.

Y.

Reply to this Message