QUEUE

This table is deprecated and is provided for backward compatibility only.

Column Descriptions:

NameTypeDescription
QUEUE_IDINTEGER NOT NULLReserved for IBM internal use.
NAMEVARCHAR (50) NOT NULLReserved for IBM internal use.
ALLCSRINTEGER NOT NULL DEFAULT 0Reserved for IBM internal use.
STORE_IDINTEGER NOT NULLReserved for IBM internal use.
OPTCOUNTERSMALLINTReserved for IBM internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>QUEUE_IDPrimary Key
I0000273STORE_ID+NAMEUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_951STORE_IDSTORESTORE_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_952QUEUE_IDQUEUEDESCQUEUE_IDCascade
F_954QUEUE_IDQUEUECSRQUEUE_IDCascade