Search found 36 matches
- 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.
- 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
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
- 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...
- 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')
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')
- 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.
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.
- 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.
If IsNull(Arg1) then
Ans="NA "
End Else
Ans=Arg1
End
this will work check this one.