![]() |
4.11.3.1. Prerequisites
4.11.3.1.1. SQL
commands for applying the "Sequencer" table in the LinkDB
|
|
---|---|
Prev | Next |
Make sure your PARTsolutions version contains the "Sequencer" table "CNSSEQ". If needed, use the following corresponding command lines.
CREATE TABLE CNSSEQ ( TOPIC VARCHAR(50) NOT NULL, PREFIX VARCHAR(50) NOT NULL, COUNTER INTEGER NOT NULL, PRIMARY KEY(TOPIC,PREFIX,COUNTER) ); grant all on dbo.CNSSEQ to public;
CREATE TABLE CNSSEQ ( TOPIC VARCHAR(50) NOT NULL, PREFIX VARCHAR(50) NOT NULL, COUNTER INTEGER NOT NULL, PRIMARY KEY(TOPIC,PREFIX,COUNTER) ); grant all on dbo.CNSSEQ to public;
CREATE TABLE CNSSEQ ( TOPIC VARCHAR(50) NOT NULL, PREFIX VARCHAR(50) NOT NULL, COUNTER INTEGER NOT NULL, PRIMARY KEY(TOPIC,PREFIX,COUNTER) ); CREATE PUBLIC SYNONYM CNSSEQ FOR SYSTEM.CNSSEQ; GRANT ALL ON CNSSEQ