IBM Support

PI44415: LOAD UTILITY IGNORE OPTION.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • LOAD utility IGNORE option to skip discard processing for
    records discarded as a result of WHEN clause specification.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 10 for z/OS and DB2 11 for z/OS      *
    *                 users of the LOAD utility                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: New function to enable LOAD             *
    *                      IGNORE(WHEN) to ignore records which    *
    *                      do not satisfy the WHEN clause.         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The new LOAD option, IGNORE(WHEN), indicates to LOAD that all
    records which do not satisfy a WHEN clause will be ignored.
    

Problem conclusion

Temporary fix

Comments

  • IGNORE(WHEN) will cause LOAD to ignore records which do not
    satisfy the WHEN clause.
    
    ----+------------------+-->
        |                  |
        '---IGNORE(WHEN)---'
    
    
    IGNORE(WHEN)
    
    Specifies that records that do not satisfy the WHEN clause
    will be ignored. If discarding is specified, records that do
    not satisfy the when clause will not be loaded, and will not
    be written to the DISCARD data set.  If discarding is not
    specified, records that do not satisfy the WHEN clause do not
    cause LOAD to terminate.
    
    Use the record count messages in the Utility output to
    determine the number of records ignored.
    
    Under the WHEN clause description:
    The option following WHEN describes a condition; input records
    that satisfy the condition are loaded. Input records that do
    not satisfy any WHEN clause INTO TABLE statement are written
    to the discard data set, if one is being used and the
    IGNORE(WHEN) option is not specified.
    

APAR Information

  • APAR number

    PI44415

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-07-06

  • Closed date

    2015-08-28

  • Last modified date

    2015-10-02

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

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

    UI30668 UI30670

Modules/Macros

  • DSNUGPRT DSNURCRF DSNURWBF
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI30668

       UP15/09/16 P F509

  • RB10 PSY UI30670

       UP15/09/16 P F509

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.



Document information

More support for: DB2 for z/OS

Software version: 10.1

Reference #: PI44415

Modified date: 02 October 2015