Good Afternoon,
I recently updated to version 4.1.3.20 and have been having issues spooling since. I run a series of scripts that have not changed, that save data to a csv file on a shared network. When I run the scripts now I get this error: SP2-0768: Illegal SPOOL command.
I have been able to successfully spool by changing the directory to my c drive instead of my work's shared drive, but the file is not usable. It either comes out blank or broken up into sections of no more than 15 rows. Here is an example of the output:
COUNTY AGENCY Index Crimes Reported in 2014 % of County Total
Westchester Agency 1 94 .8%
Westchester Agency 2 58 .5%
Westchester Agency 3 89 .7%
Westchester Agency 4 130 1.1%
Westchester Agency 5 61 .5%
Westchester Agency 6 92 .8%
Westchester Agency 7 47 .4%
Westchester Agency 8 124 1%
Westchester Agency 9 103 .9%
Westchester Agency 10 9 .1%
Westchester Agency 11 424 3.5%
Westchester Agency 12 1,146 9.5%
Westchester Agency 13 2,972 24.5%
Westchester Agency 14 225 1.9%
COUNTY AGENCY Index Crimes Reported in 2014 % of County Total
Westchester Total 12,116 100.2%
Wyoming Agency 15 25 6.6%
Wyoming Agency 16 12 3.2%
Wyoming Agency 17 65 17.2%
Wyoming Agency 18 80 21.1%
Wyoming Agency 19 5 1.3%
Wyoming Agency 20 39 10.3%
Wyoming Agency 21 153 40.4%
I have been looking at other blogs and tried changing the output settings under preferences > database > worksheet so that the max rows to print in a script is 50000000.
I have also tried setting the sql format. This does help the output to look more like a table when I run it, but the output is still truncated into sections of 15 rows or less so it is not usable as a csv file.
set sqlformat ansiconsole;
Set echo off
Set Colsep ,
Spool C:\Users\username\Contributing_Agencies.csv
Select * from livedb
Spool off;
What else can I do? Is there something new in this version of developer that is causing this to occur? Any help is greatly appreciated.