JR41476: ODBC CONNECTOR MDI FROM ORACLE DB IS RETURNING FIRST CHARACTER OF DB NAME ON UNIX.

IBM InfoSphere Information Server, Version 8.7 Fix Pack 1
IBM InfoSphere Information Server, Version 8.5 Fix Pack 3

APAR status

• Closed as program error.

Error description

• There are two different issues involved:
  .
  1. While using ODBC Common Connector and performing metadata
     import from oracle source, only the first character of the
     database name is returned instead of the complete database
     name.  This occurs only on the unix platforms, while on
     the windows platform the database name is returned correctly.
                                                                 .
  2. While getting the view expression of the table from different
     RDBMS (DB2, Oracle, MS SQL Server)  into the tools such as
     Metadata Work Bench, only the first character of the view
     expression is returned. The rest of the view expression is
     not stored.
  

Local fix

Problem summary

• There are 2 different issues fixed in this particular change.
  1. The issue with the incomplete DB name during the MDI from the
  Oracle.
  2. The issue with the incomplete view expression while
  importing the table views from different RDBMS such as DB2,
  Oracle, MS SQL Server, Teradata etc.
  

Problem conclusion

• After analyzing the source of the issue it has been observed
  that the buffer that is being passed to the SQLGetData call is
  defined as SQLWCHAR. But, the actual type that is defined for it
  is dependant on the define SQLWCHARASSHORT in the datadirect
  header files.  Since this flag is not passed during compilation,
  the SQLWCHAR is getting defined as char. So, when we
  are binding the column as SQL_C_WCHAR and sending a char buffer
  to the SQLGetData call the data is not getting copied to the
  buffer correctly.
  

Temporary fix

• Add the Database name by using Repository-> Metadata Sharing ->
  Management from the Information Server Designer.
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFO SRVR PLATF

• Fixed component ID

  5724Q3612

Applicable component levels

• R850 PSY

     UP