Page 1 of 1

Update Error

Posted: Sun Sep 13, 2009 10:38 pm
by Narayana
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

Posted: Sun Sep 13, 2009 10:53 pm
by chulett
:?: viewtopic.php?t=96684

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

Posted: Sun Sep 13, 2009 11:17 pm
by Narayana
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

Posted: Mon Sep 14, 2009 12:05 am
by dxk9
What is the format of the values of 'RPT_D' field?

Regards,
Divya

Posted: Mon Sep 14, 2009 6:17 am
by chulett
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. :?