Hi,
I have a requirement that a non-key column of a table be updated with a brand-new number when certain types of updates happen for a row. What I want to do (in a portable manner) is to get the next sequence number from some sequence generator and assign the specific property of the persistent object to that value.
As far as I could tell, sequence number generation is tied to primary keys.
Is there any way I can access the mechanisms of getting a new sequence number without actually performing an insert into some table.
Thanks in advance.
Regards,
Krishnan
|