Hi All,
Can you please guide me with below issue:
Below is the job populating data from Source: Oracle(Oracle Enterprise) to Target: SQL server(ODBC)
In database the metatdata is
Col1 : NVARCHAR2 (255) - > Col1 : VARCHAR (510)
The jobs prompts with the below warning
When checking operator: When binding output interface field Col1 to field Col1 : Implicit conversion from source type "ustring[max=255]" to result type "string[max=510]": Converting ustring to string using codepage ASCL_MS1252.
Thus modified code as below
Col1 : NVARCHAR2 (510) - > Col1 : NVARCHAR2 (510)
The jobs prompted with one more warning
When checking operator: When binding output interface field Col1 to field Col1 : Implicit conversion from source type "ustring[max=255]"to result type "string".
When checking operator: When binding output interface field Col1 to field Col1 : Conversion from source type "string" to result type "ustring[max=510]": Possible truncation of variable length string.
When i made the similar modification in some other job it worked but for some job it is not i am not able to figure out the reason.
Converting ustring to string using codepage ASCL_MS1252
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
-
- Participant
- Posts: 30
- Joined: Tue Sep 08, 2009 4:24 am
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