Specifying USING Clause Values - System Emulation Tool

Teradata System Emulation Tool User Guide

Product
System Emulation Tool
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-07
dita:mapPath
lth1488824663584.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2492
lifecycle
previous
Product Category
Teradata Tools and Utilities

For queries that the user inputs manually or selects from a file, TSET submits a DUMP EXPLAIN or INSERT EXPLAIN query to export execution plan information. If the query includes the USING clause, TSET displays the Input using values to capture specific plan screen.

Input Using Values to Capture Specific Plan

Use this screen to specify values for the USING clause shown for each selected query.

The Using Variables fields display data in the Name field and Datatype field.

  1. Enter data values in the Value column for each query listed in the Using Query edit box.
  2. Choose one of the following:
    • Click OK to export specific execution plans that contain values for the USINGclause.
    • Click Ignore to capture generic execution plans.
    • Click Ignore All to capture generic plans for all other export queries containing the USING clause.