Search found 4 matches

by Jag
Thu Oct 18, 2012 9:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: The source decimal has even precision, but non-zero error
Replies: 5
Views: 11683

Read Chapter 2 of Parallel Job Developer's Guide to learn how Decimal (and other) data types are stored. This should answer your question. Why couldn't you just answer the question? Now I googled this same issue, and your answer doesn't help me. So thanks for nothing. You are useless and unhelpful ...
by Jag
Tue Sep 18, 2012 7:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to handle Chinese characters
Replies: 2
Views: 1877

How to handle Chinese characters

I am receiving Chinese Characters in a string and I need them to be replaced with space

Is there any way we can do it in datastage 8.1
File contains a string 延安东路555号 and i need this as output '555'

Thanks in Advance
by Jag
Wed Sep 05, 2012 9:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS Function to reformat SSN
Replies: 6
Views: 3108

nsm wrote:Use Trim function

The TRIM function does not remove the '-'.
by Jag
Thu Mar 31, 2011 1:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Simple question about copy stage
Replies: 3
Views: 3211

Simple question about copy stage

I've got a simple job i am creating and it involves conversion of a Numeric(14,0) to an Integer(10). Can i make this implicit conversion in a copy stage? I am working with whole number values with six digits. My job is running correctly but I am trying to understand if the copy stage can convert imp...