How to convert VARCHAR 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
venki
Participant
Posts: 35
Joined: Wed Feb 28, 2007 5:09 am
Location: mumbai,

How to convert VARCHAR to DECIMAL

Post by venki »

Hi,

In my jobs i am using two oracle stages. one is source and other one is Lookup. In source column Datatype is Decimal and lookup column datatype is varchar.
Please help me out.
venki
Top
sachin1
Participant
Posts: 325
Joined: Wed May 30, 2007 7:42 am
Location: india

Re: How to convert VARCHAT to DECIMAL

Post by sachin1 »

it works fine with decimal and varchar column lookup.
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

With Server, everything is basically a string under the covers. Simply use it as is or do math on it (+0) to do an implicit conversion to decimal.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

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