Page 1 of 1

Unable to load the table definition through ODBC dirver

Posted: Tue Jun 26, 2012 10:39 pm
by atul9806
Hi there
I am unable to load the table def through ODBC.
it throws a error :
DSR.MetaGeta(GET.TABLES)(SQLConnect('DB2','administrator')): BCI Error:
SQLSTATE=S1000,CODE=7684,[DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Protocol driver]Command cannot be completed. Bind process is active.
please help

Posted: Wed Jun 27, 2012 12:00 am
by ray.wurlod
You (or a DBA) must run the appropriate bind19 or bind20 command.

Posted: Wed Jun 27, 2012 1:23 am
by atul9806
Thanks Ray
I owned the DB on my local system. Please let me know what is the command to execute ?

Posted: Wed Jun 27, 2012 5:55 pm
by ray.wurlod
bind19 or bind20, depending on your version of DB2. This is a DB2 command, not a DataStage command.