How to: |
A FOCUS data source date and time stamp are updated each time the data source is changed by SCAN, FSCAN, CREATE, REBUILD, HLI, Maintain, or MODIFY. You can update a data source date and time stamp without making changes to the data source by using REBUILD TIMESTAMP subcommand.
The following steps describe how to use the TIMESTAMP subcommand:
REBUILD
The following options are available:
1. REBUILD (Optimize the database structure) 2. REORG (Alter the database structure) 3. INDEX (Build/modify the database index) 4. EXTERNAL INDEX (Build/modify an external index database) 5. CHECK (Check the database structure) 6. TIMESTAMP (Change the database timestamp) 7. DATE NEW (Convert old date formats to smartdate formats) 8. MDINDEX (Build/modify a multidimensional index)
TIMESTAMP or 6
Enter the ddname.
T (today's date). Updates the data source date and time stamp with the current date and time.
D (search file for date). Updates the data source date and time stamp with the last date and time at which the data source was actually changed. Each page of the data source is scanned and the most recent date and time recorded for a page is applied to the data source. This is the same as issuing the ? FILE query, and can be time consuming when the data source is very large. This option is used to keep an external index database synchronized with its component data source.
MMDDYY HHMMSS. Is a date and time that you specify, which REBUILD will use to update the data source date and time stamp. The date and time that you enter must have the format mmddyy hhmmss or mmddyyyy hhmmss. There must be a space between the date and the time. If you use two digits for the year, REBUILD uses the values for DEFCENT and YRTHRESH to determine the century.
If you supply an invalid date or time, the following message appears:
(FOC961) INVALID DATE INPUT IN REBUILD TIME:
Information Builders |