Ansicht
Dokumentation

SQL0216 - Number of values in predicate lists do not match. ( OS/400 )

SQL0216 - Number of values in predicate lists do not match. ( OS/400 )

Fill RESBD Structure from EBP Component Structure   PERFORM Short Reference  
This documentation is copyright by IBM.
SAP E-Book


Message : SQL0216
Number of values in predicate lists do not match.

Message Long Text :

Cause . . . . . : The number of values on the left side of the predicate does not match the number of values on the right side of the predicate.
If one side of the predicate is a fullselect that returns more than one result column, the other side of the predicate must be a list of expressions containing the same number of values. The fullselect must explicitly list the result columns.
If both sides of the predicate are expression lists, the lists must contain the same number of values.
An expression list used in an IN or NOT IN predicate cannot contain an untyped parameter marker.
The subquery contains a correlated reference that is not supported. This may occur when there is a UNION, EXCEPT, or INTERSECT in the subquery.
Recovery . . . : Change the number of values in the predicate list or in the select list of a row fullselect so both sides contain the same number of values. Change a SELECT * in the fullselect to list the actual columns. Use a casting function for untyped parameter markers in an IN expression list.

Message File : QSQLMSG
Library Message File : QSYS2924


RFUMSV00 - Advance Return for Tax on Sales/Purchases   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by IBM.

Length: 3239 Date: 20240329 Time: 012504     sap01-206 ( 3 ms )