convertion from string to decimal

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
chandra
Participant
Posts: 88
Joined: Sun Apr 02, 2006 6:50 pm
Location: India

convertion from string to decimal

Post by chandra »

can we convert string to decimal via !
chandra ,
Hyd
Top
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

What exactly do you mean. Give us examples.
Depends upon the precision. Divide by 100 for precision of 2, or 1000 for precision of 3 and so on.
Also specify the length and precision in the output sql type.
Regards,
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”