JR37892: VIEW DATA FAILS IN ORACLE OCI9 STAGE WHEN CUSTOM SQL CONTAINING COLUMN ALIAS IS USED FOR LOOKUP.

IBM InfoSphere Information Server, Version 8.5 Fix Pack 2

APAR status

• Closed as program error.

Error description

• View Data for OCI9 stage fails with next error message when
  custom SQL statement with column alias used.
  
  OCI_Job1..Oracle_OCI_1: ORA-00904: "ColumnX": invalid identifier
  OCI_Job1..Oracle_OCI_1.DSLink1: DSP.Open GCI $DSP.Open error
  -100.
  

Local fix

• This does not happen if the actual column name or SQL
  expression corresponding the column alias is given as Derivation
  in Columns tab.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  OCI stage
  ****************************************************************
  PROBLEM DESCRIPTION:
  VIEW DATA FAILS IN ORACLE OCI9 STAGE WHEN CUSTOM SQL CONTAINING
  COLUMN ALIAS IS USED FOR LOOKUP.
  ****************************************************************
  RECOMMENDATION:
  Apply JR37892
  ****************************************************************
  

Problem conclusion

• Fixed in APAR JR37892
  

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

• R752 PSN

     UP