Ansicht
Dokumentation

SQL0342 - Keyword not allowed in recursive common table expression &1. ( OS/400 )

TXBHW - Original Tax Base Amount in Local Currency   PERFORM Short Reference  
This documentation is copyright by IBM.


Message : SQL0342
Keyword not allowed in recursive common table expression &1.

Message Long Text :

Cause . . . . . : The common table expression &1 is recursive. The recursive common table expression contains one of the following errors:
-- A fullselect within the common table expression cannot start with SELECT DISTINCT because the common table expression is recursive.
-- A fullselect within the common table expression specified UNION instead of UNION ALL as required for recursive common table expressions.
Recovery . . . : Remove the keyword DISTINCT from the fullselect. Change the UNION to UNION ALL, or remove the recursive reference within the common table expression. Try the request again.

Message File : QSQLMSG
Library Message File : QSYS2924


Vendor Master (General Section)   CPI1466 during Backup  
This documentation is copyright by IBM.

Length: 3246 Date: 20240427 Time: 003524     sap01-206 ( 3 ms )