Include Objects | Command Line | Teradata DSA - 17.20 - Including Objects - BAR - Data Stream Architecture

Teradata® DSA User Guide

Product
BAR
Data Stream Architecture
Release Number
17.20
Published
November 2022
Last Update
2022-11-14
Content Type
User Guide
Publication ID
B035-3150-101K
Language
English (United States)
Last Update
2022-11-14
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
    • FUNCTION_ALIAS [Analytics Database 16.20 Feature Update 1]
    • GLOP_SET
    • HASH_INDEX
    • INSTANCE_OR_CONSTRUCTOR_METHOD
    • JAR
    • JOIN_INDEX
    • 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>