JR60788: DB2 Connector fails while parsing 3-part table name

IBM InfoSphere Information Server, Version 11.7.1.1 (Fix Pack 1)
IBM InfoSphere Information Server, Version 11.7.1.1 for AIX
IBM InfoSphere Information Server, Version 11.7.1.1 for Windows
IBM InfoSphere Information Server, Version 11.7.1.1 for Linux

APAR status

• Closed as program error.

Error description

• DB2 Connector detected an unexpected characterwhile parsing
  table name
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users using three part table name in SQL queries set in User
  defined SQL
  ****************************************************************
  PROBLEM DESCRIPTION:
  When SQL query defined in the DB2 connector properties contains
  three part
  table name (ex. MYDATABASE.MYSCHEMA.TABNAME), the job will fail
  and report
  the following error message:
  
  While parsing table name MYDATABASE.MYSCHEMA.TABNAME, the
  connector detected
  an unexpected character at position 19.
  (CC_DB2TableNameParser::parse, file
  CC_DB2TableNameParser.cpp, line 246)
  ****************************************************************
  RECOMMENDATION:
  Install APAR JR60788
  ****************************************************************
  

Problem conclusion

• DB2 Connector code has been altered so the table name in SQL
  query containing
  database and schema is properly parsed.
  

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

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• RB70 PSY

     UP