JR42515: ODBC CONNECTOR IS NOT GETTING THE VIEW EXPRESSION FROM THE SYBASE SERVER

IBM InfoSphere Information Server, Version 8.5 Fix Pack 3

APAR status

• Closed as program error.

Error description

• While using IMAM to get the view expression from the Sybase
  server using the ODBC Connector, the view expression is not
  imported
  

Local fix

Problem summary

• While trying to import the views from the Sybase database, the
  view expression is not retrieved. This is because, in the query
  in which we are trying to retrieve the view expression, we were
  using the CAPITALIZED names for the column names of some of the
  system tables. Since, sybase is case sensitive by default, the
  query was failing and the error was silently ignored and hence
  the view expression was not retrieved. Once this was corrected,
  we have noticed that the full expression was not retrieved in a
  single SQLFetch. Hence, we have to loop through all the result
  sets to get the complete view expression, when the query
  returned multiple result sets.
  

Problem conclusion

• Altered the query to correctly retrieve the view expression for
  the view.
  

Temporary fix

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

• R870 PSY

     UP