Ansicht
Dokumentation

SQL402C - Temporary table created for hash join results. ( OS/400 )

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


Message : SQL402C
Temporary table created for hash join results.

Message Long Text :

Cause . . . . . : The results of the hash join were written to a temporary table so that query processing could be completed. The temporary table was required because the query contained one or more of the following:
GROUP BY or summary functions
ORDER BY
DISTINCT
Expression containing columns from more than one table
Complex row selection involving columns from more than one table
Recovery . . . : Refer to the DB2 for i - Database Performance and Query Optimization topic collection in the Database category in the IBM i Information Center for more information on the hashing algorithm for join processing.

Message File : QSQLMSG
Library Message File : QSYS2924


BAL Application Log Documentation   CPI1466 during Backup  
This documentation is copyright by IBM.

Length: 3238 Date: 20240427 Time: 063251     sap01-206 ( 3 ms )