Modify stage:decimal to integer and numeric

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
vishnu
Premium Member
Premium Member
Posts: 1
Joined: Mon Apr 21, 2008 4:30 am

Modify stage:decimal to integer and numeric

Post by vishnu »

Hi I am having source and destination columns in differnt datatypes and need to map these colmns so i have used modify stage to solve this problem but it is showing error as
i need to change the data type from decimal to integer

main_program: Error parsing modify adapter: Error in binding: Could not find type: "Varchar"
Expected destination field selector, got: ")"; input:
IsAdi:Varchar=(Varchar_from_char)IN_ISIM;
;
StZaman:numeric=(numeric_fromj_decimal)IN_SZ
;
IsNO:int32= (int32_from_ decimal)IN_ISNO
;

Is the syntax right or i need to modify anything.
plz help me
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Welcome aboard.

Can you show us what specifications you actually used?

VarChar does not exist for the Modify stage. It's called "string". For example string[max=32] to specify VarChar(32).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply