Set the Comparison Date

You can enter a comparison date, either for the entire Multiple Database (MDB) or an individual Database (DB). For individual DBs, you can also enter a specific session number and extract number.

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.