import metadata from db2 to tabledefinitions

phanipriya · Post by **phanipriya** » Fri Sep 26, 2008 7:41 am

While importing the data from table to table definitions using odbc from import metadata .

I have been facing the following error

DSR.MetaGeta(GET.COLUMNS)(SQLCOLUMNS(",'USER1','EMPLOYEE',")
BCI Error:
SQLSTATE=38553,CODE=-443,[DataStage][Sql Client ][ODBC][IBM][CLIDriver][DB2/NT]SQL0443N Routine "SYSIBM.SQLCOLUMNS" (Specific name "COLUMNS") has returened an error SQLSTATE with diagnostics text "SYSIBM:CLI:-727". SQLSTATE=38553

what does that mean .and how do i rectify this.

ray.wurlod · Post by **ray.wurlod** » Fri Sep 26, 2008 3:46 pm

Look in your DB2 error documentation for error code -443 and -727. This will probably also offer suggestions for rectifying the situation.

chulett · Post by **chulett** » Fri Sep 26, 2008 4:45 pm

Assuming you can trust what was posted, which seems to be hand-typed based on the misspelling of "returened".

ray.wurlod · Post by **ray.wurlod** » Fri Sep 26, 2008 4:53 pm

Caveat poster

ray.wurlod · Post by **ray.wurlod** » Fri Sep 26, 2008 4:55 pm

Caveat poster

* I don't believe there's a Latin word to cover "one who posts on a web site", though scriptor (writer) may come close.