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:
- makesamp.hpia32 [Integrity 32-bit]
- makesamp.hpia64 [Integrity 64-bit]
- makesamp.hpux [PA RISC 32-bit]
- makesamp.hp64 [PA RISC 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_hpia32 [Integrity 32-bit]
- chmod +x clisamp_hpia64 [Integrity 64-bit]
- chmod +x clisamp [PA RISC 32-bit]
- chmod +x clisamp_hp64 [PA RISC 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_hpia32 [Integrity 32-bit]
- clisamp_hpia64 [Integrity 64-bit]
- clisamp [PA RISC 32-bit]
- clisamp_hp64 [PA RISC 64-bit]
- Show help for the sample program:
- clisamp_hpia32 -h [Integrity 32-bit]
- clisamp_hpia64 -h [Integrity 64-bit]
- clisamp -h [PA RISC 32-bit]
- clisamp_hp64 -h [PA RISC 64-bit]
- Run the sample program using a user-provided input string:
- clisamp_hpia32 tdpid/user,password [Integrity 32-bit]
- clisamp_hpia64 tdpid/user,password [Integrity 64-bit]
- clisamp tdpid/user,password [PA RISC 32-bit]
- clisamp_hp64 tdpid/user,password [PA RISC 64-bit]
CLIv2 version is 16.00.00.00 MTDP version is 16.00.00.00 MOSIOS version is 16.00.00.00 MOSIDEP version is 16.00.00.00 OSERR version is 16.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 a Teradata Database, see Security Administration (B035-1100). - Run the sample program using the default logon information (dbc/systemfe,service):