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

No comments:

Post a Comment