Topic
IC4NOTICE: 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.
3 replies Latest Post - ‏2009-07-22T19:08:36Z by SystemAdmin
DataStageETL
DataStageETL
2 Posts
ACCEPTED ANSWER

Pinned topic Error with MySQL Import Meta data

‏2009-07-22T15:15:02Z |
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?
Updated on 2009-07-22T19:08:36Z at 2009-07-22T19:08:36Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    160 Posts
    ACCEPTED ANSWER

    Re: Error with MySQL Import Meta data

    ‏2009-07-22T16:25:01Z  in response to DataStageETL
    what ODBC driver you installed? version? datadirect driver for IBM?
    what are your meta data schema that you are trying to import?
    and your sql server version?
    • DataStageETL
      DataStageETL
      2 Posts
      ACCEPTED ANSWER

      Re: Error with MySQL Import Meta data

      ‏2009-07-22T17:51:13Z  in response to SystemAdmin
      ODBC 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
      • SystemAdmin
        SystemAdmin
        160 Posts
        ACCEPTED ANSWER

        Re: Error with MySQL Import Meta data

        ‏2009-07-22T19:08:36Z  in response to DataStageETL
        you need to use datadirect odbc driver. you can contact IBM support for that