Ansicht
Dokumentation

SQL0348 - &1 expression not used correctly. ( OS/400 )

ROGBILLS - Synchronize billing plans   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by IBM.


Message : SQL0348
&1 expression not used correctly.

Message Long Text :

Cause . . . . . : The &1 sequence expression for &2 in &3 is not allowed. A NEXT VALUE or PREVIOUS VALUE sequence expression cannot be specified:
-- In a CREATE VIEW, CREATE TABLE, ALTER TABLE, or CREATE INDEX statement.
-- In a CREATE FUNCTION statement.
-- In a CHECK constraint.
A PREVIOUS VALUE expression cannot be specified in a CREATE TRIGGER statement.
A NEXT VALUE expression can only be specified:
-- In the SELECT clause of the outermost SELECT. It cannot be used if the outermost SELECT uses the DISTINCT keyword, contains a GROUP BY or ORDER BY clause, or is part of a fullselect. It cannot be used in a CASE expression.
-- In the SELECT clause of the outermost SELECT of a common table expression. It cannot be used if the outermost SELECT uses the DISTINCT keyword, contains a GROUP BY or ORDER BY clause, or is part of a fullselect.
-- As an expression in the SET clause of an UPDATE. It cannot be used in a subselect in the SET clause of an UPDATE.
-- As an INSERT value in either the VALUES clause or in the SELECT clause of the fullselect.
-- As a value in an SET or VALUES statement.
Recovery . . . : Remove the NEXT VALUE or PREVIOUS VALUE expression.

Message File : QSQLMSG
Library Message File : QSYS2924


BAL_S_LOG - Application Log: Log header data   ROGBILLS - Synchronize billing plans  
This documentation is copyright by IBM.

Length: 3235 Date: 20240501 Time: 234530     sap01-206 ( 3 ms )