Conversion from Double to Integer

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
vbeeram
Participant
Posts: 63
Joined: Fri Apr 09, 2004 9:40 pm
Contact:

Conversion from Double to Integer

Post by vbeeram »

Hi All,

I have this senario where i need to convert a filed(10) of type double to filed(10) of type integer . i 'm trying to use a modify stage for it . can modify stage support this if so wht is the function to convert double to integer

Thanks
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

No special conversion is required, as far as I know. The conversion is done by default. Just specify the following in modify stage

Code: Select all

old_columnName = new_columnName
Make sure the new column data type is set to integer.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply