Retrieving Results from a Teradata QS Server File - Query Scheduler

Teradata Query Scheduler User Guide

Product
Query Scheduler
Release Number
16.20
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-04
dita:mapPath
the1488824663377.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2512
Product Category
Teradata Tools and Utilities

When results from a file are being retrieved on the Teradata QS Server, the Teradata QS Viewer prompts for the name of a local file into which to copy the results. Next, the Teradata QS Viewer gets the results from the Teradata QS server file and copies them to the local file using tabs as field delimiters.

Then Teradata SQL Assistant is invoked with the local file name. Teradata SQL Assistant opens, retrieves the results from the local file, and loads them in a Teradata SQL Assistant answer set window.

  1. From the Teradata Query Scheduler Viewer, select a job in a Complete status from the Jobs list.
  2. Click Options > Retrieve Result Data, or click , or right-click the request to display a shortcut menu and click Retrieve Result Data.
  3. A prompt appears for the name of a local file where to copy the results.

    The Teradata Query Scheduler Viewer gets the results from the Teradata QS server file and copies them to the local file. Then Teradata SQL Assistant is invoked with the local file name.

    Teradata SQL Assistant opens, retrieves the results from the local file, and loads them in a Teradata SQL Assistant answer set window.