Ansicht
Dokumentation

CPI430C - ROLLBACK ignored for cursor positioning. ( OS/400 )

CPI1466 during Backup   Addresses (Business Address Services)  
This documentation is copyright by IBM.


Message : CPI430C
ROLLBACK ignored for cursor positioning.

Message Long Text :

Cause . . . . . : The query was opened at the *CS or *ALL commitment control level as specified on either the Start Commitment Control (STRCMTCTL) command, the COMMIT parameter on the Start SQL (STRSQL) command, or the COMMIT parameter on the precompile command. However, the query specified had to be processed such that, if a ROLLBACK statement is used later on, the cursor's position will not be the same as it was at the start of the unit of recovery. The query had one of the following options specified that caused this condition:
-- The UNION, EXCEPT, or INTERSECT keyword.
-- The DISTINCT keyword.
-- The GROUP BY clause, HAVING clause, GRPFLD parameter, GRPSLT parameter or a column function.
-- The ORDER BY keyword or KEYFLD parameter and the sum of the lengths of the fields given in the clause or parameter required that a sort be performed.
Recovery . . . : If you require that, on a ROLLBACK, the cursor is repositioned to where it was at the start of the unit of recovery, then remove all options specified above from the query. Try the request again after making these changes.

Message File : QCPFMSG
Library Message File : QSYS2924


Addresses (Business Address Services)   ABAP Short Reference  
This documentation is copyright by IBM.

Length: 3230 Date: 20240420 Time: 041104     sap01-206 ( 2 ms )