cat > script.ff <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
	program trans1
EXEC SQL INCLUDE SQLCA;
EXEC SQL WHENEVER SQLERROR GOTO 30;
EXEC SQL BEGIN DECLARE SECTION;
	character *25 name, date *20, amount *9
	character *25 name1, date1 *20, amnt1 *9
	integer*2 i
EXEC SQL END DECLARE SECTION;
EXEC SQL INIT;
EXEC SQL DATABASE IS "DATABASE";

EXEC SQL START TRANSACTION;
EXEC SQL SELECT name, date, amount FROM loans into :name, :date, :amount
		WHERE name = "Kilroy";
	write (*,101) name,date,amount
 101    format (' ', A25, A20, A8)
	date = "19 March 1987"
	amount = "666.66"
EXEC SQL UPDATE loans SET name, date, amount VALUES :name, :date,
		:amount WHERE name = "Kilroy";
EXEC SQL SELECT name, date, amount FROM loans into :name, :date, :amount
		where name = "Kilroy";
	write (*,101) name,date,amount
	print *, " "
	i = -1
EXEC SQL UPDATE loans SET amount VALUES  
		:amount:i WHERE name = "Peterson";
EXEC SQL SELECT name, date, amount FROM loans INTO :name1, :date1, :amnt1
		WHERE name = "Peterson";
	write (*,101) name1,date1,amnt1
	print *, " "
EXEC SQL COMMIT TRANSACTION;
EXEC SQL DECLARE c CURSOR FOR SELECT FROM loans;
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
	goto 10
 20	continue
EXEC SQL EXIT;
	STOP
 30	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-+-+-+-+-+'
Kilroy                   16 February  1981   $250.00 
Kilroy                   19 March     1987   $666.66 

Peterson                 6 June      1981            

Mosca                    2 February  1981    $150.00 
Jones                    7 February  1981    $33.95  
Kilroy                   19 March     1987   $666.66 
Wladislaw                27 February  1981   $55.00  
Jones                    3 April     1981    $25.00  
Mosca                    4 May       1981    $200.00 
Wladislaw                12 May       1981   $25.00  
Peterson                 6 June      1981            
Wladislaw                25 June      1981   $75.00  
Jones                    12 August    1981   $300.00 
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 stdout
cat > tag <<'+-+-+-+-+-END-OF-FILE-+-+-+-+-+'
Test of transaction, committed
+-+-+-+-+-END-OF-FILE-+-+-+-+-+
chmod 644 tag
