cat > script.ff <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
	program rng2
EXEC SQL INCLUDE SQLCA;
EXEC SQL WHENEVER SQLERROR GOTO 70;
EXEC SQL BEGIN DECLARE SECTION;
	character *25 name, date *20, amount *9
	character *8 am 
	character *7 amt1, amt2, amt3, amt4 
EXEC SQL END DECLARE SECTION;
EXEC SQL INIT;
EXEC SQL DATABASE IS "DATABASE";

	am = "amount"
	amt1 = "33.95"
	amt2 = "150"
EXEC SQL DECLARE c CURSOR FOR SELECT FROM loans WHERE :am range 
		:amt1 to :amt2;
EXEC SQL OPEN c;
EXEC SQL WHENEVER NOT FOUND GOTO 20;
 10	continue 
EXEC SQL FETCH c name, date, amount INTO :name, :date, :amount;
	write (*,101) name,date,amount
 101    format (' ', A25, A20, A8)
	goto 10
 20	continue
	print *," " 
EXEC SQL CLOSE c;
EXEC SQL DECLARE d CURSOR FOR SELECT FROM loans WHERE amount between
		:amt1 exclusive and :amt2 exclusive;
EXEC SQL OPEN d;
EXEC SQL WHENEVER NOT FOUND GOTO 40;
 30	continue
EXEC SQL FETCH d name, date, amount INTO :name, :date, :amount;
	write (*,101) name,date,amount
	goto 30 
 40	continue
	print *," "
EXEC SQL CLOSE d;
	amt3 = "200"
	amt4 = "300"
EXEC SQL DECLARE e CURSOR FOR SELECT FROM loans WHERE amount range
		:amt1 inclusive to :amt2 exclusive or amount range 
		:amt3 to :amt4 exclusive; 
EXEC SQL OPEN e;
EXEC SQL WHENEVER NOT FOUND GOTO 60;
 50	continue
EXEC SQL FETCH e name, date, amount INTO :name, :date, :amount;
	write (*,101) name,date,amount
	goto 50
 60	continue 
	print *, " "
EXEC SQL EXIT;
	STOP
 70	continue
	write (*,1001) SQLRET, sqltxt
 1001	format (' ', "SQLRET number ", I6, "Message is ", A70)
EXEC SQL EXIT ;
	STOP
	END
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 script.ff
cat > stdout <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
Mosca                    2 February  1981    $150.00 
Jones                    7 February  1981    $33.95  
Wladislaw                27 February  1981   $55.00  
Peterson                 6 June      1981    $50.00  
Wladislaw                25 June      1981   $75.00  

Wladislaw                27 February  1981   $55.00  
Peterson                 6 June      1981    $50.00  
Wladislaw                25 June      1981   $75.00  

Jones                    7 February  1981    $33.95  
Kilroy                   16 February  1981   $250.00 
Wladislaw                27 February  1981   $55.00  
Mosca                    4 May       1981    $200.00 
Peterson                 6 June      1981    $50.00  
Wladislaw                25 June      1981   $75.00  

+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout
cat > tag <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
Test of select in range between two variables
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
