JR61765: DB2 CONNECTOR FAILS TO PARSE USER-DEFINED SQL WITH TABLE NAME IN DOUBLE QUOTES

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 fails to parse User-defined SQL with table name
  in double quotes
  

Local fix

• Workaround is to remove the double quotes
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users using DB2 connector
  ****************************************************************
  PROBLEM DESCRIPTION:
  When SQL query defined in the DB2 connector properties contains
  table name in double quotes, the connector will abort the job
  with the error:
  Unmatched double quote character found at offset 3 parsing table
  name T." (CC_DBTableNameParser::getNextToken, file
  /builds/IS_11_5_maint/Common_ConnectorsBuild_Current/CC_Common/D
  AAPI/build/include/ccl/connector/CC_DBTableNameParser.inl, line
  146)`
  ****************************************************************
  RECOMMENDATION
  Install patch JR61765
  ****************************************************************
  

Problem conclusion

• DB2 connector code has been altered so the double quoted table
  name in SQL query 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

• RB50 PSY

     UP

• RB70 PSY

     UP

• RB71 PSY

     UP