DB2 connector stage to Netezza Enterprise stage

nansekar · Post by **nansekar** » Mon Jul 30, 2012 5:27 am

Hello Team

I had a Job with Dataset as Source as DB2 connector stage as Target

I have modified the Job by replacing the DB2 connector with Netezza enterprise stage.
Its a direct load from Dataset to Netezza Database, the job is aborting due to the error
main_program: Fatal Error: Type mismatch for field 'A'. Fatal error.

The Field A is of datatype Decimal (1) ,

Is there any conversions required.Kindly let me know how to proceed further.

chulett · Post by **chulett** » Mon Jul 30, 2012 6:26 am

Please clarify for us what the datatype of the column is in both the target table and the job.