PM31895: UNLOAD RC8 SELECT DISTINCT * SYNTAX ERROR INZU016E OR INZU096E

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A logical Unload fails with completion code 8 reporting a syntax
  error when specifying a SELECT block with DISTINCT *.  The
  specific error messages issued depend on the Unload statement.
  Messages INZU016E and INZU096E are some of the possible
  messages.
  
  PB11060
  

Local fix

• Replace DISTINCT * by the explicit list of the column names to
  bypass this issue.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: An unload fails with completion code 8  *
  *                      and reporting a syntax error where a    *
  *                      logical unload involves a SELECT block  *
  *                      with DISTINCT *.                        *
  *                                                              *
  *                      The error message issue depends on the  *
  *                      unload statement. Messages INZU016E and *
  *                      INZU096E are some of the possible       *
  *                      messages.                               *
  *                                                              *
  *                      Local fix :                             *
  *                                                              *
  *                      Replace the * by the explicit list of   *
  *                      the columns solves the problem.         *
  *                      PB 11060                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  inzdyacc module was fixed to recognize the 'SELECT DISTINCT *'
  syntax.
  

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

• R310 PSY UK65290

     UP11/03/08 P F103

• R320 PSY UK65291

     UP11/03/08 P F103

• R410 PSY UK65292

     UP11/03/08 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.