Database Management
Reference Manual
Comparisons Across Sessions and Stamps
:
Comparison Date
: Set the Comparison Date
Set the Comparison Date
You can enter a comparison date, either for the entire MDB or an individual DB. For individual DBs, you can also enter a specific session number and extract number.
Examples:
SETCOMPDATE 31 March 2002
SETCOMPDATE STAMP /STAMP1
SETCOMPDATE NOW (will compare against the start values)
SETCOMPDATE FOR CTBATEST/DESI to session 99
SETCOMPDATE FOR CTBATEST/DESI to EXTRACT (this will compare against the parent)
SETCOMPDATE FOR CTBATEST/DESI to CTBATEST/MASTER (CTBATEST/MASTER must be up the extract hierarchy)
Command Syntax:
-SETCOMPDATE--|---date->
| --STAMP------name->
‘-FOR--DB--dbname--TO--|--date-->
|--Session -int-|--|-EXTRACT--|—- int---->
‘---------------‘ ‘--> |-- Dbname->
‘---------->
The ‘date’ subgraph takes the keyword NOW This in effect sets the comparison date to the start of the session. This can be useful for querying the original value of an attribute.
The EXTRACT keyword sets the comparison to an extract DB. This extract DB must be one further up the extract hierarchy. If the EXTRACT keyword is used by itself, the comparison is set to the parent extract. Thus this enables you to find out what has been changed in this extract.
1974 to current year.
AVEVA Solutions Limited and its subsidiaries. All rights reserved.
