REPLACE MACRO SystemFE.BynetEvents (Fromdate (date, FORMAT 'YYYY-MM-DD'), Todate (date, DEFAULT DATE, FORMAT 'YYYY-MM-DD')) AS ( echo 'set defaults;'; echo 'set format on;'; echo 'set width 254;'; echo 'set NULL as "-";'; echo 'set separator 2;'; echo 'set pagelength 60;'; echo 'set omit on 1,2;'; echo 'set suppress on 3,4;'; echo 'set heading "&DATE BYNET Events Between &1 and &2 &TIME|| ||";'; Select :Fromdate (Format 'YYYY-MM-DD') , :Todate (Format 'YYYY-MM-DD') , TheDate (Title 'Date') , TheTime (Title 'Time') , Text (Title 'Message Text') From DBC.software_event_log where ((Event_tag>=0331110000 AND Event_tag<=0331112100) OR (Event_tag >= 0331290000 AND Event_tag <= 0331297800) OR (Event_tag >= 0331300000 AND Event_tag <= 0331302100) OR (Text like '%bynet%')) And TheDate BETWEEN :fromdate AND :Todate Order by TheDate, TheTime, Line; echo 'set defaults;'; );