SQL data type out of range. SQLSTATE=HY004

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
kanasai167
Participant
Posts: 63
Joined: Mon Sep 12, 2011 2:11 am

SQL data type out of range. SQLSTATE=HY004

Post 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]
Post Reply