Issue in loading data using DB2UDB Enterprise Stage...

[kaps]

We are having issues while trying to load data using DB2UDB Enterprise stage.
Job design as follows:

DB2APIstage---Xfmer---Remove Duplicate----Db2UDBEnterprise

We get the following error:

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.

No null values in the input. Partition type selected in Target stage is DB2.

Please advise.

[MT]

Hi kaps

you have to read the error message completly

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

Check the data types your are going to load and their nullability.

regards
Michael

[kaps]

There are only two columns coming through...One is BigInt and the other is Varchar(1000) which is same as the Target. As I said before no null values in either column.

Only thing is key not defined in the Target table. Is that an issue ?

[kaps]

There are only two columns coming through...One is BigInt and the other is Varchar(1000) which is same as the Target. As I said before no null values in either column.

Only thing is key not defined in the Target table. Is that an issue ?

[ray.wurlod]

The table will need a key if it's a partitioned table, but does not need a key otherwise.