Ansicht
Dokumentation

CPF427C - Stacked updates not allowed. ( OS/400 )

CPF427C - Stacked updates not allowed. ( OS/400 )

PERFORM Short Reference   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by IBM.
SAP E-Book


Message : CPF427C
Stacked updates not allowed.

Message Long Text :

Cause . . . . . : Stacked updates are not allowed for member &4 of file &2 in library &3. Stacked updates are not allowed because of one of the following reasons:
- CCSID (Coded Character Set IDentification) translation will be required for a multi-format logical file. The open is not allowed because the update operation will be unable to determine which format was used when locking a particular record for update, and, as a result, will then be unable to determine which translation requirements to use for the update.
- A commitment control level of cursor stability has also been requested. The open is not allowed because stacked updates are not supported when processing under the commitment control level of cursor stability.
- The file being opened for update is a distributed file. The open is not allowed because stacked updates are not supported for distributed files.
- An INSTEAD OF update or INSTEAD of delete trigger applies to the file that is being opened. The open is not allowed because the update will be unable to determine the record image to pass to the trigger.
Recovery . . . : Do one of the following:
- If the open operation will require CCSID translation, then either change the application to not stack updates so that database can know which format is going to be used for the update, or change the job CCSID to *HEX and have the application do any required CCSID conversions. See the NLS Planning Guide for more details on CCSIDs.
- If the open operation is attempting to place the member under the commitment control level of cursor stability, then either change the application to not stack updates, or change the application to process under another commitment control level.
- If the open operation is attempting to open a distributed file and stacked updates are required for the application, then change the file so it is not a distributed file.
- If an INSTEAD OF update or INSTEAD OF delete trigger applies to the open operation, use the SQL DROP TRIGGER statement to drop the trigger from the file.

Message File : QCPFMSG
Library Message File : QSYS2924


CL_GUI_FRONTEND_SERVICES - Frontend Services   General Data in Customer Master  
This documentation is copyright by IBM.

Length: 3226 Date: 20240329 Time: 164332     sap01-206 ( 3 ms )