A sequence provides recoverable, unique sequential numbers for applications and is especially useful in providing keys. In contrast to identity columns, sequences are standalone objects that applications can use to avoid concurrency and performance problems that can result when applications generate their own sequence numbers. After a sequence is defined, many users can access and increment it concurrently, including multiple DB2 members in a data sharing group.
When you select sequences from the Investigator, CA Chorus displays a user-defined stored object that generates a sequence of numeric values in ascending or descending order.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|