Generating Multiple Reports From a Single Query - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

SQL Assistant
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

Generating Multiple Reports From a Single Query

You can generate multiple reports from a single query using SQL Assistant’s import feature. This is often useful for DBAs.

1 Create an import file (typically a .txt file) that contains a list of tables, one table name per line.

2 Select File > Import Data.

3 Enter the following into the Query Window:


4 Click .

This displays a file selection dialog box.

5 Select the file you saved.

The status bar at the bottom of the Query window shows row numbers as they are loaded.

6 To obtain the results of the query, go to the directory in which you saved the import file and open the .log file.