PH11448: SQL ERROR WHEN SQLPART ON DB2 WITH DECIMAL POINT COMMA

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An unload statement processed in SQL mode against a partitioned
  table space that specifies the SQLPART option terminates in
  error with completion code of 8 after having reported an SQL
  error (negative SQLCODE) such as:
    DNSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "")"".
  This occurs if :
  - the Db2 settings specify the comma as decimal point
  - the SQLPART is actually put into action (i.e. one output
    dataset per partition is provided)
  - one of the partitions of the table space has a LIMITKEY that
    terminates with a decimal value without any decimal digit
    after the decimal point. e.g. 99,
  - the above mentioned partition is either in the list of the
    partitions selected through the SQLPART option or is
    contiguous to a select partition.
  - APAR PM38944 is applicable
  
  PB56771
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: An unload statement processed in SQL    *
  *                      mode against a partitioned table space  *
  *                      that specifies the SQLPART option       *
  *                      terminates in error with completion     *
  *                      code of 8 after having reported an SQL  *
  *                      error (negative SQLCODE) such as:       *
  *                        DNSNT408I SQLCODE = -104,             *
  *                                ERROR: ILLEGAL SYMBOL "")"".  *
  *                      This occurs if :                        *
  *                      - the Db2 settings specify the comma as *
  *                        decimal point                         *
  *                      - the SQLPART is actually put into      *
  *                        action (i.e. one output dataset per   *
  *                        partition is provided)                *
  *                      - one of the partitions of the table    *
  *                        space has a LIMITKEY that terminates  *
  *                        with a decimal value without any      *
  *                        decimal digit after the decimal       *
  *                        point. e.g. 99                        *
  *                      - the above mentioned partition is      *
  *                        either in the list of the             *
  *                        partitions selected through the       *
  *                        SQLPART option or is contiguous to    *
  *                        one of the selected partitions.       *
  *                      - APAR PM38944 is applicable            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code has been changed to fix this problem
  

Problem conclusion

• Apply the PTF for problem resolution
  

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:

  UI62866

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI62866

     UP19/05/14 P F905

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.