Ansicht
Dokumentation

SQL0415 - UNION, EXCEPT, INTERSECT, or VALUES operands not compatible. ( OS/400 )

General Data in Customer Master   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by IBM.


Message : SQL0415
UNION, EXCEPT, INTERSECT, or VALUES operands not compatible.

Message Long Text :

Cause . . . . . : Column &2 is not compatible with the corresponding column in another subselect of the UNION, EXCEPT, or INTERSECT or in another row of a VALUES clause. The relative position of the value in the select list is &1. One of the following conditions exists:
-- One column is character, graphic, or numeric and the other is not character, graphic, or numeric.
-- One of the columns is date, time, or timestamp and the other is not character or the same type.
-- One column is binary, and the other is not binary. If the column name is *N, the column is not a named column.
Recovery . . . : Change the columns of the operands of the UNION, EXCEPT, INTERSECT, or VALUES clause so that they are compatible. A casting function can be used to make the columns compatible types. Try the request again.

Message File : QSQLMSG
Library Message File : QSYS2924


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

Length: 3248 Date: 20240420 Time: 144939     sap01-206 ( 3 ms )