Search found 7 matches

by josemathew
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

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
by josemathew
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

This is in Parallel edition and so we cant use the IConv/OConv functions here


JM
by josemathew
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

The input string is valid( string is A123-6A). From this i need to get only numeric values,like 1236. For this we gave all the characters in the list part of Convert function. There we get the complie error: "Error Compliling Transformer and Transformer name". In More details it is given: ...
by josemathew
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...
by josemathew
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...
by josemathew
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 ...
by josemathew
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