JR33236: BUFFER LIMIT ADDING LARGE USER DEFINED SQL STATEMENT TO ORACLE EE STAGE MULTILINE EDITOR

APAR status

• Closed as program error.

Error description

• IS 8.1, Redhat Linux 5 & Oracle 10g.
  
  Customer reported that they cannot apply large User-Defined SQL
  statement in a PX job Oracle EE stage multi-line editor because
  of a buffer restriction in the Designer client.
  
  This is possible on a DS751a server job using Oracle OCI stage,
  but not on a PX job of the same DS version.
  Patch for ecase 129633, resolved the customer's problem with
  buffer restriction of Multiline editor in the Oracle OCI stage
  server job for DS751A. Have confirmed that this is proporgated
  to IS8.1 server jobs. (works with Oracle OCI stage)
  
  Need similar patch like ecase 129633 done for IS8.1 PX Oracle EE
  stage.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users of the Oracle EE stage multiline editor that attempt to
  add over 65,000 characters.
  ****************************************************************
  PROBLEM DESCRIPTION:
  The Oracle EE stage multiline editor restricts large SQL
  statements due to a buffer limitation.
  ****************************************************************
  RECOMMENDATION:
  Apply patch JR33236
  This change is included in 8.1 FP1
  ****************************************************************
  

Problem conclusion

• Modified the multiline editor to remove the character
  restriction.
  

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:

Modules/Macros

• CLIENT
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R810 PSN

     UP