Update Error

Narayana · Post by **Narayana** » Sun Sep 13, 2009 10:38 pm

I am just updating the Date Feild with a simple job as given below

DB2------------Copy---------DB2
Select * Update Statement

I am getting the below error ""Unable to bind a pointer to a database Feild"

Please let me know your thoughts on the same.

Thanks

chulett · Post by **chulett** » Sun Sep 13, 2009 10:53 pm

viewtopic.php?t=96684

If that doesn't help, please post the complete unedited (and typo free) error message.

Narayana · Post by **Narayana** » Sun Sep 13, 2009 11:17 pm

I have gone through the link but it looks there is some problem with the DataType. but here is the Unedited error
"Unable to bind a pointer to a database field `RPT_D' to type DATE."

Thanks

dxk9 · Post by **dxk9** » Mon Sep 14, 2009 12:05 am

What is the format of the values of 'RPT_D' field?

Regards,
Divya

chulett · Post by **chulett** » Mon Sep 14, 2009 6:17 am

I'd also be curious what exactly "Select * Update Statement" means. You don't "*" anything in DataStage so wondering if what you are selecting matches up well with your metadata.