|
Blue Forest http://www.lslnet.com at 11:08 on July 18, 2006
End result of the use of the storage process Vernier set, how closed and the release of vernier?
Our front-end application by calling a stored procedure in the course of storage, the results of inquiries by Vernier return set;
CREATE PROCEDURE DB2ADMIN.PROCEDURE1 (IN var0 VARCHAR (1)) DYNAMIC RESULT SETS 1
P1 : BEGIN
-- Statement Cursor
DECLARE CURSOR WITH RETURN FOR cursor1
SELECT * FROM AS BZB; DB2ADMIN.BZB
-- Client Application Program Vernier maintain open
OPEN cursor1;
Sound P1
End result set using the current terminal, from the application, the vernier whether to shut down automatically and release?
If we do not shut down automatically and released, and how close to release vernier? |
End result of the use of the storage process Vernier set, how closed and the release of vernier?
Shut down automatically and release! Select not take the initiative to shut down, unable to return to the Result Set! Others are close cursor |
| |