variables.sql

WITH report_vars AS (
  SELECT
    ('[[From date=date]]') AS "REPORT_START",
    ('[[To date=date]]') AS "REPORT_END",
    ('[[Report Period=query_list(SELECT report_period FROM report_period WHERE completed != 1 ORDER BY start_date)]]') AS "REPORT_PERIOD"

  FROM SYSIBM.sysdummy1
)

SELECT * FROM report_vars