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,
i am unable to connect Db2 thru Datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Why use ODBC? You should have the DB2 client libraries and you can connect via native DB2.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn