Ansicht
Dokumentation

CPI4327 - &12 &13 processed in join position &10. ( OS/400 )

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


Message : CPI4327
&12 &13 processed in join position &10.

Message Long Text :

Cause . . . . . : Arrival sequence access was used to select records from member &2 of file &13 in library &1.
If file &13 in library &1 is a logical file then member &8 of physical file &6 in library &7 is the actual file in join position &10.
A file name that starts with *QUERY for the file indicates it is a temporary file.
Recovery . . . : Generally, to force a file to be processed in join position 1, specify an order by field from that file only.
Refer to the DB2 for i - Database Performance and Query Optimization topic collection in the Database category in the IBM i Information Center for additional tips on optimizing a query's join order.

Message File : QCPFMSG
Library Message File : QSYS2924


PERFORM Short Reference   General Material Data  
This documentation is copyright by IBM.

Length: 3227 Date: 20240423 Time: 194540     sap01-206 ( 3 ms )