Ansicht
Dokumentation

CPI4324 - Temporary file built for file &1. ( OS/400 )

CPI4324 - Temporary file built for file &1. ( OS/400 )

rdisp/max_wprun_time - Maximum work process run time   Vendor Master (General Section)  
This documentation is copyright by IBM.
SAP E-Book


Message : CPI4324
Temporary file built for file &1.

Message Long Text :

Cause . . . . . : A temporary file was built for member &3 of file &1 in library &2 for reason code &4. This process took &5 minutes and &6 seconds. The temporary file was required in order for the query to be processed. The reason codes and their meanings follow:
1 - The file is a join logical file and its join-type (JDFTVAL) does not match the join-type specified in the query.
2 - The format specified for the logical file references more than one physical file.
3 - The file is a complex SQL view, or nested table expression, or common table expression, or is a data change table reference that requires a temporary file.
4 - For an update-capable query, a subselect references a field in this file which matches one of the fields being updated.
5 - For an update-capable query, a subselect references SQL view &1, which is based on the file being updated.
6 - For a delete-capable query, a subselect references either the file from which records are to be deleted or an SQL view or logical file based on the file from which records are to be deleted.
7 - The file is user-defined table function &8 in &2, and all the records were retrieved from the function. The processing time is not returned for this reason code.
8 - The file is a partition file requiring a temporary file for processing the grouping or join.
Recovery . . . : You may want to change the query to refer to a file that does not require a temporary file to be built.

Message File : QCPFMSG
Library Message File : QSYS2924


BAL_S_LOG - Application Log: Log header data   ABAP Short Reference  
This documentation is copyright by IBM.

Length: 3231 Date: 20240328 Time: 174649     sap01-206 ( 3 ms )