Ansicht
Dokumentation

SQL401A - Processing grouping criteria for query containing a distributed table. ( OS/400 )

BAL_S_LOG - Application Log: Log header data   General Material Data  
This documentation is copyright by IBM.


Message : SQL401A
Processing grouping criteria for query containing a distributed table.

Message Long Text :

Cause . . . . . : Grouping for queries that contain distributed tables can be implemented using either a one or two step method. If the one step method is used, the grouping columns (GROUP BY) match the partitioning keys of the distributed table. If the two step method is used, the grouping columns do not match the partitioning keys of the distributed table or the query contains grouping criteria but no grouping columns were specified. If the two step method is used, message SQL401B will appear followed by another SQL401A message.
Recovery . . . : For more information on processing of distributed tables, refer to the DB2 Multisystem topic collection in the Database category in the IBM i Information Center book, http://www.ibm.com/systems/i/infocenter/.

Message File : QSQLMSG
Library Message File : QSYS2924


Addresses (Business Address Services)   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by IBM.

Length: 3252 Date: 20240424 Time: 092531     sap01-206 ( 4 ms )