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]
- 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]
- 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]
- Show help for the sample program:
- clisamp -h [32-bit]
- clisamp_aix64 -h [64-bit]
- Run the sample program using a user-provided input string:
- clisamp tdpid/user,password [32-bit]
- clisamp_aix64 tdpid/user,password [64-bit]
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):