DSXchange

Posted: **Mon Mar 14, 2011 1:16 pm**

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.

Posted: **Mon Mar 14, 2011 1:33 pm**

Hi kaps

you have to read the error message completly

kaps wrote:
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

Posted: **Mon Mar 14, 2011 1:45 pm**

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 ?

Posted: **Mon Mar 14, 2011 1:47 pm**

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 ?

Posted: **Mon Mar 14, 2011 5:30 pm**

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

DSXchange

Issue in loading data using DB2UDB Enterprise Stage...

Issue in loading data using DB2UDB Enterprise Stage...

Re: Issue in loading data using DB2UDB Enterprise Stage...