Linux -Blue forest free software | Return to home page | Site Map | Search WWW | Contact Us |
Your current position : Homepage > Free Software > Technological exchanges >Database


    

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



 Privacy Policy  Copyright © 1999-2000 LSLNET.COM. All rights reserved. Blue Forest website owners. E-mail : Webmaster@lslnet.com