TRAN_DESTINATION

Definition


The TRAN_DESTINATION table contains the list of transport destinations related to transport requests

Technical Data


Schema Version 5.0.6
Tablespace CATALOG_DATA
Partitioned No

Summary


The TRAN_DESTINATION 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
TRAN_OID       TRANSPORT_REQUEST (OID)
 

    The unique identifier of the related transport request
    ALIAS        

      The alias of the transport destination
      STATUS        

        The status of the execution of the transport request for the transport destination

        More...

        SEND_DATE        

          The date when the transport request was sent
          RESPONSE_DATE        

            The date when the response of the transport destination was received
            FAILURE_CATEGORY        

              The failure category if the execution of the transport request failed for the transport destination

              More...

              FAILURE_MESSAGE        

                The failure message if the execution of the transport request failed for the transport destination
                ERROR_STACK        

                  The stack of error if the execution of the transport request failed for the transport destination. The content of this field is in XML format.

                  Column Details

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

                  TRAN_OID

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

                  ALIAS

                  Definition The alias of the transport destination
                  Type VARCHAR(64), NOT NULL

                  STATUS

                  Definition The status of the execution of the transport request for the transport destination
                  Format

                  The possible values are:

                  • 0: created
                  • 1: inProgress
                  • 2: successful
                  • 3: failed

                  Type DECIMAL(1), NOT NULL

                  SEND_DATE

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

                  RESPONSE_DATE

                  Definition The date when the response of the transport destination was received
                  Type TIMESTAMP, NULL

                  FAILURE_CATEGORY

                  Definition The failure category if the execution of the transport request failed for the transport destination
                  Format

                  The possible values are:

                  • 0: authenticationFailure
                  • 1: communicationFailure
                  • 2: invalid
                  • 3: incompatibleConfiguration
                  • 4: illegalState
                  • 5: temporaryIllegalState

                  Type DECIMAL(1), NULL

                  FAILURE_MESSAGE

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

                  ERROR_STACK

                  Definition The stack of error if the execution of the transport request failed for the transport destination. The content of this field is in XML format.
                  Type BLOB, NULL