Fixes are available
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 number
JR41476
Reported component name
INFO SRVR PLATF
Reported component ID
5724Q3612
Reported release
850
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-12-13
Closed date
2011-12-23
Last modified date
2011-12-23
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"InfoSphere Information Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
11 October 2021