Page 1 of 1

SQL data type out of range. SQLSTATE=HY004

Posted: Mon Jan 09, 2012 5:33 pm
by kanasai167
DB2_Connector_10: SQLGetTypeInfo reported: SQLSTATE = HY004: Native Error Code = -99,999: Msg = [IBM][CLI Driver] CLI0123E SQL data type out of range. SQLSTATE=HY004 (CC_DB2Utils::getNativeDBType, file CC_DB2Utils.cpp, line 295)


im doing a unduplicate match job , when i link the output of unduplicate match to db2 connector , then i got this error.
But after i change the db2 connector to a sequential file , the job run successfully.

I google out the code and i got this
https://www-304.ibm.com/support/docview ... wg21081165
im using db2 9.7.

by the way , i encounter the same error also for match frequency.[/url]