--- Begin Message ---
We have found a use for sequences but have a few questions -
LOCKING : the statement fragment "NEXTVAL FOR seq" generates the next
value in the sequence. You can refetch this using "PREVVAL FOR seq".
This implies that there must either be a temporary storage area filled
in with this for each in-flight transaction or that some sort of lock is
held on the sequence until the transaction ends. Can anyone help as to
what actually is happening.
I'm thinking about concurrency, if we have multiple streams of inserting
jobs running at the same time using the NEXTVAL clause in the insert
statement.
========================================
Authority : are there any authorities required to use a sequence ?
========================================
Any other experiences would be useful.
TIA
Phil Nelson
ScotDB Limited
--- End Message ---
