SETCOMPDATE

Function:

Sets the Comparison Date for an MDB or DB.

Description:

Sets the Comparison Date for an MDB or DB. The user can set the comparison date to an actual date, to a stamp, or, for a specific DB, to an exact session number and/or extract number. The comparison date can be used in queries and, for example, in Change Highlighting, where it is necessary to specify a comparison date in order to determine which elements have been changed since the specified date.

Note: If a stamp is used to set the comparison date, this will set the comparison session for each database within the stamp. It will also reset any comparison dates set previously.

Querying a date will only return a value if the last SETCOMPDATE command used a date on its own; otherwise, it will return 'unset'. Similarly, querying a stamp is only valid if the last SETCOMPDATE command used a stamp.

Examples:

SETCOMPDATE 10 January 2002

Sets the comparison date to 10 January 2002.

SETCOMPDATE STAMP stamp 016

Sets the comparison date to stamp 016.

Related Commands:

CHANGE HIGHLIGHTING

Command Syntax:

>- SETCOMPDATE -+- <date> -------------------------------------------------------------.
                |- STAMP - name -------------------------------------------------------|
                ‘- FOR - DB - dbname - TO -+- <date> ----------------------------------|
                                           |- Session - integer - EXTRACT -+- integer -|
                                           |                               '- dbname  -|
                                           |-- Session -- integer ---------------------|
                                           ‘-- EXTRACT -+- integer --------------------|
                                                        ‘- dbname ---------------------+->

Querying:

Q COMPDATE EXTRACT FOR DB CTBATEST/DESI

Q COMPDATE COMPDATE SESSION FOR DB CTBATEST/DESI