DB2 Creating Sequences to use with Primary Key ID fields
Well, another job and another database system to learn. I’ve got practically all of them under my belt now 
I finished reading this article on sequences vs key managers vs identity columns and decided I needed to go with a sequence.
To create a new sequence called “USERS_SEQ” for a schema named “TEST”
CREATE SEQUENCE TEST.USERS_SEQ
AS BIGINT
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO CYCLE;
To use that sequence to generate unique, incremented, primary key IDs for a table:
INSERT INTO TEST.USERS (id, name_first)
VALUES (NEXTVAL FOR TEST.USERS_SEQ, ‘Rich’);
To use that generated id value, you can use PREVVAL to get it back
Share this via del.icio.us, digg, email, etc.
Trackback for "DB2 Creating Sequences to use with Primary Key ID fields"
PHP articles
Google Reader
Del.icio.us bookmarks