Ansicht
Dokumentation

QRY2215 - &12 used, rest of join tests must be blank. ( OS/400 )

QRY2215 - &12 used, rest of join tests must be blank. ( OS/400 )

rdisp/max_wprun_time - Maximum work process run time   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by IBM.
SAP E-Book


Message : QRY2215
&12 used, rest of join tests must be blank.

Message Long Text :

Cause . . . . . : You typed *ALL as the first field name in the join tests; however, when *ALL is used, no other join tests can be specified. If you specify *ALL (to join matched records), every record in a file is joined to every record in the other files. This can create a very large number of records in the joined file and can affect performance. For more information on specifying join tests, see the appropriate section in the Query User's Guide or press the Help key while on the Specify How to Join Files display.
Recovery . . . : Change the join tests using field names and tests. To use *ALL as the join test, type *ALL in the first field and blank out the other fields and tests.

Message File : QQRYMSG
Library Message File : QSYS2924


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

Length: 3225 Date: 20240426 Time: 201716     sap01-206 ( 3 ms )