We are hiring and constantly growing! Have a look through our vacancies to find the right role for you!

QRY2221 - Join specifications not allowed. ( OS/400 )

QRY2221 - Join specifications not allowed. ( OS/400 )

Fill RESBD Structure from EBP Component Structure   ROGBILLS - Synchronize billing plans  
This documentation is copyright by IBM.
SAP E-Book


Message : QRY2221
Join specifications not allowed.

Message Long Text :

Cause . . . . . : Error &9 was found in the query while building the definition template.
CPD4338 - The join type of the specified files and the specified type of join in the query are different.
CPD431A - A distinct view cannot be joined with another file.
CPD4371 - Different or not allowed join tests were specified for a comparison between the same pair of file IDs.
CPD4361 - Too many files were requested to be joined.
CPD4343 - Too many join fields for a secondary file.
CPD4378 - Joining group by files not allowed.
CPD4337 - Join operand not valid. One of the following errors occurred:
- the coded character set identifiers (CCSID)s of the two fields are not compatible, or
- a character field is not long enough to contain a valid date, or the field does not contain a valid date.
CPD433B - DISTINCT not valid when substitution character warning may be issued.
Recovery . . . :
Change the query definition to use files, join type, and join tests that are compatible.
Use the Display Message Description (DSPMSGD) command to get more information about error &9. See DB2 UDB for i5/OS SQL Programming Concepts for more information about SQL views. See DB2 UDB for i5/OS Database Programming for more information about join logical files, join types, and join tests.

Message File : QQRYMSG
Library Message File : QSYS2924


BAL_S_LOG - Application Log: Log header data   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by IBM.

Length: 3238 Date: 20201028 Time: 040457     sap01-206 ( 73 ms )