Query the Comparison Date
- Last UpdatedNov 14, 2025
- 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: 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-------->