Database Management
Reference Manual
Comparisons Across Sessions and Stamps
:
Comparison Date
: Query the Comparison Date
Query the Comparison Date
The query will return the comparison session number or extract number for a DB.
Examples:
Q COMPDATE EXTRACT FOR DB CTBATEST/DESI
to get extract
Q COMPDATE COMPDATE SESSION FOR DB CTBATEST/DESI
to get session
Q COMPDATE DATE
to get date
Q COMPDATE STAMP
to get stamp
Note:
Note that 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.
The query for the comparison date will only return a value if the COMPDATE was set using a single date. Otherwise it will return ‘unset’. Similarly querying a stamp is only valid if the COMPDATE was set using a stamp.
Command Syntax:
Q ----------|-COMPDATE-|--SESSION--|--FOR---dbname--->
VAR ‑vname--‘ |—EXTRACT---´
|----DATE--------->
‘----STAMP-------->
1974 to current year.
AVEVA Solutions Limited and its subsidiaries. All rights reserved.
