To verify that the Teradata Tools and Utilities software installed properly, run the sample CLI application, clisamp. The program and its makefile are installed during installation of Teradata Tools and Utilities.
-
Modify the following makefile so it contains the correct directory paths to the include files:
Operating System Directory Path RedHat, SLES or OEL [32-bit] makesamp.lx RedHat, SLES or OEL [64-bit] makesamp.lx64 -
Execute the makefile:
make -f filename
where filename is the name of the file in the previous step.
The executable module named clisamp is created. -
Change the mode of the executable to run:
Operating System Mode to Run RedHat, SLES or OEL [32-bit] chmod +x clisamp RedHat, SLES or OEL [64-bit] chmod +x clisamp_lx64 -
Run the sample program using one of the following commands:
- Run the sample program using the default logon information (dbc/systemfe,service):
Operating System Sample Program to Run RedHat, SLES or OEL [32-bit] clisamp RedHat, SLES or OEL [64-bit] clisamp_lx64 - Show help for the sample program:
Operating System Command to Show Help RedHat, SLES or OEL [32-bit] clisamp -h RedHat, SLES or OEL [64-bit] clisamp_lx64 -h - Run the sample program using a user-provided input string:
Operating System User-Provided Input String RedHat, SLES or OEL [32-bit] clisamp tdpid/user,password RedHat, SLES or OEL [64-bit] clisamp_lx64 tdpid/user,password
The program logs on to the default dbccop1 (no user input supplied) specified in the /etc/hosts file, runs a simple query SELECT * from dbc.sessioninfo, and writes the output to the clisamp.dat file. A display similar to the following appears:CLIv2 version is 16.20.00.00 MTDP version is 16.20.00.00 MOSIOS version is 16.20.00.00 MOSIDEP version is 16.20.00.00 OSERR version is 16.20.00.00 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 Teradata® Database Security Administration (B035-1100). - Run the sample program using the default logon information (dbc/systemfe,service):