Run the sample CLI application, clisamp to verify the Teradata Tools and Utilities software installed properly.
- Modify the following makefile to include the correct directory paths in 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 17.10.00.00 MTDP version is 17.10.00.00 MOSIOS version is 17.10.00.00 MOSIDEP version is 17.10.00.00 OSERR version is 17.10.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 Vantage, see Teradata Vantage™ - Advanced SQL Engine Security Administration, B035-1100. - Run the sample program using the default logon information (dbc/systemfe,service):