10.3.4.5 DBMS Constraints

The DBMS user indicated in the OPENINFO of the group containing the server, must have access to the TS_QCONTENT table; either directly (objects created in this schema) or thru a DBLINK.

On this pre-existing table it must have select, insert, update, delete permissions.

The script to create the table for Oracle is listed below:

Listing TS_QCONTENT Creation



drop table TS_Q_CONTENT purge;
create table TS_Q_CONTENT
( TS_QUEUE    char(16) NOT NULL,
  TS_ITEM     number(8) NOT NULL,
  TS_LENGTH   number(8),
  TS_RAW      LONG RAW,
  primary key (TS_QUEUE, TS_ITEM)
);