Full site membership is required for this article. Already a full member? Login here. You currently have a guest membership. You can upgrade to full site membership here (free trial available). Sequence Objects and Identity Columns   Article Abstract: (Craig Mullins) This article discusses two methods available for generating sequential values for a DB2 column; identity columns (available as of V6) and sequence objects (available as of V8).   Read this article...

Related Articles - For Members. All Articles By Author Troubleshooting identity columns problems Changing from Non-IDENTITY to IDENTITY and vice versa Primary Keys and Identity - One and The Same? Identity Management with Microsoft Identity Integration Server Getting the Wrong Identity in Microsoft SQL Server identity Columns? Why IDENTITY Is Not A Good Primary Key Solution Querying 'top sequences' Finding the Lost Identity

RE: Sequence Objects and Identity Columns
(posted: 5/20/2005 7:27:18 AM)
Good article. We have a .NET application and found that we lost the cached sequences consistantly. We changed the sequence to no longer cache and were fine.