PM78055: THE UNLOAD FAILS ISSUING SQLCODE -104

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An unload fails and issue an SQLCODE=-104 such as:
  
  SQLCODE = -104, ERROR:  ILLEGAL SYMBOL ",". SOME SYMBOLS
     THAT MIGHT BE LEGAL ARE: MICROSECONDS MICROSECOND
     SECONDS SECOND MINUTES MINUTE HOURS
  
  This can occur when:
  - the table space to unload is partitioned.
  - the partitioning key of the table space contains a
    DECIMAL(n, 0) column and the limit key for at least
    one partition was defined with an ending comma.
  - a SQLPART clause is specified and involves one of the
    partitions having a limit key defined with an ending comma.
  - the SELECT statement is not supported
    (message INZU063I UNSUPPORTED SELECT).
  
  PB11774
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: An unload fails and issue an            *
  *                      SQLCODE=-104 such as:                   *
  *                      SQLCODE = -104, ERROR:  ILLEGAL SYMBOL  *
  *                      ",". SOME SYMBOLS THAT MIGHT BE         *
  *                      LEGAL ARE: MICROSECONDS MICROSECOND     *
  *                      SECONDS SECOND MINUTES MINUTE HOURS     *
  *                                                              *
  *                      This can occur when :                   *
  *                      - the table space to unload is          *
  *                      partitioned.                            *
  *                      - the partitioning key of the table     *
  *                      space contains a DECIMAL(n, 0) column   *
  *                      and the limit key for at least one      *
  *                      partition was defined with an ending    *
  *                      comma.                                  *
  *                      - a SQLPART clause is specified and     *
  *                      involves one of the partitions having   *
  *                      a limit key defined with an ending      *
  *                      comma.                                  *
  *                      - the SELECT statement is not           *
  *                      supported (message INZU063I             *
  *                      UNSUPPORTED SELECT) or the DB2 FORCE    *
  *                      option has been specified.              *
  *                      pb 11774                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzdml moduel was fixed to always generate predicates with
  period as a decimal delimiter.
  

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

• R410 PSY UK90737

     UP13/01/10 P F301

• R420 PSY UK90738

     UP13/01/10 P F301

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.