Ansicht
Dokumentation

COMMIT WORK in SELECT loops <br />Tip-No.: 72 ( INFO72 )

COMMIT WORK in SELECT loops
Tip-No.: 72 ( INFO72 )

PERFORM Short Reference   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.
SAP E-Book

Short text

COMMIT WORK in SELECT loops
Tip-No.: 72

Symptom

Program abend (RSQL error 4096)

Cause

The data base cursor was closed implicitly or explicitly within a
SELECT or EXEC SQL loop. The following language elements could lead
to this:

Explicit : COMMIT WORK
ROLLBACK WORK

Implicit : MESSAGE (except MESSAGE S... )
COMMUNICATION
CALL SCREEN or other constructions that lead to
screen output.
CALL DIALOG
CALL TRANSACTION
SUBMIT
BREAK-POINT (if an ABAP program or a screen
had to be previously generated, also valid for
dynamically set breakpoints)

Solution

Do not use these language elements in SELECT or SQL loops.






Fill RESBD Structure from EBP Component Structure   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

Length: 1002 Date: 20240419 Time: 062622     sap01-206 ( 13 ms )