PH35806: AFTER PH27640, UNDUE INZU039E OR INZU090E IF UNLOAD WITH UNLOAD PLUS SYNTAX AND WHERE CLAUSE WITH SUBSELECT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After the fix PH27640 has been applied, the unload unduly fails
  after having issued one of the following error message:
  - case 1) INZU039E FATAL SYNTAX ERROR BEFORE LINE line COLUMN
  col
  - case 2) INZU090E UNRECOVERABLE SYNTAX ERROR STARTING AT
  (line,col) AND ENDING AT (line,col)
  INZU039E FATAL SYNTAX ERROR BEFORE LINE line COLUMN col
  This occurs if the following conditions are fulfilled:
  - the unload statement uses the Unload Plus syntax
  - the unload statement specifies a logical unload (SELECT
  statement) with a WHERE clause
  - the WHERE clause in the logical unload specifies
     - case 1) a predicate involving a subselect
     - case 2) a LIKE predicate involving a constant surrounded by
  parentheses
  For example, the following unload statements ares affected by
  the error:
  - case 1)
  UNLOAD
  SELECT *
  FROM SYSIBM.SYSTABLES
     WHERE NOT EXISTS
   (SELECT *
  FROM SYSIBM.SYSTABLES WHERE NAME = 'A' )
  - case 2)
  UNLOAD
  DIRECT AUTO
  SELECT *
  FROM me.mytable
  WHERE
  mycol LIKE ('XXX%')
  ;
  

Local fix

• - case 1) double the parenthesis around the subselect as in the
  above example:
  UNLOAD
  SELECT *
  FROM SYSIBM.SYSTABLES
     WHERE NOT EXISTS
   ((SELECT *
  FROM SYSIBM.SYSTABLES WHERE NAME = 'A' ) )
  ;
  - case 2) remove the parenthesis around LIKE constant
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: After the fix PH27640 has been applied, *
  *                      the unload unduly fails after having    *
  *                      issued one of the following error       *
  *                      message:                                *
  *                      - case 1) INZU039E FATAL SYNTAX ERROR   *
  *                                BEFORE LINE line COLUMN col   *
  *                      - case 2) INZU090E UNRECOVERABLE SYNTAX *
  *                                ERROR STARTING AT (line,col)  *
  *                                AND ENDING AT (line,col)      *
  *                                INZU039E FATAL SYNTAX ERROR   *
  *                                BEFORE LINE line COLUMN col   *
  *                      This occurs if the following conditions *
  *                      are fulfilled:                          *
  *                      - the unload statement uses the Unload  *
  *                        Plus syntax                           *
  *                      - the unload statement specifies a      *
  *                        logical unload (SELECT statement) with*
  *                        a WHERE clause                        *
  *                      - the WHERE clause in the logical unload*
  *                        specifies                             *
  *                         - case 1) a predicate involving a    *
  *                                   subselect                  *
  *                         - case 2) a LIKE predicate involving *
  *                                   a constant surrounded by   *
  *                                   parentheses                *
  *
  *
  *                      For example, the following unload       *
  *                      statements ares affected by the error:  *
  *                      - case 1)                               *
  *                               UNLOAD                         *
  *                               SELECT *                       *
  *                               FROM SYSIBM.SYSTABLES          *
  *                               WHERE NOT EXISTS               *
  *                               (SELECT * FROM SYSIBM.SYSTABLES*
  *                                    WHERE NAME = 'A' )        *
  *                                                              *
  *                      - case 2)                               *
  *                            UNLOAD                            *
  *                            DIRECT AUTO                       *
  *                            SELECT * FROM me.mytable          *
  *                                WHERE mycol LIKE ('XXX%')     *
  *                            ;                                 *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  After PH27640, undue INZU039E if unload with Unload Plus syntax
  and  WHERE clause with subselect
  

Problem conclusion

• Code has been changed to fix this problem
  

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:

  UI75100

Modules/Macros

• INZ$$PRM INZBIND  INZTDSC  INZTVAR  INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI75100

     UP21/05/07 P F105 {

• R510 PSY UI75101

     UP21/05/07 P F105 {

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.