This table is used by the messaging system to store
descriptive information about transport methods that are available
at the site level.
Column Descriptions:
Name | Type | Description |
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. |
TIMEOUT | INTEGER NOT NULL | Reserved for IBM internal use. |
IMPLEMENTED | CHAR (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). |
ADDRESSABLE | CHAR (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) | Code representing entry in LDAP for this
transport. |
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. |
DESCRIPTION | VARCHAR (254) | Transport description. |
OPTCOUNTER | SMALLINT | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | TRANSPORT_ID | Primary Key |
I0000256 | NAME | Unique Index |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | 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 |