Macro is a special string that will be converted to exact value at the execution time. There is detailed information about available macros:
| Macro | Definition | Available at |
|---|---|---|
| $DATE$ | Current date. The presentation format can be changed via settings. | SQL script, title, header, footer and report file name. |
| $DATE.YYYY$ | Current year, 4 digits format. | SQL script, title, header, footer and report file name. |
| $DATE.YY$ | Current year, 2 digits format. | SQL script, title, header, footer and report file name. |
| $DATE.MM$ | Current month, 1 to 12. | SQL script, title, header, footer and report file name. |
| $DATE.DD$ | Current day, 1 to 31. | SQL script, title, header, footer and report file name. |
| $TIME$ | Current time. The presentation format can be changed via settings. | SQL script, title, header, footer and report file name. |
| $TIME.HH$ | Current hour, 0 to 23. | SQL script, title, header, footer and report file name. |
| $FILE$ | The report file name. All macros are resolved. | Title, header and footer. |
| $FORMAT$ | The report format: HTML, XML, Text, etc. | Title, header, footer and report file name. |
| $QUERY$ | The complete text of the SQL script. | Title, header and footer. |
| $QUERYn$ | Current SQL statement for multi-statements script or equals $QUERY$ for single statement. | Header and footer |
| $NAME$ | The first SQL statement name defined as a special comment. | Header and footer |
| $NAMEn$ | Current SQL statement name defined as a special comment. | Header and footer |
| $ROWS$ | Number of rows fetched by current SQL statement. For the preview it shows up to 50 preview rows, not an actual number. | Footer |
| $STATEMENT$ | Total SQL statements in the script | Header and footer |
| parameter name | Value of the parameter | SQL script, title, header, footer and report file name. |