Verifying the Installation Using CLI Sample Program - Teradata Tools and Utilities

Teradata Tools and Utilities for Microsoft Windows Installation Guide

Product
Teradata Tools and Utilities
Release Number
15.00
Published
March 2014
Language
English (United States)
Last Update
2018-09-29
dita:mapPath
Windows_Install/B035-2407-034K.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2407
lifecycle
previous
Product Category
Teradata Tools and Utilities
  1. In the makefile makesamp.win , add the correct paths to the include files.By default the makesamp.win file is located in the following folder:
    • \program-files\Teradata\Client\version\CLIv2\clisamp

    For information about the program-files variable, see About the program-files Variable in the Default Installation Path.

  2. Open a command prompt.
  3. Run the makefile to create the executable module clisamp:
    • # nmake -f makesamp.win
    The default configuration is CFG="clisamp - Win32 Debug". Also supported is CFG="clisamp - Win32 Release".
  4. Change directory to the appropriate subfolder:
    • Release
    • Debug
  5. Run the sample program by entering one of the following commands:
    • Run the sample program using the default logon information (dbc/systemfe,service):
      • clisamp
    • Show help for the sample program using the -h option:
      • clisamp -h
    • Run the sample program using a user-provided input string:
      • clisamp proddev/dbc,password
      • where proddev is the tdpid,
      • dbc is the user,
      • and password is the password.
The program does the following:
  1. Logs on using the default logon information (or the user-specified logon information) as shown above.
  2. Executes a simple query:
    • SELECT * from dbc.sessioninfo;
  3. Writes the results of the query to a CLISAMP.DAT file and displays information similar to the following:
    clisamp
    CLIv2    version is version
    MTDP     version is version
    MOSIOS   version is version
    MOSIDEP  version is version
    OSERR    version is version
    Logging on to --> dbc/systemfe,service
    writing out to --> CLISAMP.DAT
    submitting --> select * from dbc.sessioninfo;
    writing out to --> CLISAMP.DAT
    Logging off.
For information about security and connecting to a Teradata Database, see Security Administration, B035-1100.