IBM Support

PM78313: CKZ61325W SQL ERROR IN MODULE CKZ06100 SQLCODE104 -104 IF DSNHDECP USES COMMA (,) AND NOT POINT(.) AS DECIMAL POINT.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • CKZ61325W SQL Error in Module CKZ06100
    DSNT408I SQLCODE = -104 ...
    is received if DSNHDECP uses comma (,) and not point(.) as
    decimal point.
    .
    Generate DECIMAL(m, n) with space after separator to avoid error
    if DSNHDECP uses comma (,) and not point(.) as decimal point.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Cloning Tool.                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: CKZ61325W SQL Error in Module CKZ06100  *
    *                      DSNT408I SQLCODE = -104 ...             *
    *                      is received if DSNHDECP uses comma (,)  *
    *                      and not point(.) as decimal point.      *
    *                      Generate DECIMAL(m, n) with space       *
    *                      after separator to avoid error          *
    *                      if DSNHDECP uses comma (,) and not      *
    *                      point(.) as decimal point.              *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Code has been changed to correct this condition.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM78313

  • Reported component name

    DB2 CLONING TOO

  • Reported component ID

    5655N1000

  • Reported release

    310

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2012-12-03

  • Closed date

    2012-12-20

  • Last modified date

    2016-09-16

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  •    CKZ00633
    

Fix information

  • Fixed component name

    DB2 CLONING TOO

  • Fixed component ID

    5655N1000

Applicable component levels

  • R310 PSY UK90532

       UP13/01/03 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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAUUE","label":"IBM Db2 Cloning Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 February 2021