IBM Support

PI62566: NEW FUNCTION

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • New Function for Utility
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 10 for z/OS and DB2 11 for z/OS      *
    *                 users of LOAD.                               *
    ****************************************************************
    * PROBLEM DESCRIPTION: Users require the ability to specify a  *
    *                      constant value for a field on LOAD.     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Users require the ability to specify a constant value for a
    field on LOAD.  In some cases a value is not included for a
    field in the record and the column was not created with a
    default.  Also, the default for a column might not be the
    desired value for this LOAD.  The ability to specify a
    constant value for an input field gives flexibility to
    replace a value from the record or specify a value when one
    is not included in the record.
    

Problem conclusion

Temporary fix

Comments

  • The following change will be made to the DB2 Utility Guide and
    Reference in the LOAD syntax section.  These syntax changes and
    description should fully explain the intended function.
    
    field specification:
    >>-field-name--+----------------------------+------------------>
                    '-POSITION(start-+------+-)-'
                    '                 '-:end-'  '
                    '-constant-specification----'
    constant-specification:
    +-CONSTANT(-+--'string'----------+-)--------------------------->
                +--X'hex-string'-----+
                +--integer------------+
                +--CURRENT DATE-------+
                +--CURRENT TIME-------+
                +--CURRENT TIMESTAMP--+
                '--NULL---------------+
    
    CONSTANT
    Specifies that the column matching the field name should be
    loaded with a constant value. The field name that is associated
    with the CONSTANT keyword must coincide with a table column
    name. The length and type of the CONSTANT field is derived from
    the specified value and must be valid for the target column.
    
    'string'
    Specifies the character string that is to be inserted in the
    target column. If the given string is in the form 'string', it
    is assumed to be in the encoding scheme of SYSIN even if the
    encoding scheme of SYSREC is not the same. Conversion may be
    applied before inserting the string into the target column.
    
    X'hex-string'
    Specifies the character string in hexadecimal form,
    X'hex-string', that is to be inserted in the target column.
    
    integer
    Specifies the integer that is to be inserted into the target
    column.  Valid values are between  -2147483648 and
    2147483647.
    
    CURRENT DATE
    Specifies that the current date is to be inserted into the
    target column.
    
    CURRENT TIME
    Specifies that the current time is to be inserted into the
    target column.
    
    CURRENT TIMESTAMP
    Specifies that the current timestamp is to be inserted into the
    target column.
    
    NULL
    Specifies that the target column should be set to NULL.  The
    target column must be nullable.
    
    For a CONSTANT field, no other field specification options are
    permitted.  A CONSTANT field is not permitted for LOB or XML
    columns.
    

APAR Information

  • APAR number

    PI62566

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-05-16

  • Closed date

    2016-07-05

  • Last modified date

    2017-02-20

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

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

    UI39180 UI39181

Modules/Macros

  • DSNUGPRS DSNUGUCA DSNURUFL DSNURWBG DSNURWUF
    

Publications Referenced
SC19298414SC19406706   

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI39180

       UP16/07/20 P F607

  • RB10 PSY UI39181

       UP16/07/20 P F607

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":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
20 February 2017