Ansicht
Dokumentation

CPI430B - COMMIT(*CHG) specified but ignored. ( OS/400 )

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


Message : CPI430B
COMMIT(*CHG) specified but ignored.

Message Long Text :

Cause . . . . . : The *CHG value was specified for 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 was not opened under commitment control. If a ROLLBACK statement is used, 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 COMMIT(*CHG) to be ignored:
-- The GROUP BY clause, HAVING clause, GRPFLD parameter, GRPSLT parameter, or a column function.
-- The DISTINCT keyword.
-- The UNION, EXCEPT, or INTERSECT keyword.
-- The ORDER BY keyword or KEYFLD parameter and the sum of the lengths of the fields in the clause or parameter required that a sort be performed.
-- The UNIQUEKEY parameter.
-- A complex logical file that had to be copied to a temporary file.
-- A system file was referenced in the query.
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


Vendor Master (General Section)   General Data in Customer Master  
This documentation is copyright by IBM.

Length: 3231 Date: 20240419 Time: 190344     sap01-206 ( 4 ms )