JR31982: When user-defining very long SQL statements (about 40 rows long and up) in OCI stages, the job terminates abnormally.

Download Fix Pack 2 for InfoSphere Information Server Version 8.1

APAR status

• Closed as fixed if next.

Error description

• DataStage 8.1 on Unix AIX
  SQL statements in DB stages: When user-defining very long SQL
  statements (about 40 rows long and up) in OCI stages, the job
  
  will terminate abnormally. However, pressing "View Data"
  within
  the Designer environment will display the results correctly.
  
  A workaround we found is to reduce the number of spaces, tabs
  
  and CRs dramatically, but we cannot except this solution since
  
  it involves modifying the code.
  
  We tried to replace the OCI stage with ODBC and the job run was
  successful!
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users of the Oracle OCI plugin in Designer where customer SQL is
  used.
  ****************************************************************
  PROBLEM DESCRIPTION:
  This problem appears when using the Oracle OCI plugin with
  custom SQL in Designer. If the SQL provided uses more than 16
  new lines then the Job containing the OCI stage will fail at
  runtime.
  ****************************************************************
  RECOMMENDATION:
  Remove newlines from the custom SQL within the OCI plugin stage.
  ****************************************************************
  

Problem conclusion

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

Applicable component levels

• R810 PSN

     UP