What's New

Sequence Support

DB2 Version 7.2 provides a standalone, efficient, and recoverable (automatic) number generator through a new type of database object called a SEQUENCE. A sequence object enables the database manager to automatically generate a new numeric value for each call made to the sequence's NEXTVAL expression.

Applications can use sequences to avoid possible concurrency and performance problems that can result from generating a unique counter outside the database.

Note:
Sequence data types are not yet supported in DB2 Enterprise - Extended Edition.

See the DB2 Release Notes for more information on sequence support.


[ Top of Page | Previous Page | Next Page ]