An Archive Request is run in several steps. The steps differ
slightly if you schedule the Archive Process to run later, rather
than run the Archive Process immediately.
The steps are described in the following paragraphs.
Validate the Access Definition
Archive validates the specifications in the Access Definition.
If the Access Definition is valid, processing continues. If the Access
Definition is invalid, processing proceeds as follows:
- If the Archive Process is scheduled, the Stop
on Error parameter on the Steps tab
of the Job Details dialog determines whether
processing continues.
- If the Archive Process is run immediately, Archive
displays an error message and processing stops.
Locate and Prompt for Archive Directory
Entry
Archive locates any Archive Directory
entry associated with the Archive File name you entered. If an Archive
Directory entry does not exist, Archive creates it at the successful
conclusion of the process. If the Archive Directory Entry does exist,
processing proceeds as follows:
- If the Archive Process is scheduled, processing
continues. The existing Archive Directory entry is deleted, and a
new entry is created at the successful conclusion of the process.
- If the Archive Process is run immediately, a dialog
prompts you to confirm deletion of the existing Archive Directory
entry. If you choose not to delete the existing entry, processing
stops.
Locate the Archive File
Archive locates the Archive File. If the file does not
exist, Archive creates it. If the Archive File does exist, processing
proceeds as follows:
- If the Archive Process is scheduled, processing
continues. The file is overwritten.
- If the Archive Process is run immediately, a dialog
prompts you to confirm that the data in the file is to be overwritten.
Use a Personal Option to disable this feature.
Locate the Archive Index File
Archive locates the Archive Index File. If the file
does not exist, Archive creates it if Archive Index parameters are
specified in the Access Definition. If the Archive Index File does
exist and Archive Index parameters are specified in the Access Definition,
processing proceeds as follows:
- If the Archive Process is scheduled, processing
continues. The file is overwritten.
- If the Archive Process is run immediately, a dialog
prompts you to confirm that the data in the file is to be overwritten.
Use a Personal Option to disable this feature.
Validate Variable Value
Archive checks whether variables are defined in the
Access Definition, and if so, verifies that valid values are provided
for each variable.
- If valid values are provided, processing continues.
- If invalid values are provided (for example, the
data type, size, or resulting SQL syntax is invalid), processing stops
and errors are recorded in the Archive Process Report.
- If values are missing or the check box labeled Always
Prompt for Values at Run Time is selected on the Variables tab
(see Variables Tab, Archive Request Editor),
processing proceeds as follows:
- If the Archive Process is scheduled, processing
stops and errors are recorded in the Archive Process Report.
- If the Archive Process is run immediately, the Archive
File Variable Values dialog is displayed. Enter values
for variables, as required, to continue processing.
Validate Point and Shoot
If a Point and Shoot list is specified, Archive verifies
that the rows are valid.
- If the rows in the Point and Shoot list are valid,
processing continues.
- If a Point and Shoot list file is specified and
cannot be found, processing stops.
- If the rows in a Point and Shoot list are invalid,
missing, or if primary key values in the file do not exist in the
Start Table, processing proceeds as follows:
- If the Archive Process is scheduled, the Stop
on Error parameter specified on the Steps tab
of the Job Details dialog determines whether
processing continues.
- If the Archive Process is run immediately, you are
prompted to specify how to proceed. You can continue processing the
Archive Process without using the Point and Shoot list, or cancel
the Archive Process.
Archive Data
Archive
performs the Archive Process for each table specified in the Access
Definition.
Delete Data
Archive
performs the Delete After Archive Process for each table listed in
the Access Definition, according to your specifications. If you selected
the Defer Delete after Archive option, data
is not deleted. If you selected Review Archive Delete List,
the Delete After Archive Specifications dialog
is displayed.
Delete After Archive Specifications
Dialog
Use the Delete After Archive
Specifications dialog to verify or override delete specifications
in the Access Definition. Select a check box to delete archived rows
in the corresponding table. To select or clear all check boxes at
once, you can click in the menu, or you can use the toolbar
buttons or the shortcut menu.
Cascading Delete/Update Confirmation
Dialog
Archive
performs a cascading delete/update check during processing of an Archive
Request, and displays the Cascading Delete/Update Confirmation dialog
if the following conditions are true:
- The Warn on Cascade Delete/Update option
must be set to Runtime or Always in
either Product or Personal Options. (Refer to the Installation
and Configuration Guide and the Common Elements Manual )
- At least one table must have Delete After Archive
specifications.
- The cascade delete or update must affect at least
one table that is not explicitly included in the Archive Process.
Click OK to continue
processing, or click Cancel to stop processing
and return to the Archive Request Editor.
For details on this dialog, refer to the Common
Elements Manual .
Archive Process Report
Archive generates an Archive Process Report.
- If the Archive Process is scheduled, the process
proceeds when scheduled and the report is saved to a file. Open and
print the process report from the Scheduler after the Archive Process
completes.
- If the Archive Process is run immediately, the Archive
Request Progress dialog displays a status message as rows
of data are archived from each table. The process report displays
automatically when the Archive Process completes and is retained according
to defaults set on the Actions tab for Personal
Options. Review and print the report, as required.
- Schedule an Archive Process
Use
this task to schedule an Archive Process. Use an Archive Process to
select a precisely defined set of related rows from a database and
save the rows to an external Archive File. An Archive Process can
be scheduled either to run once or to run repeatedly at intervals.
- Run an Archive Process Request
Use
this task to run an Archive Process immediately. Use an Archive Process
to select a precisely defined set of related rows from a database
and save the rows to an external Archive File.