I created a sequence using the query "create sequence admin.seqbcpos
minvalue 1 increment by 1". It got created successfully. when I used it in
insert statement "insert into admin.temp values(nextval('seqbcpos'), null,
null)", it is giving the following error.
SQL0440N No authorized routine named "NEXTVAL" of type "FUNCTION
" having
compatible arguments was found.

please let me know how to solve it.

Seemtimes reading the manual helps:
http://publib.boulder.ibm.com/infoce...n/t0004993.htm
NEXTVAL FOR seqbcpos
If you are on DB2 V8 you should actually use:
NEXT VALUE FOR seqbcpos
That is SQL Standard compliant.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab