C program and stored procedure

Hi everybody...

Here in Rome we have a little problem about C program and a stored procedure.

The host program calls a stored procedure with these instructions:

		EXEC SQL EXECUTE
			BEGIN
				procedure;
			END;
		END-EXEC;

When we kill the program, the stored procedure doesn't die. Why?

There is any way to kill the stored procedure when the calling program dies??

If someone has some suggest...

Thanks in advance

-- 
Andrea Pallotta
Ciside_RM DataBase Practice
-----------------------------------------------
Digital Equipment Corporation S.p.A.
Rome, Italy
Andrea.Pallotta_at_Digital.com