A fix is available
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
SC19298414 | SC19406706 |
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
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":"BU059","label":"IBM Software w\/o TPS"},"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