Hi all,
i have a problem with the DB2 Connector stage on 8.5
We have two systems: Test (is running) and Production (still aborts).
Both systems seems to be identical, but on production i' am not able to load Timestamp fields into the DB2. Error message is following.
Message: DB2_Connector_9,1: SQLExecute reported: SQLSTATE = 40003: Native Error Code = -30.020: Msg = [IBM][CLI Driver] SQL30020N Execution of the
command or SQL statement failed because of a syntax error in the communication data stream that will affect the successful execution of subsequent commands
and SQL statements: Reason Code "0x220A"("0200")"". SQLSTATE=58009 (CC_DB2DBStatement::executeInsert, file CC_DB2DBStatement.cpp, line 576)
SQLEndTran(SQL_ROLLBACK) reported: SQLSTATE = 08003: Native Error Code = -99.999: Msg = [IBM][CLI Driver] CLI0106E Connection is closed.
SQLSTATE=08003 (CC_DB2Connection::rollback, file CC_DB2Connection.cpp, line 1.358)
The DBA told me that this means the value in this field is too long, but on both systems Timestamp is defined "%yyyy-%mm-%dd %hh:%nn:%ss"
Another problem is that i have no access to the systems and i must support via telephon.
If there are any ideas, they are welcome.
Thanks in advance,
Sven
Timestamp into DB2
Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”
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