Predefined variables
CDATE (Day Date Month, Year)
This variable passes the current date in the form:
Thursday 12th September, 2006
It can be used to look for certain conditions on a specific day of the week or month, or to print a more descriptive title. An example follows:
SET TITLE = 'TRANSACTION DAILY REPORT'
SET TITLE1 = &CDATE
SET TITLE1 = &CDATE
ZDATE (mm/dd/yyyy)
The ZDATE variable passes the current date, expressed as mm/dd/yyyy. An example follows:
SELECT TYPE 6E RECORDS FROM CMRDETL
WHERE CMRDATE = &ZDATE
WHERE CMRDATE = &ZDATE
ZTIME (hh:mm:ss)
The ZTIME variable passes the current time, expressed as hh:mm:ss. An example follows:
PRINT 'REPORT GENERATED AT' &ZTIME
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*