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]
SQL data type out of range. SQLSTATE=HY004
Infosphere's Quality Product
-
- Participant
- Posts: 63
- Joined: Mon Sep 12, 2011 2:11 am
Jump to
- Moderators' Choice
- ↳ Editor's BLOG Corner
- ↳ Ask the Experts! - Dads and Grads
- ↳ DSXchange Testimonials
- ↳ Cognos (IBM BI)
- FAQs
- ↳ FAQs
- ↳ FAQ Discussion
- DataStage
- ↳ General
- ↳ IBM<sup>®</sup> Infosphere DataStage Server Edition
- ↳ IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- ↳ Archive of DataStage Users@Oliver.com
- IBM<sup>®</sup>Infosphere Products<sup></sup>
- ↳ Business Glossary
- Suggestions
- ↳ Site/Forum
- ↳ Enhancement Wish List
- Consulting
- ↳ Talent
- ↳ Looking for Talent
- Support
- ↳ Parameter Manager
- ↳ Compile All Plus
- Usergroup Forums
- ↳ Usergroup Central Forum
- ↳ Heartland Usergroup Forum
- The Written Word
- ↳ Articles, White Papers and Tips and Tricks
- ↳ Product Documentation
- Third Party Applications
- ↳ Third Party Applications
- Product Derivatives
- ↳ Functions
- ↳ Routines
- ↳ Jobs
- ↳ Logs
- Tools
- ↳ Tools Forum
- Category
- ↳ Infosphere Master Data Management
- ↳ Data Quality Best Practices
- ↳ IBM QualityStage
- ↳ Information Analyzer (formerly ProfileStage)
- ↳ IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- ↳ IBM<sup>®</sup> DataStage TX
- ↳ BI
- ↳ Data Integration