Ansicht
Dokumentation

SQL7910 - SQL cursors closed. ( OS/400 )

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   BAL Application Log Documentation  
This documentation is copyright by IBM.


Message : SQL7910
SQL cursors closed.

Message Long Text :

Cause . . . . . : SQL cursors have been closed and all Open Data Paths (ODPs) have been deleted, except those that were opened by programs with the CLOSQLCSR(*ENDJOB) option or were opened by modules with the CLOSQLCSR(*ENDACTGRP) option. All SQL programs on the call stack have completed, and the SQL environment has been exited. This process includes the closing of cursors, the deletion of ODPs, the removal of prepared statements, and the release of locks.
Recovery . . . : To keep cursors, ODPs, prepared statements, and locks available after the completion of a program, use the CLOSQLCSR precompile parameter.
-- The *ENDJOB option will allow the user to keep the SQL resources active for the duration of the job.
-- The *ENDSQL option will allow the user to keep SQL resources active across program calls, provided the SQL environment stays resident. Running an SQL statement in the first program of an application will keep the SQL environment active for the duration of that application.
-- The *ENDPGM option, which is the default for non-Integrated Language Environment (ILE) programs, causes all SQL resources to only be accessible by the same invocation of a program. Once an *ENDPGM program has completed, if it is called again, the SQL resources are no longer active.
-- The *ENDMOD option causes all SQL resources to only be accessible by the same invocation of the module.
-- The *ENDACTGRP option, which is the default for ILE modules, will allow the user to keep the SQL resources active for the duration of the activation group.

Message File : QSQLMSG
Library Message File : QSYS2924


PERFORM Short Reference   BAL Application Log Documentation  
This documentation is copyright by IBM.

Length: 3211 Date: 20240424 Time: 045830     sap01-206 ( 3 ms )