Hello! I am now having a problem with timestamp datatypes in SQL Server and DataStage.
Both my source and target tables are SQL Server tables, and each has a field that is of smalldatetime, size of 4. When I read the metadata in for these tables, DataStage translated a smalldatetime of 4 to a timestamp of 16.
If I change the metadata in my source and target stages to be a timestamp of size 4, it tells me that there is a metadata mismatch. If I leave everything as a timestamp of 16 in DataStage, I then get the error message that there is an "invalid cast character". I tried using the Oconv/Iconv to see if that would help, but it didnt.
Any ideas?
Thank you so much!!
Lola
Lola M. Ball
netLibrary, Inc.
3085 Center Green Drive
Boulder, CO 80301
Direct 303.381.8922
Fax 303.381.8900
Email lball@netLibrary.com
Time datatypes
Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.
Return to “Archive of DataStage Users@Oliver.com”
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