I was trying to access/use:
SELECT CURRENTVALUE FROM SYS.SYSSEQUENCES WHERE SEQUENCENAME='SOMETHING'
It appears not to return the expected value, in fact it seem to add 5 to the expected value or some other number but not what is expected.
Surely this cannot be considered correct/reasonable ?
Is there any way to access the real CURRENTVALUE (I don't think (CURRENTVALUE-X) is a good solution, since it is not clear what X should be at any one time)