Setting Default File Paths - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

Product
SQL Assistant
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2430
lifecycle
previous
Product Category
Teradata Tools and Utilities

Setting Default File Paths

1 Select Tools > Options.

2 Click the File Paths tab.

3 Enter file paths for the options shown.

See Table 10 for option descriptions.

 

Table 10: Description of the File Paths Options  

Option

Description

Query files

The Open/Save Query functions point to this directory the first time they are used. Subsequent open/save operations point to the most recent directory used.

The default path is \<user name>\My Documents.

Answer files

The Open/Save Query functions point to this directory the first time they are used. Subsequent open/save/export operations point to the most recent directory used.

The default path is \<user name>\My Documents.

Import and LOB files

Import operations initially point to this directory for import files. This is also the default location for storage of any large objects that are retrieved.

The default path is \<user name>\My Documents.

History file

History information is loaded from the SQLHistory.mdb file stored in this directory.

If you change this path to a directory that does not contain an SQLHistory.mdb file, Teradata SQL Assistant opens and converts any history file created by an earlier version of Teradata SQL Assistant. If a previous version is not found, a new, empty history database is created.

The default path is \<user name>\ApplData\Roaming\Teradata\SQL Assistant.