Search found 36 matches

by chalasaniamith
Mon Feb 21, 2005 10:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reject rows
Replies: 11
Views: 4851

Re: Reject rows

use peek stage and find out where the row is getting rejected check with the variables,schema u can figure it out from there.
by chalasaniamith
Thu Feb 17, 2005 10:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: any function to right justify the values in a column
Replies: 8
Views: 6136

Hi NewPXUser

Hi

I am very new so dont think wrong is this available function TrimStr i think its just
Trim(String) not TrimStr.
Please let me know if i am wrong.
I will correct for myself
by chalasaniamith
Wed Feb 16, 2005 9:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: datastage job calling a web services
Replies: 4
Views: 4247

Re: datastage job calling a web services

What is a Service-Oriented Architecture? A platform for hosting & publishing shared services Provides foundation infrastructure services Session management Security management Load Balancing Logging & Monitoring Provides the required scalability, performance, reliability, and high availabili...
by chalasaniamith
Wed Feb 16, 2005 5:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Hex to integer in transfrmer stage
Replies: 10
Views: 5319

Re: Hex to integer in transfrmer stage

this is Radix conversion
MX - converting hexadecimal to decimal

First # : ICONV(input[1,6],'MX')
Second #: ICONV(input[7,4],'MX')
Third #: ICONV(input[11,4],'MX')

use concatenation for all these
ICONV(input[1,6],'MX'):' ':ICONV(input[7,4],'MX'):' ':ICONV(input[11,4],'MX')
by chalasaniamith
Wed Feb 16, 2005 5:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to delete a job when I get the error...
Replies: 3
Views: 1881

Re: How to delete a job when I get the error...

Hi
Just close all the windows ie designer and restart the designer agian.
I faced this problem it works for me.If u got the problem again restart the system again.
by chalasaniamith
Wed Feb 16, 2005 5:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Empty String rejection in Oracle
Replies: 4
Views: 1635

Re: Empty String rejection in Oracle

Hi Anand
If IsNull(Arg1) then
Ans="NA "
End Else
Ans=Arg1
End

this will work check this one.