Unable to load the table definition through ODBC dirver

atul9806 · Post by **atul9806** » Tue Jun 26, 2012 10:39 pm

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

ray.wurlod · Post by **ray.wurlod** » Wed Jun 27, 2012 12:00 am

You (or a DBA) must run the appropriate bind19 or bind20 command.

atul9806 · Post by **atul9806** » Wed Jun 27, 2012 1:23 am

Thanks Ray
I owned the DB on my local system. Please let me know what is the command to execute ?

ray.wurlod · Post by **ray.wurlod** » Wed Jun 27, 2012 5:55 pm

bind19 or bind20, depending on your version of DB2. This is a DB2 command, not a DataStage command.