Kbase 15958: Dump and load of date fields with -yy and -yr4def for year
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/02/1999 |
|
Dump and load of date fields with -yy and -yr4def for year
DUMP AND LOAD USING -yy TO CHANGE DEFAULT CENTURY
If you use the -yy startup parameter to change the default century
in PROGRESS, you must use the same -yy if you ever dump and reload
the database. This will keep the dates in synch.
An example is -yy 1950. When you dump the dates, the format in the .d
file for the date is 99-99-99. The data will appear as follows.
01-01-90 (1990)
01-01-00 (2000)
01-01-10 (2010)
Note: If you never used the -yy 1950 startup, the years 2000 and
greater would have appeared as 99-99-9999 in the .d file.
Also, beginning with Version 7.3E, 8.2A and higher, the
default setting for -yy is 1950.
If you use the startup -yy 1950 to access the Data Dictionary Dump and
Load routines, PROGRESS will properly assign 2-digit years prior to
50 as belonging in the year 20xx and not 19xx.
The problem occurs if you attempt to dump/load the data through the
Data Dictionary without using the -yy 1950 startup. The year 00 would
then be seen as 1900.
NOTE: This is also true when using bulkload to load the data.
The rule: If you ever use -yy startup, you must always use it.
NEW STARTUP PARAMETER -yr4def
Beginning in 9.0A, a new startup parameter was created: -yr4def.
The -yr4def parameter forces the Data Dictionary to dump date fields
with a year format of four digits as opposed to two. This startup
parameter also affects the 4GL functions MESSAGE, EXPORT, and
PUT UNFORMATTED.
Updated 02-09-99
Progress Software Technical Support Note # 15958