JR46051: ORACLE CONNECTOR FAILING WHEN ROWID OR ROWNUM ARE IN THE WHERE CLAUSE

IBM InfoSphere Information Server, Version 9.1.2

APAR status

• Closed as program error.

Error description

• Oracle Connector failing when ROWID or ROWNUM are in the WHERE
  clause
  

Local fix

• N/A
  

Problem summary

• The following error message is produced when the problem
  is encountered:
  
  "The input schema column rowid is not used and the
  connector is configured to stop when unused columns are
  detected in the input schema."
  
  Where 'rowid' above is the pseudo-column in the table.
  The Oracle Connector Describes the table and uses the
  description returned from Oracle to generate the SQL
  statement. Since Oracle does not report pseudo-columns
  when describing statements, the Oracle Connector did
  not use it when generating the statement.
  
  Also, when binding by name, 'rowid' and 'rownum' are
  reserved Oracle words so we cannot use these names when
  generating bind parameters in the SQL statements.
  

Problem conclusion

• The resolution is to check if we are using an Oracle
  pseudocolumn 'rowid' or 'rownum' before preparing and
  binding the statement parameters. If we are using one
  of these columns, assume that it is in the table.
  The resolution is to check if we are using an Oracle
  pseudocolumn 'rowid' or 'rownum' before preparing and
  binding the statement parameters. If we are using one
  of these columns, assume that it is in the table.
  Also, change its bind parameter name to something that
  is allowed by Oracle.
  

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

• R870 PSY

     UP