Hi ArndW,
I think the problem was with the line break in the derivation and its working fine now.
Thanks a million for the advice
Jm
Search found 7 matches
- Fri May 16, 2008 5:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Usage of Convert function
- Replies: 6
- Views: 2201
- Fri May 16, 2008 5:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Usage of Convert function
- Replies: 6
- Views: 2201
- Fri May 16, 2008 3:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Usage of Convert function
- Replies: 6
- Views: 2201
- Fri May 16, 2008 2:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Usage of Convert function
- Replies: 6
- Views: 2201
Usage of Convert function
Hi All, When we used the Convert function, the job gives complation error. Within the Convert function, we gave all the alphabets so that all the alphabets are replaced by blank space.That is : Convert("ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmno pqrstuvwxyz","", ToXfmCaseStudy.CHA...
- Thu May 15, 2008 3:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Conversion function
- Replies: 4
- Views: 1460
Thanks for the response..But here i need to remove all kind of alphabets and other symbols(like ., - , _ etc) from the string. We are not sure about the knd of characers present in the string. That is why here if we use the Convert function, the from list and replace list are not clear.. Please give...
- Thu May 15, 2008 3:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Conversion function
- Replies: 4
- Views: 1460
Conversion function
Hi All, I have a requirement in which i have to get only the numeric values from a string , which consistes of numeric as well as other characters.Eg: String is "A123-6S". From this i want only 1236. i.e, only the numeric part. In Server edition we used OConv(String,"MCN") which ...
- Thu Jan 10, 2008 5:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Creating pdf files from datastage
- Replies: 3
- Views: 3279
Creating pdf files from datastage
Hi ,
Is there any way to create a pdf file from datastage environment ?For example if i want to create a PDF file ( after taking data from SQL server) through Datastage jobs, directly or indirectly .
Thanks in advance
JM
Is there any way to create a pdf file from datastage environment ?For example if i want to create a PDF file ( after taking data from SQL server) through Datastage jobs, directly or indirectly .
Thanks in advance
JM