17.00 - 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
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-11-20
dita:mapPath
ofn1544831946734.ditamap
dita:ditavalPath
dpj1465132351025.ditaval
  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

  2. 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".

  3. Change directory to the appropriate subfolder:

    Release

    Debug

  4. 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
      • password is the password
The program does the following:
  • Logs on using the default logon information (or the user-specified logon information) as shown above.
  • Executes a simple query: SELECT * from dbc.sessioninfo;
  • 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 Teradata Vantage, see Teradata Vantage™ - Advanced SQL Engine Security Administration, B035-1100.