Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see LOADPLUS for DB2 13.1.

CENTURY


The CENTURY option specifies the 100-year range that determines the century for DATE and TIMESTAMP external formats that contain two-digit year values.

CENTURY.png

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.

You can also specify CENTURY with the field specification option to apply it to a particular DATE or TIMESTAMP column. For more information, see DATE.

Restriction

When invoking DSNUTILB, LOADPLUS ignores this option.

Specifying the default

You specify the default for the CENTURY command option in your installation options module by using the CENTURY installation option. LOADPLUS was shipped with a default value of (1950,2049) for this option. The command option overrides the default that is in the installation options module.

(ccyy,ccyy)

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.

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*