Ansicht
Dokumentation

SQ20452 - HIERARCHICAL QUERY CONSTRUCT &1 NOT USED CORRECTLY. ( OS/400 )

BAL_S_LOG - Application Log: Log header data   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by IBM.


Message : SQ20452
HIERARCHICAL QUERY CONSTRUCT &1 NOT USED CORRECTLY.

Message Long Text :

CAUSE . . . . . : THE &1 CONSTRUCT WAS FOUND OUTSIDE OF ITS ALLOWED CONTEXT FOR ONE OF THE FOLLOWING REASONS:
-- THE CONSTRUCT WAS SPECIFIED IN THE START WITH CLAUSE.
-- IN THE SUBSELECT WHERE IT WAS SPECIFIED, THERE IS NO CONNECT BY CLAUSE.
-- PRIOR WAS SPECIFIED OUTSIDE THE CONTEXT OF A CONNECT BY CLAUSE.
-- AN ARGUMENT OF CONNECT_BY_ROOT OR SYS_CONNECT_BY_PATH CANNOT BE AN AGGREGATE FUNCTION OR OLAP SPECIFICATION.
-- ORDER SIBLINGS BY WAS SPECIFIED, BUT THERE IS A DISTINCT, GROUP BY, OR HAVING CLAUSE IN THE QUERY WHICH HAS CHANGED THE PARTIAL ORDER PROVIDED BY THE HIERARCHICAL QUERY.
RECOVERY . . . : MAKE ONE OF THE FOLLOWING CHANGES AND TRY THE REQUEST AGAIN.
-- IF THE CONSTRUCT IS LEVEL AND THIS IS NOT A HIERARCHICAL QUERY, MAKE SURE A COLUMN OR VARIABLE WITH THAT NAME EXISTS AND CAN BE RESOLVED TO FOR THE STATEMENT.
-- VERIFY THAT THERE IS A CONNECT BY CLAUSE IN THE SUBSELECT CONTAINING &1.
-- REMOVE &1 FROM THE STATEMENT.

Message File : QSQLMSG
Library Message File : QSYS2924


CPI1466 during Backup   PERFORM Short Reference  
This documentation is copyright by IBM.

Length: 3249 Date: 20240420 Time: 070431     sap01-206 ( 3 ms )