HTML Output

If you want to view the HTML code generated, use Notepad, not Word. The spool file can have the following extensions: HTM, DOC or XLS. The prompt at the end is just to remind folks where to find the report generated.

SET MARKUP HTML ON ENTMAP ON SPOOL ON PREFORMAT OFF
SET TERM OFF

SPOOL EMP.HTM

Select *
from EMP;

SPOOL OFF

SET MARKUP HTML OFF ENTMAP OFF SPOOL OFF PREFORMAT OFF
SET TERM ON

PROMPT ** Report Completed. Use Mozilla to view your output: EMP.HTM **