Search found 49 matches

by akarsh
Fri Jan 16, 2009 6:14 am
Forum: General
Topic: String Comparison
Replies: 1
Views: 895

Sainath.Srinivasan wrote:

Code: Select all

If Convert(field[1,1],'',field) = '' and len(field) = 6 
then "6 same chars" 
else "not 6 same chars"

Thanks a lot Srini.. its working.. :D
by akarsh
Mon Dec 22, 2008 11:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Difference stage working
Replies: 4
Views: 3306

Only unique column names can appear on the output. Change column names on at least one of the inputs. Also (in input link execution order) verify that Before and After are indeed the links you belie ... Thanks Ray for replying.. :) I have checked that output of difference stage is having the data f...
by akarsh
Mon Dec 22, 2008 7:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Difference stage working
Replies: 4
Views: 3306

Difference stage working

Hi, I have some doubt regarding working of difference stage in Px. In its manual it is given that the output of difference stage will have data from after dataset with the diff code. But when I am creating a sample code for this the output is having data from the before data set. :shock: both the be...
by akarsh
Mon May 19, 2008 1:29 am
Forum: General
Topic: Removal of any non-numeric character
Replies: 2
Views: 1509

Removal of any non-numeric character

Hi All,
I want to remove any non-numeric character from a string and the out put should have only numeric characters.please tell me hoe i can do this.
eg: input - AB123, o/p - 123

Thanks,
Akarsh