Including Objects - BAR - Data Stream Architecture - Learn how to use the XML file to include database objects for jobs.

Teradata® DSA User Guide

Product
BAR
Data Stream Architecture
Release Number
16.20
Published
November 2019
Language
English (United States)
Last Update
2019-11-27
dita:mapPath
xfr1514490991957.ditamap
dita:ditavalPath
3150_DSA_UG_1650-working-RR-new.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>