PH32481: OBJECT PROFILE PANELS HAA$TSQL & HAA$ISQL: PROVIDE A MAX OF 32,704 BYTES FOR LARGE SQL STATEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Advanced SQL entered on panels HAA$TSQL and/or HAA$ISQL
  will now allow up to a maximum of 32,704 bytes for SQL
  statements.
  Prior to this PTF, a SQL statement (> 200 lines) can result
  in a -302 SQLCODE due to a lack of space required to process
  the large SQL statement.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Users                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Advanced SQL entered on panels HAA$TSQL *
  *                      and/or HAA$ISQL will now allow up to a  *
  *                      maximum of 32,704 bytes for SQL         *
  *                      statements.                             *
  *                      Prior to this PTF, an SQL statement     *
  *                      (>200 lines) can result in a -302       *
  *                      SQLCODE due to a lack of space          *
  *                      required to process the large SQL       *
  *                      statement.                              *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF                                *
  ****************************************************************
  .
  

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:

Modules/Macros

• HAA#BND  HAA#BPRI HAA#ESCP HAA#IX10 HAA#IX12 HAA#OBEX HAA#TS10
  HAA#TS12 HAA#UTED HAA#UTOB HAA#VMTB HAA$BMSG HAA$BUTR HAA$EXCP
  HAA$ISQL HAA$JBRK HAA$JPRU HAA$TSQL HAA$UMOD HAAHUMOD HAAHVMOD
  HAAM39   HAAM396E HAAM95   HAAM957E HAAMODFC
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R430 PSY UI74340

     UP21/03/11 P F103

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.