Creating Restricted Views - Visual Explain

Teradata Visual Explain User Guide

Product
Visual Explain
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2504
lifecycle
previous
Product Category
Teradata Tools and Utilities

Creating Restricted Views

Additional restricted views required by Teradata Visual Explain must be created in Teradata Database. Teradata Visual Explain creates restricted views from a script file. There are five versions of the script file:

  • DBCXViews62.bteq; used on Teradata Database V2R6.2, V2R6.1, or V2R6.0
  • DBCVXViews120.bteq; used on Teradata Database 12.00.00
  • DBCVXViews123.bteq; used on Teradata Database 13.00.00 and 13.10.00
  • DBCVXViews140.bteq; used on Teradata Database 14.0
  • DBCVXViews141.bteq; used on Teradata Database 14.10 and Teradata Database 15.0
  • The script files are located in the Teradata installation folder. For example:
    C:\Program Files\Teradata\Teradata Visual Explain 15.00\DBCVXViews141.bteq

    To create restricted views

    1 Open Teradata Visual Explain.

    2 Select Tools>Options from the menu.

    The Options dialog box appears with the General tab selected.

    3 Select Use X views (DBC and QCD).

    4 A confirmation message appears. Do one of the following:

  • Click Yes to create restricted views.
  • Click No to proceed using non-X views, and then click OK.