Inserting an Object into a Query

Teradata® Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K
You can insert the qualified name of a database object into a query in the query box using the object browser. A qualified object name is a name composed of more than one identifier, joined with the dot character (.). The identifiers together specify a database object with more precision than a single name.
  1. Position the cursor in the query box where you want to insert the object.
  2. Click the list next to the Load button and select Insert Object. The Object Browser opens, displaying the name of the connected Teradata Database system.
  3. Click next to the Teradata Database system name to expand the directory tree.
  4. [Optional] Enter filter criteria in the box under the Teradata Database system to find databases or users containing the criteria.
  5. Click next to the database object type in the tree to expand that sub-branch.
  6. [Optional] Enter filter criteria in the box under the object type to find objects containing the criteria.
  7. Click to highlight the object name.
  8. Click Insert Object to copy the qualified object name to the query box. The object name is inserted in the query box after the cursor location.
  9. Click Close.