Ansicht
Dokumentation

SQL0501 - Cursor &1 not open. ( OS/400 )

PERFORM Short Reference   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by IBM.


Message : SQL0501
Cursor &1 not open.

Message Long Text :

Cause . . . . . : The cursor &1 was specified in a FETCH or CLOSE statement, but the cursor is not open. Cursor &1 has one of the following conditions:
-- Cursor &1 was never opened.
-- The cursor &1 was opened in another program or another call of this program and the program was created with CLOSQLCSR(*ENDPGM).
-- The cursor &1 was opened in another module or another call of this module and the module was created with CLOSQLCSR(*ENDMOD).
-- The cursor &1 was opened in another call of this program and programs which have run SQL statements have ended and the program was created with CLOSQLCSR(*ENDSQL).
-- The cursor &1 was opened in another call of this module and the activation group ended between calls. The module was created with CLOSQLCSR(*ENDACTGRP).
-- The cursor was closed by a CLOSE, COMMIT, or ROLLBACK statement.
-- The cursor &1 was opened under a transaction which is different than the current transaction.
Recovery . . . : Do one of the following and precompile again:
-- Make certain that cursor &1 is opened in the same program or module call prior to using the cursor in an FETCH or CLOSE statement.
-- Specify either CLOSQLCSR(*ENDSQL), CLOSQLCSR(*ENDJOB), or CLOSQLCSR(*ENDACTGRP) when precompiling the application.
-- If the cursor was closed by a COMMIT or ROLLBACK, specify HOLD on the COMMIT or ROLLBACK statement to preserve any open cursors, prepared statements, and locks on tables.

Message File : QSQLMSG
Library Message File : QSYS2924


RFUMSV00 - Advance Return for Tax on Sales/Purchases   ABAP Short Reference  
This documentation is copyright by IBM.

Length: 3221 Date: 20240425 Time: 172303     sap01-206 ( 4 ms )