Ansicht
Dokumentation

SQL0345 - Recursive common table expression &1 is not valid. ( OS/400 )

SQL0345 - Recursive common table expression &1 is not valid. ( OS/400 )

CPI1466 during Backup   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by IBM.
SAP E-Book


Message : SQL0345
Recursive common table expression &1 is not valid.

Message Long Text :

Cause . . . . . : The recursive common table expression is not valid for one of the following reasons:
-- The initialization fullselect of the common table expression cannot refer to itself.
-- Grouping, aggregate functions, and ORDER BY are not allowed within the fullselects of the UNION that define the common table expression.
-- EXCEPT DISTINCT is not allowed if the common table is specified as the right operand of a join.
-- LEFT OUTER JOIN and FULL OUTER JOIN are not allowed if the common table is specified as the right operand of the join.
-- RIGHT OUTER JOIN and FULL OUTER JOIN are not allowed if the common table is specified as the left operand of the join.
-- The common table expression cannot be referenced more than once in a FROM clause and cannot be referenced in a subquery.
Recovery . . . : Correct the recursive common table expression. Try the request again.

Message File : QSQLMSG
Library Message File : QSYS2924


ABAP Short Reference   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by IBM.

Length: 3244 Date: 20240328 Time: 150014     sap01-206 ( 2 ms )