Page 1 of 1

DB2 connector stage to Netezza Enterprise stage

Posted: Mon Jul 30, 2012 5:27 am
by nansekar
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.

Posted: Mon Jul 30, 2012 6:26 am
by chulett
Please clarify for us what the datatype of the column is in both the target table and the job.