Search found 2 matches

by simonaco
Tue May 24, 2005 7:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: PX Functions
Replies: 2
Views: 1356

blewip wrote:Well this should work

Code: Select all

StringToDecimal(DSLink2.VarCharField)/1000
I've tested the job with the function. The result is ok.

Thanks for the aid.
by simonaco
Tue May 24, 2005 2:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: PX Functions
Replies: 2
Views: 1356

PX Functions

Hi.

If I want to put a string into decimal field. Which function (parallel jobs) is corrected to use?

For example:
The string is +000000000533719920
The decimal field has formed (18,3)
The final result must be +533719,920
:?
Thanks in advance.