TRANSPORT_REQUEST

Definition


The TRANSPORT_REQUEST table contains the list of transport requests created in the system

Technical Data


Schema Version 5.0.6
Tablespace CATALOG_DATA
Partitioned No

Summary


The TRANSPORT_REQUEST table is defined by the following columns in your back-end database. See the column details for more information.

Name PK FK IX Uses Used by Definition
OID PK_TRANSPORT_REQUEST       

The unique identifier of the transport request
CREATION_DATE        

    The date when the transport request was created
    STATUS        

      The status of the execution of the transport request

      More...

      CHAN_OID        

        The unique identifier of the related change list
        FAILURE_MESSAGE        

          The failure message if the execution of the transport request failed

          Column Details

          The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

          OID

          Definition The unique identifier of the transport request
          Type DECIMAL(28), NOT NULL
          Primary Key PK_TRANSPORT_REQUEST

          CREATION_DATE

          Definition The date when the transport request was created
          Type TIMESTAMP, NOT NULL

          STATUS

          Definition The status of the execution of the transport request
          Format

          The possible values are:

          • 0: created
          • 1: executed

          Type DECIMAL(1), NOT NULL

          CHAN_OID

          Definition The unique identifier of the related change list
          Type DECIMAL(28), NOT NULL

          FAILURE_MESSAGE

          Definition The failure message if the execution of the transport request failed
          Type VARCHAR(2000), NULL

          Primary Key Details

          See the primary key information:

          PK_TRANSPORT_REQUEST

          Column(s) OID
          Tablespace CATALOG_INDX