By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,418 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

Data type and host variable

P: n/a
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.

Mar 15 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 15 mar, 16:59, "young" <c...@sopragroup.comwrote:
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.
Please ignore this message. The problem was that my host variable was
not in DECLARE section
Thanks

Y.

Y.

Mar 15 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.