Query the Comparison Date
- Last UpdatedMay 25, 2022
- 1 minute read
The query will return the comparison session number or extract number for a Database (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-------->