PK35191: INZU090E UNRECOVERABLE SYNTAX ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Receive INZU090E with the following SELECT
  UNLOAD  DIRECT  AUTO  ORDER  NO
  SELECT   '04'
           ,SUM(SOURI - MD - NB - CHA - FRA)
           ,SUM(SOURI - MD - NB)
     INTO  NO           CHAR    (02)
           ,BRIAN       DECIMAL (13,00)
           ,SCOTT       DECIMAL (13,00)
     FROM  DBT.ASA131
     WHERE YM       =  (SELECT SUBSTR(YMD,1,6) FROM DB2.TSA131
  AND  SYUTANID =  '1'ERE  KBN = '00'  AND  NO = '03')
  
   ADDITIONAL SYMPTOMS
  1.  HPU UNLOAD job failed with INZU016E.
      Occurs if user specified 'A.*' in SELECT statement.
      UNLOAD
     DIRECT AUTO
     ORDER  YES
     SELECT A.*
     FROM DB.TMA301 A,DB.TSA301 B
        WHERE
            A.YM = B.YMD
         AND B.KBN = '00'
         AND B.NO  = '04'          AND TKFXCD='000001'
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Receive INZU090E with the following SEL *
  *                      UNLOAD  DIRECT  AUTO  ORDER  NO         *
  *                      SELECT   '04'                           *
  *                        ,SUM(SOURI - MD - NB -  CHA - FRA)    *
  *                        ,SUM(SOURI - MD - NB)                 *
  *                         INTO  NO           CHAR    (02)      *
  *                        ,BRIAN       DECIMAL (13,00)          *
  *                        ,SCOTT       DECIMAL (13,00)          *
  *                         FROM  DBT.ASA131                     *
  *                         WHERE YM       =                     *
  *                       (SELECT SUBSTR(YMD,1,6) FROM           *
  *                       DB2.TSA131 AND  SYUTANID =  '1'ERE     *
  *                       KBN = '00'  AND  NO = '03')            *
  *                      ADDITIONAL SYMPTOMS                     *
  *                      1. HPU UNLOAD job failed with INZU016E. *
  *                       Occurs if user specified 'A.*' in      *
  *                       SELECT statement.                      *
  *                       UNLOAD DIRECT AUTO ORDER  YES          *
  *                       SELECT A.*                             *
  *                       FROM DB.TMA301 A,DB.TSA301 B           *
  *                         WHERE                                *
  *                             A.YM = B.YMD                     *
  *                          AND B.KBN = '00'                    *
  *                          AND B.NO  = '04'                    *
  *                          AND TKFXCD='000001'                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Modules inzpyacc and inz0yacc were fixed to analyse correctly
  non supported SELECT.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK20290 UK20291

Modules/Macros

•    INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R210 PSY UK20290

     UP06/12/16 P F612

• R220 PSY UK20291

     UP06/12/16 P F612

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.