I'm doing the following spooling statement:
SET VERIFY OFF
SET FEEDBACK OFF
SET HEADING OFF
SET TRIMSPOOL ON
SET TERM OFF
SPOOL &pathRelations
START scripts/relations.sql &parent
SPOOL OFF
SET TERM ON
The scripts/relations.sql
file contains a simple select
statement.
Unfortunately, the spooled file contains an empty line as the first one in the file. This line causes trouble in our framework.
Of course I could get rid of these line through sed
but ain't there a way to suppress its creation in the first place?
SET NEWPAGE NONE
is the correct answer.
SET NEWPAGE 0
will cause a page feed, which is not what the OP wants.
FYI set newpage does nothing if using set markup csv on. Set markup csv on creates an LFCR at the beginning of the file which excel uses and adds a blank row.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With