PI43497: INZU039E FATAL SYNTAX ERROR BEFORE LINE LLL COLUMN CC INZU366I UTILITY RETURN CODE 8 (REASON CODE 0X107A002)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A logical unload which SELECT statement involves an expression
  with an empty arguments list  such as ROW_NUMBER(), EXP() etc.
  issues the following messages:
  
  INZU039E FATAL SYNTAX ERROR BEFORE LINE lll COLUMN cc
  INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x107a002)
  
  and ends with completion code 8.
  
  PB12815 MSGINZU039E MSGINZU039 INZU039E INZU039
  MSGINZU366I MSGINZU366 INZU366I INZU366
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: In UNLOAD PLUS syntax, a logical        *
  *                      unload which SELECT statement that      *
  *                      involves an expression with an empty    *
  *                      arguments list  such as ROW_NUMBER()    *
  *                      issues the following messages:          *
  *                      INZU039E FATAL SYNTAX ERROR BEFORE      *
  *                       LINE lll COLUMN cc                     *
  *                      INZU366I UTILITY RETURN CODE 8          *
  *                       (REASON CODE 0x107a002)                *
  *                      and ends with completion code 8.        *
  *                      pb 12815                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzpyacc module was changed.
  

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:

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI29640

     UP15/07/25 P F507

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.