keyChange Column type conversion

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
ds_is_fun
Premium Member
Premium Member
Posts: 194
Joined: Fri Jan 07, 2005 12:00 pm

keyChange Column type conversion

Post by ds_is_fun »

Im sorting data using Sort Stage. In the Sort stage Im using Create Key Change Column option. The keyChange datatype by default is TinyInt.
I need to use it as a calculation for a Integer and Decimal(9,2) type datatype target columns.
How do I go about the type conversion?
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

I would expect the tinyInt to be useable in a transform computation - but if not then you would have to do a cast either in the transform itself or resort to the use of a MODIFY stage to change the datatype explicitly.
Post Reply