set termout off prevents text (results of queries, prompt etc.) from being written (echo'ed) to the terminal if the text originates from a statement in an SQL script started with start, @ or @@. termout. set termout on must be used. spool sends the output that is normally written to the console also to a file (or printer).