need help: extra blank lines (break and compute)

[aparente001]

Hi, I'm getting two mysterious blank lines after the first line of each group. I am attaching and appending the code and the output. See

http://academ.hvcc.edu/~m-stein/q4.sql

and

http://academ.hvcc.edu/~m-stein/out4

Thanks.

-- purpose: Create a list of all aircraft, showing the manufacturer, 
--			model name, aircraft number, and charters trips flown
--			(destination, miles flown, and revenue generated).  In
--			addition, generate totals of revenue generated and miles
--			flown for each aircraft.

COLUMN make -
   FORMAT A10 -
   HEADING 'Make'
COLUMN modl -
   FORMAT A18 -
   HEADING 'Model'
COLUMN ac_number -
	FORMAT A6 -
	HEADING 'plane#'
COLUMN destination -
	FORMAT A7 -
	HEADING 'airport'
COLUMN char_distance -
	FORMAT 99999 -
	HEADING 'distance'
COLUMN revenue -
	FORMAT $99999.99 -
	HEADING 'revenue'
   
BREAK ON make skip 1 ON modl skip 1 ON ac_number skip 1
COMPUTE SUM OF revenue ON ac_number
COMPUTE SUM OF char_distance ON ac_number

SET PAGESIZE 54
SPOOL out4

SELECT m.mod_manufacturer AS make, m.mod_name AS modl, a.ac_number,
	char_trip, ch.destination, ch.char_distance,
	1.35 * m.mod_chg_mile * ch.char_distance AS revenue
FROM hartmar.aircraft a 
	LEFT JOIN hartmar.charter ch ON a.ac_number = ch.ac_number
	LEFT JOIN hartmar.model m ON a.mod_code = m.mod_code
ORDER BY make, modl, ac_number;

CLEAR COLUMNS BREAKS COMPUTES
SPOOL OFF

Make Model plane# CHAR_TRIP airport distance revenue
---------- ------------------ ------ ---------- ------- -------- ----------
Beechcraft KingAir 2289L 10025 ATL 936 $3285.36


10029 ATL 1023 $3590.73
10055 GNV 1645 $5773.95
10049 GNV 1574 $5524.74
10031 GNV 1574 $5524.74
10022 GNV 1574 $5524.74
10014 GNV 1574 $5524.74
10041 ATL 936 $3285.36
10037 GNV 1645 $5773.95
10045 ATL 1023 $3590.73
****** -------- ----------
sum 13504 $47399.04



Cessna Citation Mustang 1234C


****** -------- ----------
sum


Citation Sovereign 2345C


****** -------- ----------
sum



Piper Axtec 1484P 10023 STL 508 $1303.02


10013 TYS 644 $1651.86
10004 STL 508 $1303.02
10051 BNA 352 $902.88
10048 TYS 644 $1651.86
10044 STL 472 $1210.68
10039 STL 508 $1303.02
10033 BNA 352 $902.88
10028 STL 472 $1210.68
****** -------- ----------
sum 4460 $11439.90


Navajo Chieftain 2278V 10034 MOB 884 $2804.49


10052 MOB 884 $2804.49

Make Model plane# CHAR_TRIP airport distance revenue
---------- ------------------ ------ ---------- ------- -------- ----------
Piper Navajo Chieftain 2278V 10056 MQY 312 $989.82


10047 GNV 1574 $4993.52
10012 GNV 1574 $4993.52
10007 BNA 320 $1015.20
10042 BNA 320 $1015.20
10038 MQY 312 $989.82
10026 BNA 320 $1015.20
****** -------- ----------
sum 6500 $20621.25

4278Y 10032 ATL 998 $3166.16
10053 TYS 646 $2049.44
10019 ATL 936 $2969.46
10030 STL 472 $1497.42
10046 STL 472 $1497.42
10024 TYS 644 $2043.09
10027 GNV 1574 $4993.52
10008 GNV 1574 $4993.52
10015 ATL 998 $3166.16
10040 TYS 644 $2043.09
10054 ATL 936 $2969.46
10003 TYS 644 $2043.09
10018 TYS 646 $2049.44
10036 ATL 936 $2969.46
10035 TYS 646 $2049.44
10050 ATL 998 $3166.16
10043 GNV 1574 $4993.52
****** -------- ----------
sum 15338 $48659.81




47 rows selected.

 

[Dagon]

Have a look at the line:

BREAK ON make skip 1 ON modl skip 1 ON ac_number skip 1

and what the skip 1 means.