Ansicht
Dokumentation

SQL0109 - &1 clause not allowed. ( OS/400 )

SQL0109 - &1 clause not allowed. ( OS/400 )

CPI1466 during Backup   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by IBM.
SAP E-Book


Message : SQL0109
&1 clause not allowed.

Message Long Text :

Cause . . . . . : One of the following conditions was not allowed:
-- SELECT INTO and VALUES INTO statements cannot include the FOR UPDATE clause, the FOR READ ONLY clause, the OPTIMIZE clause, or the UNION, EXCEPT or INTERSECT operator.
-- A SELECT or VALUES statement used in cursor declarations or subselects cannot have an INTO clause.
-- CREATE VIEW statements may not have an INTO, ORDER BY, FOR UPDATE, FOR READ ONLY, or OPTIMIZE clause.
-- INSERT statements may not have an INTO clause in a subselect, a FOR UPDATE, FOR READ ONLY, or an OPTIMIZE clause.
-- WHERE CURRENT OF cursor clause is not allowed in statements processed in interactive SQL or statements processed by the RUNSQLSTM command.
-- The NOT NULL clause is not allowed in the definition of a column being added to a table unless a default value is specified.
-- OVERRIDING USER VALUE and OVERRIDING SYSTEM VALUE are only valid if the statement is changing a column that is defined with GENERATED ALWAYS.
-- The RAISE_ERROR function cannot be specified alone in the select list or in a CASE expression.
Recovery . . . : Remove the clause. Try the request again.

Message File : QSQLMSG
Library Message File : QSYS2924


SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by IBM.

Length: 3220 Date: 20240329 Time: 055623     sap01-206 ( 3 ms )