IBM Support

PI68139: LOAD UTILITY SUPPORT FOR ADDITIONAL DATE AND TIME FORMATS

A fix is available

Subscribe

You can track all active APARs for this component.

 

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
    

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