I had set up an ODBC driver for MySQL database and it was successful. When I trying to import metadata I am getting the following error message
DSR.MetaGeta(GET.TABLES)(SQLFetch): BCI Error: SQLSTATE=01004,CODE=0,DataStageSQL ClientData has been truncated
We are using datastage 8.1 running on windows server 2003.
Could someone point me in the right direction?
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
3 replies Latest Post - 2009-07-22T19:08:36Z by SystemAdmin
Pinned topic Error with MySQL Import Meta data
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2009-07-22T19:08:36Z at 2009-07-22T19:08:36Z by SystemAdmin
SystemAdmin 110000D4XK160 Posts
DataStageETL 060001W8RR2 PostsACCEPTED ANSWER
Re: Error with MySQL Import Meta data2009-07-22T17:51:13Z in response to SystemAdminODBC Driver - MySql ODBC 3.5.1 driver
I do not know what you meant by datadirect dirver for IBM.
I am trying to import the table definitions from MySql to datastage
We have sql2005