The following is an example of a macro to produce a report called Department Information:
CREATE MACRO deptdisplay AS ( ECHO '.SET SEPARATOR " | " '; ECHO '.SET RTITLE "Department Information" '; ECHO '.SET FORMAT ON'; SELECT * FROM department;);
The following is an example of a macro to produce a report called Department Information:
CREATE MACRO deptdisplay AS ( ECHO '.SET SEPARATOR " | " '; ECHO '.SET RTITLE "Department Information" '; ECHO '.SET FORMAT ON'; SELECT * FROM department;);