Job design as follows:
DB2APIstage---Xfmer---Remove Duplicate----Db2UDBEnterprise
We get the following error:
No null values in the input. Partition type selected in Target stage is DB2.main_program: DB2 Get Table Partitioning Information.
main_program: SQLCODE = -303; SQLSTATE=42806
main_program: SQL0303N A value cannot be assigned to a host variable in the SELECT, VALUES, or FETCH statement because the data types are not compatible. SQLSTATE=42806
main_program: Fatal Error: DB2 Get Table Partitioning Information failed.
Please advise.