We've changed our odbc from ascential informix into the newest ibm informix odbc driver 2.90.0000 2.90 TC3. Now we're getting warnings/errors where everything was ok, for instance:
j_0505_0100_data_inicio_processo_20050914..altera_data.update_ctl_pro_exe: DSD.BCIPut call to SQLExecute failed.
SQL statement:UPDATE ctl_pro_exe SET data_inicio_dados = ?, data_fim_dados = ?, data_inicio_pro = ?, data_fim_pro = ? WHERE (cod_processo = ?)
SQLSTATE=22008, DBMS.CODE=-11027
[DataStage][SQL Client][ODBC][Informix][Informix ODBC Driver]Datetime field overflow.
cod_processo = 505
data_inicio_dados = NULL
data_fim_dados = NULL
data_inicio_pro = "2005-09-14 10:00:00.000"
data_fim_pro = NULL
(but if you have a reference/stream odbc stage using the same tables , you can pretty well watch "2005-09-14 10:00.000" using "view data" and in te table the field/attribute is defined to be datetiem year to fraction)
can someone help me ?
informix odbc
Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 12
- Joined: Tue May 31, 2005 5:01 am
Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”
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