How can I return the current generator id value using sql. I want to be able to run a sql query in my code to increment and return the current value.
I would like something like to work, but of course it doesn't:
select GEN_ID (ORDER_ID_GEN, 1) AS ORDER_ID;
I don't want to increment the value based on an insert into a table.
Thanks in advance.