自定义函数中为何不能用SQENCE?

Mycro

create function Tp.GENERAL_IDKEY()
returns bigint
READS SQL DATA        
NO EXTERNAL ACTION
NOT DETERMINISTIC
return (nextval for TP.IDKey_Squ)@
  

-----------------------------------------------

DB21034E  该命令被当作 SQL
语句来处理，因为它不是有效的“命令行处理器”命令。在 SQL 处理期间，它返回：
SQL0348N  在此上下文中不能指定 "NEXTVAL FOR TP.IDKEY_SQU"。  LINE NUMBER=1.
SQLSTATE=428F9

Mycro

create sequence TP.IDKey_Squ start with 1 increment by 1@

Mycro

SQL0348
Message Text: &1 expression not used correctly.
Cause Text: 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 statement.
In a CREATE FUNCTION statement.
In a CHECK constraint.
In a CREATE TABLE or ALTER TABLE statement that uses a select-statement to define the table. 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 a SET or VALUES statement.

Recovery Text: Remove the NEXT VALUE or PREVIOUS VALUE expression.
SQLCODE or SQLCODEs: -348
SQLSTATE or SQLSTATEs: 428F9

Mycro

原因是什么，为什么函数不能用？


他到底干了什么？

lizhuo

你得先创建sequence

Kevin.Van

触发器中碰到了同样的问题，奇怪的是相同的语句在linux下的数据库上可以通过，在windows平台下的就是不行，也报的这个错误，无语啊