Starting ttIsql

TimesTen includes the ttIsql utility in a TimesTen distribution. Before using ttIsql, you can set specific environment variables after you create the TimesTen instance.

You can locate the ttIsql utility in the bin subdirectory of the TimesTen instance. See Overview of Installations and Instances in the Installation, Migration, and Upgrade Guide.

These environment variables include TIMESTEN_HOME, PATH, and LD_LIBRARY_PATH. On Linux, you set the environment variables by sourcing the ttenv.sh (for a Bourne or Bourne-compatible shell) or ttenv.csh (for a C shell).

The shell script for sourcing the environment variables is located in the bin subdirectory of the instance directory.

$ source ./<instance_dir>/bin/ttenv.sh

After setting the environment variables, you can run the following command:

$ ttIsql
Copyright (c) 1996, 2024, Oracle and/or its affiliates. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.

Command>