4.12.3.1. Prerequisites
4.12.3.1.1. SQL commands for applying the "Sequencer" table in the LinkDB
Prev  Next
4.12.3.1.1. SQL commands for applying the "Sequencer" table in the LinkDB
4.12.3.1.1.1. CNSSEQ Table

Make sure your PARTsolutions version contains the "Sequencer" table "CNSSEQ". If needed, use the following corresponding command lines.

  • MSSQL 

    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;

  • MySQL 

    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;

  • Oracle 

    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

Prev Up Next
4.12.3.1. Prerequisites Home 4.12.3.1.1.1.  CNSSEQ Table