PI62566: NEW FUNCTION

Obtain the fix for this APAR.

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 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
  

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.