Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
JOBQ_HostAttrType varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) false attribute type ot the host
JOBQ_QTypeMsgNr int NUMBER(38,0) int int false MessageNr Queue Type
JOBQ_FilterMsgNr int NUMBER(38,0) int int false MessageNr Filtername
JOBQ_FilterName varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Filtername Text
JOBQ_Type char (1) CHAR (1 CHAR) char(1) char (1) true Filtertype (C/E/L/T)
JOBQ_MaxLen smallint NUMBER(38,0) smallint smallint true maximum field size
JOBQ_ValidOpr varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true E,N,G,L (equals (like), not, greater, lower)
JOBQ_MaxValue int NUMBER(38,0) int int true maximum value
JOBQ_MinValue int NUMBER(38,0) int int true minimum value
JOBQ_AllowOR smallint NUMBER(38,0) smallint smallint true flag if OR is allowed (1=yes, 0=no)

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_JOBQ JOBQ_HostAttrType, JOBQ_QTypeMsgNr, JOBQ_FilterMsgNr true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File