16.20 - Retrieving Results from a Teradata QS Server File - Query Scheduler

Teradata Query Scheduler User Guide

prodname
Query Scheduler
vrm_release
16.10
16.20
created_date
May 2017
category
User Guide
featnum
B035-2512-086K

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.