Modify stage:decimal to integer and numeric
Posted: Wed Jul 16, 2008 7:03 am
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
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