Decimal to varchar

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
Champa
Participant
Posts: 88
Joined: Wed Dec 14, 2005 1:44 pm

Decimal to varchar

Post by Champa »

Hi,

How do I convert a decimal data type to varchar datatype?

Thanks.
Champa
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

There is no conversion, DS Server doesn't care. Just map it to the target column. Now, in the reverse direction, you need to make sure if the ultimate target is a database that you conform the data to the type, length, and scale.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

This a reverse scenario to what you want. Did a search on the forum.
Here is the LINK.
Kenniths saying is similar to the link.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply