Skip to content
≡

Administrator

Developer

Tools

External Tools

Setting up iSQL

Setting up iSQL#

In order for iSQL to access a server, the following information is necessary.

  • ALTIBASE_HOME
    A path to a server or client installation

  • server_name
    The name (or IP address) of a computer on which Altibase Server is running

  • port_no
    The port number used when connecting via TCP, IPC, or IPCDA

  • user_id
    A User ID registered in the database

  • password
    The password corresponding to the User ID

  • NLS_USE
    The character set with which to display retrieved data to the user

ALTIBASE_HOME can only be set using an environment variable, while the other settings may be made using command-line options. (For more information, please refer to iSQL Command-Line Options.)

ALTIBASE_HOME environment variable must be set in order to use iSQL. Although it is automatically configured when the server is installed in general, but the user should directly configure since there might be a chance of conflict with the environment variables in the server.

port_no and NLS_USE can be set using the environment variables or the server settings file (altibase.properties). If these settings are made via all three methods, they will take priority as follows, in descending order:

  1. command-line options
  2. environment variables (ALTIBASE_PORT_NO, ALTIBASE_NLS_USE)
  3. server settings file (altibase.properties)

Therefore, when it is desired to connect using options other than those that have been previously set, the command-line options can be used, so that it is not necessary to change the settings in the server setting file or the environment variables.

If any options have not been set, when iSQL is executed for the first time, the user will be prompted to enter the corresponding variables. At this time, it is essential to enter values that are valid and follow the proper format, otherwise iSQL may not run properly.

However, if the NLS_USE option in particular has not been set, no command prompt will appear at the time of execution. Instead, US7ASCII will be used, and a connection attempt will be made. In this case, if the character set of the database is not US7ASCII, the application will not execute properly, or some of the user's data may become corrupted. Thus it is paramount that NLS_USE be set to a suitable value for the usage environment.

In order to ensure stable iSQL operation, we recommend that the following environment variables be set: • ALTIBASE

  • ALTIBASE_HOME : the path to a server or client installation
  • ALTIBASE_PORT_NO : the port number to use to connect to the server
  • ALTIBASE_NLS_USE : the character set to use to display retrieved data to the user
  • PATH : the path containing the executable file, which must equal $ALTIBASE_HOME/bin