15.11 - Including Objects - Data Stream Architecture

Teradata Data Stream Architecture (DSA) User Guide

prodname
Data Stream Architecture
vrm_release
15.11
created_date
December 2016
category
User Guide
featnum
B035-3150-026K
You can include database objects for any backup, restore, or analyze_validate job by specifying an object under objectlist in the XML file containing the job definition.
  1. Open the XML file containing the job definition information.
  2. Under objectlist, specify:
    Option Description
    objectinfo Contains the information on all objects for the job.
    object_name The name of the object. The name can have a maximum of 128 characters.
    object_type The type of object. The accepted values are:
    • AGGREGATE_FUNCTION
    • AUTHORIZATION
    • COMBINED_AGGREGATE_FUNCTIONS
    • CONTRACT_FUNCTION
    • DATABASE
    • EXTERNAL_PROCEDURE
    • GLOP_SET
    • HASH_INDEX
    • INSTANCE_OR_CONSTRUCTOR_METHOD
    • JAR
    • JOIN_INDEX
    • JOURNAL
    • MACRO
    • NO_PI_TABLE
    • ORDERED_ANALYTICAL_FUNCTION
    • QUEUE_TABLE
    • SERVER_OBJECT
    • STANDARD_FUNCTION
    • STATISTICAL_FUNCTION
    • STORED_PROCEDURE
    • TABLE
    • TABLE_FUNCTION
    • TABLE_OPERATOR
    • TRIGGER
    • USER
    • USER_DEFINED_METHOD
    • USER_DEFINED_DATA_TYPE
    • USER_INSTALLED_FILE
    • VIEW
    parent_name The name of the object parent. The name can have a maximum of 128 characters.
    All objects other than databases and users are required to have a parent name.
    parent_type [Optional] The type of parent. The accepted values are:
    • DATABASE
    • USER
    The following XML sample file excerpt shows how to include the VIEW1 object in the DB1 database.
    <objectlist>
        <objectinfo>         
            <object_name>VIEW1</object_name>           
            <object_type>VIEW</object_type>                    
            <parent_name>DB1</parent_name>                  
            <parent_type>DATABASE</parent_type>
        </objectinfo>