Im using the latest version of SQLCL, when i try to use the SET NEWPAGE command i get the following error: SP2-0158: unknown SET option "newpage" The help documentation shows the newpage option should be available. Im trying to get rid of the first empty line when i output my query to CSV using spool. Is this a bug?
To verify the current state of support for a specific SET option, use SHOW <set_option>. So for your case....
I recall a report of an initial empty line in csv files, but I cannot the link to that discussion at the moment. Not sure if there is any workaround.