| 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) |
| Name | Fields | Primary | Unique | Clustered | Nonclustered |
|---|---|---|---|---|---|
| PK_JOBQ | JOBQ_HostAttrType, JOBQ_QTypeMsgNr, JOBQ_FilterMsgNr | true | true | true | false |
| Name | Local References | Foreign References |
|---|
Return to the Index File