Ansicht
Dokumentation

CPD4383 - Incorrect use of NEXT VALUE or PREVIOUS VALUE expression. ( OS/400 )

ROGBILLS - Synchronize billing plans   General Data in Customer Master  
This documentation is copyright by IBM.


Message : CPD4383
Incorrect use of NEXT VALUE or PREVIOUS VALUE expression.

Message Long Text :

Cause . . . . . : Usage of NEXT VALUE or PREVIOUS VALUE for sequence &3 in library &2 is not allowed in the context in which it was specified for reason code &1. The reason codes and their meanings follow:
1 -- PREVIOUS VALUE expression cannot be run because a NEXT VALUE has not completed.
2 -- NEXT VALUE expression is not allowed in a WHERE clause.
3 -- NEXT VALUE expression is not allowed in an ON clause.
4 -- NEXT VALUE expression is not allowed in a CASE expression.
5 -- NEXT VALUE expression is not allowed in a HAVING clause.
6 -- NEXT VALUE expression is not allowed in a an ORDER BY clause.
7 -- NEXT VALUE expression is not allowed in a query containing a GROUP BY clause.
8 -- NEXT VALUE expression is not allowed in a query containing a DISTINCT clause.
9 -- NEXT VALUE expression is not allowed in SELECT statement that is combined with another SELECT using a SET operation.
10 -- NEXT VALUE expression is not allowed as a parameter of a group by column function.
11 -- NEXT VALUE expression is not allowed in a subquery.
12 -- PREVIOUS VALUE expression is not allowed in a LIKE expression.
Recovery . . . : Refer to the DB2 for i5/OS SQL programming topic collection in the Database category in the IBM i Information Center, http://www.ibm.com/systems/i/infocenter/ for more information on sequence objects. Remove the NEXT VALUE or PREVIOUS VALUE expression in the context given above and try the request again.

Message File : QCPFMSG
Library Message File : QSYS2924


General Data in Customer Master   ABAP Short Reference  
This documentation is copyright by IBM.

Length: 3263 Date: 20240423 Time: 123223     sap01-206 ( 3 ms )