IBM Support

PH25568: TRANS PRO AFFINITY VARCHAR column conversion error

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • TRANS PRO AFFINITY may issue the following conversion error:
    TRANS PRO AFF CONV ERROR: The source value is of zero length
    and has been copied to the destination.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Optim/z users of TRANS PRO AFFINITY          *
    ****************************************************************
    * PROBLEM DESCRIPTION: Expression between VARCHAR and CHAR     *
    *                      columns were handled incorrectly.       *
    ****************************************************************
    * RECOMMENDATION: Apply the provided fix                       *
    ****************************************************************
    When using the TRANS PRO AFFINITY column map function, if the
    source and destination columns have different types an error
    can occur.
    For example, VARCHAR column contains
    the following expression:
    TRANS PRO=AFF, MTD=REP, ALGO=DEF,FLDDEF1=(NAME=CUSTN, DT=CHAR)
    Then user will see the following error:
    The source value is of zero length and has been copied to
    the destination.
    

Problem conclusion

  • The program has been changed correctly handle VARCHAR/CHAR
    columns.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH25568

  • Reported component name

    OPTIM MOVE FOR

  • Reported component ID

    5655V0700

  • Reported release

    B70

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-05-19

  • Closed date

    2020-07-29

  • Last modified date

    2020-08-03

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

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

    PH25612

Modules/Macros

  • FOP1OSFN FOP9APIM FOPCFPMN FOPCXLIB FOPD2V85 FOPD2V91 FOPD2VA5
    FOPD2VC5 FOPD2VNN FOPHSTM  FOPI4706 FOPIBDPK FOPINS0  FOPMAIN
    FOPMAMAI FOPMCMAI FOPMCOLA FOPMCOLP FOPMDPRC FOPMECMN FOPMMCMR
    FOPMMJBS FOPMMUNU FOPMMUTL FOPMUXIM FOPOMN   FOPPEX2C FOPPEXC
    FOPTC710 FOPTC71M FOPTC71P FOPTC71R FOPTC71S FOPZFMMN FOPZMAIN
    

Fix information

  • Fixed component name

    OPTIM MOVE FOR

  • Fixed component ID

    5655V0700

Applicable component levels

  • RB70 PSY UI70815

       UP20/07/31 P F007

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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"B70","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
05 August 2020