spool rowcount displays

bmayfield

Member²
We are Version 6.0.6.947 and are running these commands:

--
set termout off;
set newpage none;
set recsep off;
set echo off; -- suppress showing sql in result set
set feedback off; -- eliminate row count message
set heading off;
set linesize 300; -- make line long enough to hold data
set pagesize 0; -- suppress headings and page breaks
--
spool F:\MyPrintToPdf\spooldata.txt;
--
select poc_insured_policy_id||chr(9)
||insured_fein||chr(9)
||insured_name||chr(9)
||insured_address_1||chr(9)
||insured_address_2||chr(9)
||insured_city||chr(9)
||insured_state||chr(9)
||insured_postal_code||chr(9)
||policy_number||chr(9)
||policy_effective_date||chr(9)
||policy_expiration_date||chr(9)
from c5;
--
spool off;

Output file has:
row 1
.
.
.
.
.
.
row 8

8 rows selected

Why does it insert 8 rows selected into the output file?

Thanks.
Bruce
 
Back
Top