JR37282: READING DATA IN PARALLEL DOES NOT WORK WHEN TABLE ALIAS IS SPECIFIED IN THE SELECT STATEMENT.

APAR status

• Closed as program error.

Error description

• Oracle Connector stage configured for partitioned (parallel)
  reads does not work if the specified SELECT statement uses table
  alias for the table name.
  

Local fix

• Remove the table alias and reference only the actual table name
  in the specified SELECT statement.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  IS DataStage users who are utilizing Oracle Connector stage in
  their jobs for reading data from Oracle database.
  ****************************************************************
  PROBLEM DESCRIPTION:
  Reading data in parallel does not work when table alias is
  specified in the select statement.
  The job fails with the error message indicating that the
  connector could not find the specified table or view.
  ****************************************************************
  RECOMMENDATION:
  Install patch JR37282.
  ****************************************************************
  

Problem conclusion

• The connector code was fixed to allow for table alias to be used
  in the SELECT statement when the connector is configured to
  perform partitioned reads. The connector automatically
  determines the specified table name and alias. It then uses the
  table name to find out the necessary information about the table
  in the database, and it uses the table alias for the modified
  SQL statements that run on the processing nodes.
  
  The table name and alias can also be explicitly specified in the
  "Table name for partitioned reads" property in the following
  format:
  
  table_name table_alias
  
  Where table_name and table_alias match the table name and alias
  values specified in the SELECT statement for the stage.
  

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

• R801 PSN

     UP