I'm on a windows machine using sqlCL. I'm trying to run a .sql script which has a 'spool' command and everytime I do it, the output includes the entire code. How do get just the output without entire code. I'm not typing it directly in the command line. I"m just using sqlCL to call the script with @c:\test.sql.
Here is how my script is structured:
SET UNDERLINE OFF
SET COLSEP ','
set blanklines on
SET LINES 100 PAGES 100
set pages 0
SET FEEDBACK off
set echo off
termout off
SET HEADING off
set trimspool on
set trimout on
spool c:\testing123.csv
###MY SQL CODE#####
Select * from /*csv*/ from table
spool OFF.