JR30597: Server job aborts when multiple user-defined SQL statements are used in the ODBC stage

IBM InfoSphere Information Server, Version 8.5 Fix Pack 2

APAR status

• Closed as program error.

Error description

• Trailing semi-colon problem in user defined sql in ODBC stage.
  This was not a problem previous to 7.5.1a
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Server job aborts when multiple user-defined SQL statements are
  used in the ODBC stage
  ****************************************************************
  PROBLEM DESCRIPTION:
  Server ODBC stage separates multiple user-defined SQL statements
  causing the user-defined SQL not to be handled as a single
  statement.
  ****************************************************************
  RECOMMENDATION:
  This change is included in 8.0.1 Fix Pack 2.
  ****************************************************************
  

Problem conclusion

• Added a workaround for oracle database to keep trailing
  semicolon in user-defined sql.
  To enable this, just set user defined env var
  ODBCKeepSemicolon=1.
  

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:

Modules/Macros

• SERVER
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R801 PSY

     UP