DATE
DATE defines a date field.
If you specify this option without EXTERNAL, LOADPLUS does not verify input data.
When loading CSV data (FORMAT CSV), you must use the DATE-format EXTERNAL data type, specifying one of the delimited formats listed in Supported-external-DATE-TIME-and-TIMESTAMP-formats.
DATE
DATE indicates a Db2 internal date value.
DATE EXTERNAL(length)
DATE EXTERNAL indicates a DB2 date string value.
DATE-format EXTERNAL(length)
This data type description indicates an external date value. In addition, it indicates the format of the external date value. See Supported-external-DATE-TIME-and-TIMESTAMP-formats for information about the available date formats.
When you specify DATE-format EXTERNAL, LOADPLUS loads the current date when the input data equates to spaces or zeros unless the column has a default value of null. If the column has a default value of null, LOADPLUS loads nulls instead of the current date when the input data equates to spaces or zeros.
CENTURY(ccyy,ccyy) | CENTURY specifies the 100-year range that determines the century for DATE external formats that contain two-digit year values. The first four-digit year value must be less than the second four-digit year. You must specify both values and these values must span 100 years. Any two-digit year in the input data that lies between the first yy specification and 99 is prefixed with the first cc value to create a four-digit year. Any two-digit year in the input data that lies between 00 and the second yy specification is prefixed with the second cc value to create a four-digit year. For example, if you specify CENTURY(1950,2049), LOADPLUS places 19 in front of each two-digit year with a value 50 through 99, and places 20 in front of each two-digit year with a value 00 through 49. The date 99/12/31 becomes 1999/12/31 and 00/12/31 becomes 2000/12/31. For information about specifying CENTURY globally on the LOAD command, see CENTURY. For information about the CENTURY installation option, see CENTURY=(1950,2049). |
|---|
Related topic