Inserting an Object into a Query - Teradata Viewpoint

Teradata Viewpoint User Guide

Product
Teradata Viewpoint
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
hkd1478709580913.ditamap
dita:ditavalPath
2206_User_vp_1610.ditaval.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem
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.