A fix is available
APAR status
Closed as new function.
Error description
LOAD utility support for additional date and time formats
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 11 for z/OS users of LOAD utility * **************************************************************** * PROBLEM DESCRIPTION: New LOAD feature for DATE, TIME, * * or TIMESTAMP EXTERNAL using predefined * * DATE, TIME, or TIMESTAMP formats. * **************************************************************** * RECOMMENDATION: Apply PTF when available * **************************************************************** New LOAD feature for LOAD DATE, TIME, and TIMESTAMP using predefined formats. Utility Guide and Reference, LOAD utility syntax is changed, to add new date, time, and timestamp format options to DATE, TIME, and TIMESTAMP EXTERNAL: +-DATE--EXTERNAL--+---------------------+-------------------+ | '-(-+-length------+-)-' | | '-date-format-' | +-TIME--EXTERNAL--+---------------------+-------------------+ | '-(-+-length------+-)-' | | '-time-format-' | +-TIMESTAMP--EXTERNAL--+--------------------------+---------+ | '-(-+-length-----------+-)-' | | '-timestamp-format-' | DATE EXTERNAL Specifies a character string representation of a date. You can specify a length or a specific date format. (length) The length, if unspecified, is the specified length on the LOCAL DATA LENGTH installation option, or, if none was provided, the default is 10 bytes. If you specify a length, it must be within the range of 8 - 254 bytes. If a date format is not specified, dates can be in any of the following formats. You can omit leading zeros for month and day. You can include trailing blanks, but no leading blanks are allowed. o dd.mm.yyyy o mm/dd/yyyy o yyyy-mm-dd o Any local format that was defined when DB2 was installed date-format The format of the date representation, as shown in the following table. Values for date-format table date-format value Format Length ------------------------------------------------------- DATE_A mm-dd-yyyy (1) 10 bytes DATE_B mm-dd-yy (1,2) 8 bytes DATE_C yyyy-mm-dd (1) 10 bytes DATE_D yy-mm-dd (1,2) 8 bytes DATE_E dd-mm-yyyy (1) 10 bytes DATE_F dd-mm-yy (1,2) 8 bytes DATE_G yyyy-ddd (1) 8 bytes DATE_H yy-ddd (1,2) 6 bytes DATE_I mmddyyyy 8 bytes DATE_J mmddyy (2) 6 bytes DATE_K yyyymmdd 8 bytes DATE_L yymmdd (2) 6 bytes DATE_M ddmmyyyy 8 bytes DATE_N ddmmyy (2) 6 bytes DATE_O yyyyddd 7 bytes DATE_P yyddd (2) 5 bytes If a date format is specified for a field that is used in a field specification, the field specification must also use the specified date format. Notes: 1.If the format includes separators, the separator can be any single-byte character that can be converted to a single-byte EBCDIC character. 2.If a two-digit year is specified, it is expanded to a four-digit year. If the two-digit year is less than the sum of the two-digit current year plus 50, then the current century is used in the four-digit year. For example, assume that the current year is 2017. If the two-digit year is 67, 1967 is used. However, if the two-digit year is 66, 2066 is used. TIME EXTERNAL Specifies a character string representation of a time. You can specify a length or a specific time format. (length) The length, if unspecified, is the specified length on the LOCAL TIME LENGTH installation option, or, if none was provided, the default is 8 bytes. If you specify a length, it must be within the range of 4 - 254 bytes. If a format is not specified, times can be in any of the following formats o hh.mm.ss o hh:mm AM o hh:mm PM o hh:mm:ss o Any local format that was defined when DB2 was installed You can omit the mm portion of the hh:mm AM and hh:mm PM formats if mm is equal to 00. For example, 5 PM is a valid time, and can be used instead of 5:00 PM. (time-format) The specific format of the time representation, as shown in the following table. Values for time-format table time-format value Format Length ------------------------------------------------------- TIME_A hh.mm.ss (1) 8 bytes TIME_B hh.mm (1) 5 bytes TIME_C hh.mm AM or hh.mm PM (1) 8 bytes TIME_D hhmmss 6 bytes TIME_E hhmm 4 bytes If a time format is specified for a field that is used in a field specification, the field specification must also use the specified time format. Notes: 1.If the format includes separators, the separator can be any single-byte character that can be converted to a single-byte EBCDIC character. TIMESTAMP EXTERNAL Specifies a character string representation of a time. You can specify a length or a specific timestamp format. (length) The default for length is 26 bytes. If you specify a length, it must be within the range of 19 - 32 bytes. If a timestamp format is not specified, timestamps can be in any of the following formats. nnnnnn represents the number of microseconds, and can be 0 - 12 digits. You can omit leading zeros from the month, day, or hour parts of the timestamp; you can omit trailing zeros from the microseconds part of the timestamp. o yyyy-mm-dd-hh.mm.ss o yyyy-mm-dd-hh.mm.ss.nnnnnn o yyyy-mm-dd hh:mm:ss.nnnnnn (timestamp-format) The format of the timestamp representation, as shown in the following table. Values for timestamp-format table timestamp-format val Format Length ------------------------------------------------------- TIMESTAMP_A yyyy-mm-dd-hh.mm.ss (1) 19 bytes TIMESTAMP_B yyyy-mm-dd-hh.mm.ss.nnnnnn(1)26 bytes TIMESTAMP_C yyyymmddhhmmss 14 bytes TIMESTAMP_D yymmddhhmmss (2) 12 bytes TIMESTAMP_E yyyymmddhhmmssnnnnnn 20 bytes TIMESTAMP_F yymmddhhmmssnnnnnn (2) 18 bytes If a timestamp format is specified for a field that is used in a field specification, the field specification must also use the specified timestamp format. Notes: 1.If the format includes separators, the separator can be any single-byte character that can be converted to a single-byte EBCDIC character. 2.If a two-digit year is specified, it is expanded to a four-digit year. If the two-digit year is less than the sum of the two-digit current year plus 50, then the current century is used in the four-digit year. For example, assume that the current year is 2017. If the two-digit year is 67, 1967 is used. However, if the two-digit year is 66, 2066 is used.
Problem conclusion
Temporary fix
Comments
LOAD utility code is changed to support this new feature
APAR Information
APAR number
PI68139
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function / Xsystem
Submitted date
2016-08-25
Closed date
2016-10-19
Last modified date
2016-12-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
PI69064 UI41821
Modules/Macros
DSNUGPRS DSNUGUCA DSNURUFL DSNURWBG
SC19406702 |
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RB10 PSY UI41821
UP16/11/15 P F611
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":"11.0","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":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
01 December 2016