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
Modify stage:decimal to integer and numeric
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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).
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
