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 to the include files:
- makesamp.aix [32-bit]
- makesamp.aix64 [64-bit]
- Solaris on Opteron
- makesamp.soli386 [32-bit]
- makesamp.solx8664 [64-bit]
- Solaris on SPARC
- makesamp.sol [32-bit]
- makesamp.sol64 [64-bit]
- 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:
- chmod +x clisamp [32-bit]
- chmod +x clisamp_aix64 [64-bit]
- Solaris on Opteron
- chmod +x clisamp_soli386 [32-bit]
- chmod +x clisamp_solx8664 [64-bit]
- Solaris on SPARC
- chmod +x clisamp_sol [32-bit]
- chmod +x clisamp_sol64 [64-bit]
- Run the sample program using one of the following commands:
- Run the sample program using the default logon information (dbc/systemfe,service):
- clisamp [32-bit]
- clisamp_aix64 [64-bit]
- Solaris on Opteron
- [32-bit] clisamp_soli386
- [64-bit] clisamp_solx8664
- Solaris on SPARC
- [32-bit] clisamp_sol
- [64-bit] clisamp_sol64
- Show help for the sample program:
- clisamp -h [32-bit]
- clisamp_aix64 -h [64-bit]
- Solaris on Opteron
- [32-bit] clisamp_soli386 -h
- [64-bit] clisamp_solx8664 -h
- Solaris on SPARC
- [32-bit] clisamp_sol -h
- [64-bit] clisamp_sol64 -h
- Run the sample program using a user-provided input string:
- clisamp tdpid/user,password [32-bit]
- clisamp_aix64 tdpid/user,password [64-bit]
- Solaris on Opteron
- [32-bit] clisamp_soli386 tdpid/user,password
- [64-bit] clisamp_solx8664 tdpid/user,password
- Solaris on SPARC
- [32-bit] clisamp_sol tdpid/user,password
- [64-bit] clisamp_sol64 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 20.00.00.00 MTDP version is 20.00.00.00 MOSIOS version is 20.00.00.00 MOSIDEP version is 20.00.00.00 OSERR version is 20.00.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™ - Analytics Database Security Administration, B035-1100. - Run the sample program using the default logon information (dbc/systemfe,service):