Ansicht
Dokumentation

CPF4028 - Open of member &1 was changed to SEQONLY(*NO). ( OS/400 )

ROGBILLS - Synchronize billing plans   BAL Application Log Documentation  
This documentation is copyright by IBM.


Message : CPF4028
Open of member &1 was changed to SEQONLY(*NO).

Message Long Text :

Cause . . . . . : Member &1 file &2 in library &3 was opened with the SEQONLY(*YES) parameter specified in the program or on the Override Database File (OVRDBF) command. However, the parameter has been changed to SEQONLY(*NO) because of condition &4 shown below:
1 - The program opened member &1 for output operations only and SEQONLY(*YES) was specified with the default number of records. SEQONLY(*YES) was changed to SEQONLY(*NO) to allow the program to handle duplicate key, conversion mapping, key mapping, and select or omit errors, or both select and omit errors at the time of the output operation.
2 - The program opened the member for other than input or output operations only.
3 - The program opened a logical file member for output operations only and that member is based on more than one physical file member.
4 - The record length plus the feedback information for the member is greater than 32,767 bytes.
5 - The commitment control level of *ALL is active and the member was opened for input operations only, or the commitment control levels of either *ALL, *CS, or *CHG were specified for a distributed file that was opened for input operations only.
6 - The program opened member &1 for output operations only and SEQONLY(*YES) was specified with the default number of records and duplicate key feedback or insert key feedback was requested. SEQONLY(*YES) was changed to SEQONLY(*NO) to allow duplicate key feedback or insert key feedback to be provided on a record by record basis.
7 - The program opened a query member that contains at least one subselect. Either the outermost subselect provided a correlated reference for a subquery or the outermost subselect processed a subquery with an IN, = ANY, or <> ALL subquery predicate operator, which is treated as a correlated reference. Only one record can be retrieved at a time from this type of query.
8 - The file has referential constraints, triggers, or is a distributed file. SEQONLY(*YES) was changed to SEQONLY(*NO) to allow the trigger programs to be called or the referential constraints to be enforced on a record by record basis, or because SEQONLY(*YES) is not allowed for the distributed file open.
9 - The file is a distributed file opened for DSTDTA(*CURRENT). One or more of the nodes in this file have been implemented using join logical file processing.
10 - The file, or a physical file on which the file is based, contains File Link Control DataLink fields. SEQONLY(*YES) was changed to SEQONLY(*NO) to allow the DataLink fields in each record to be processed.
Recovery . . . : For condition 1 or condition 6:
-- If changing parameter SEQONLY(*YES) to SEQONLY(*NO) is not acceptable, use the Override Database File (OVRDBF) command to override the parameter SEQONLY(*NO) by specifying SEQONLY(*YES N) where N indicates the number of records. Then try your request again.

Message File : QCPFMSG
Library Message File : QSYS2924


CPI1466 during Backup   ABAP Short Reference  
This documentation is copyright by IBM.

Length: 3250 Date: 20240426 Time: 141822     sap01-206 ( 2 ms )