Validating SQL Assistant - Teradata Tools and Utilities

Teradata Tools and Utilities for Red Hat Enterprise Linux Installation Guide

Product
Teradata Tools and Utilities
Release Number
15.10.04
Published
July 2017
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
PDF_Installation_Linux_RedHat_1600.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-3121
Product Category
Teradata Tools and Utilities
To validate the installation of SQLA perform one of the following tasks:
  • Execute the following batch command:

    sqla -p odbc -c system\user\password -s "Select Date" -e outfile, where:

    • system is the name or IP address of a Teradata system
    • user is a username authorized to use the Teradata system
    • password is the password for this user
    • outfile is the name of the export file that will be created
    If SQLA is correctly installed, the outfile file will be created and will contain today's date.
  • Simply launch the application and execute a query.
If these simple tests fail, then execute the following command from within the install directory:

verify.exe sqla

This will display a message stating whether the install is good or not, and a link to a log file that contains the details. This log file is created in the TEMP directory and can be sent to Teradata Support for troubleshooting.