Ansicht
Dokumentation
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.
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 )