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

Teradata® DSA User Guide

Product
BAR
Data Stream Architecture
Release Number
17.10
Published
April 2022
Language
English (United States)
Last Update
2022-04-08
dita:mapPath
het1611950545663.ditamap
dita:ditavalPath
vwp1576617377804.ditaval
dita:id
B035-3150
lifecycle
previous
Product Category
Software
Teradata Tools and Utilities
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 [Advanced SQL Engine 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>