DSXchange

Hi,

I installed Datastge and db2 in one server, i am unable to import the metadata, while importing meta data by using ODBC table definition i am getting the below error,

DSR.MetaGeta(GET.TABLES)(SQLConnect('gifdb2db','root')): BCI Error:
SQLSTATE=HY000,CODE=1222,[DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Protocol driver]Incorrect object length.

Can you please advise how to connect DB2 server,

Find out from your DB2 documentation what code 1222 means. Then fix that.

Why use ODBC? You should have the DB2 client libraries and you can connect via native DB2.