IBM Support

PH16627: FIXED PROBLEMS W/EXPORT TO UNIX FILES. ADDRESSED THE INABILITY TO UPDATE TABLE VALUES AFTER RESIZING NULL INDICATOR ('N') COL

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Changed command line parameters for the export of data to a Unix
    file. The syntax of the export command is unchanged.  Removed
    the ability to resize the NULL indicator ('N') column in order
    to retain the ability to update table values. Before this
    update, changing the size of the 'N' column made it impossible
    to update values in the table.
    This release includes the following improvement
    1. ETIMP-2648 - Error while exporting data to the Unix file
    2. ETIMP-2913
    - Update is not available with customization 'N' column
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Table Editor for z/OS.          *
    ****************************************************************
    * PROBLEM DESCRIPTION: Error while exporting data to the Unix  *
    *                      file. Update is not available with      *
    *                      customization 'N' column.               *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF.                               *
    ****************************************************************
    The value is not updated because of CSIZE customization set to
    1.  Getting error "ETI568E - An error occurred while opening
    file for export" while exporting data to the Unix file (USS).
    The problem arises due to the configuration of the command line
    input. After pressing Enter, all commands regardless of the CAPS
    mode went to processing written in capital letters.
    

Problem conclusion

  • Apply the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH16627

  • Reported component name

    DB2 TABLE EDITO

  • Reported component ID

    5697G6500

  • Reported release

    150

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-09-09

  • Closed date

    2019-09-27

  • Last modified date

    2019-10-01

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

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

    UI65562

Modules/Macros

  • ETI$BRWS ETI$EDIT ETI$HIST ETI$LOG  ETI2PEDT
    

Fix information

  • Fixed component name

    DB2 TABLE EDITO

  • Fixed component ID

    5697G6500

Applicable component levels

  • R150 PSY UI65562

       UP19/10/01 P F909

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":"BU048","label":"IBM Software"},"Product":{"code":"SSCVQU2","label":"Db2 Table Editor"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.5.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
01 October 2019