This table is used by the messaging system to store descriptive information about transport methods that are available at the site level.
Column Name | Column Type | Column Description |
---|---|---|
ADDRESSABLE | CHARACTER (1) NOT NULL |
Indicates whether this transport requires address information from the user. Value is one character which can be either Y or N. |
CODE | VARCHAR (2) NULL |
Code representing entry in LDAP for this transport. |
DESCRIPTION | VARCHAR (254) NULL |
Transport description. |
IMPLEMENTED | CHARACTER (1) NOT NULL |
Flag (Y or N) specifying if this transport is implemented and can be used to create profiles. "N" indicates that this transport is virtually deleted from the system (without physically deleting it and all of its links). |
NAME | VARCHAR (254) NOT NULL |
Transport name. This column can have up to 254 characters. By default, the names are supplied: EmailSender, File, MQ and Fax for the TRANSPORT_ID of 1, 2, 3 and 4 respectively. |
TIMEOUT | INTEGER NOT NULL |
Reserved for IBM internal use. |
TRANSPORT_ID | INTEGER NOT NULL |
Unique identifier for a transport. This primary key must correspond with the ID that identifies a transport in the Configuration Manager. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000256 | NAME | Unique Index |
SQL030416035136650 | TRANSPORT_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_1014 | TRANSPORT_ID | MSGARCHIVE | TRANSPORT_ID | Cascade |
F_1023 | TRANSPORT_ID | NOTIFY | TRANSPORT_ID | Cascade |
F_1024 | TRANSPORT_ID | MSGSTORE | TRANSPORT_ID | Cascade |
F_624 | TRANSPORT_ID | PROFILE | TRANSPORT_ID | Cascade |
F_804 | TRANSPORT_ID | STORETRANS | TRANSPORT_ID | Cascade |
F_893 | TRANSPORT_ID | USERPVCDEV | TRANSPORT_ID | Cascade |