Subject Update generators inside a stored procedure
Author balazszokker

I would like to update (or reset) the values of the generators defined
in the database inside a stored procedure.

I'm trying to do the following:

create procedure UpdateGenTest
execute statement gen_id(gen_test, 1);

and this does update the value of the generator, BUT it gives the
following error:

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 1, char 1.
<new value of generator>.

I would be most helpful if anybody could help me out.