Creating Restricted Views - Visual Explain

Teradata Visual Explain User Guide

Product
Visual Explain
Release Number
16.20
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-04
dita:mapPath
pvi1488824663157.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2504
Product Category
Teradata Tools and Utilities
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 higher

The script files are located in the Teradata installation folder, for example, C:\Program Files(x86)\Teradata\Client\16.00\bin\DBCVXViews141.bteq

  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.