DB2 Web Query system variables
System variables are predefined and automatically supplied by the system when a procedure references them. System variables have names that begin with a single ampersand (&). Examples of these variables are &FOCFEXNAME, which indicates the name of the report that is running, and &DATE, which indicates the current date.
Table B-1 lists the system variables available in DB2 Web Query.
Table B-1 System variables
|
Variable
|
Format or value
|
Description
|
|
&DATE
|
MM/DD/YY
|
Returns the current date.
|
|
&DATE |
Get IBM DB2 Web Query for i Version 2.1 Implementation Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
