Logging In to iSQL

Logging In to iSQL#

To use iSQL, users must first be logged in. Connection information may be input directly via a command line, or via the iSQL input prompt.

isql -U userID -P password [-SYSDBA]

or

isql [-SYSDBA]

Additional information necessary for connection with the server is the server name (-S), user ID (-U), and password (-P). The user ID and password are not case-sensitive.

In order for the SYS user to use iSQL as an administrator, the SYSDBA option is used. The SYSDBA option can be used for remote access.

-SYSDAB option should be used in order for the SYS user to use iSQL as an administrator. The SYSDBA option can be also used for remote access. Use double quotation marks if the user ID contains special characters or spaces.

$ isql -U \"user name\"

Only one user is permitted to connect in SYSDBA mode at one time. Two or more users cannot connect in SYSDBA mode at the same time.
The user can access the database remotely in SYSDBA mode, but can't start up the database.

For detailed information on system privileges, please refer to the Altibase SQL Reference.

For detailed information on errors that may arise during iSQL execution, please refer to the Altibase Error Message Reference.

$ isql -U sys -P manager [-SYSDBA]

$ isql [-sysdba]
-------------------------------------------------------
     Altibase Client Query utility.
     Release Version 7.1.0.1
     Copyright 2000, Altibase Corporation or its subsidiaries.
     All Rights Reserved.
-------------------------------------------------------
Write Server Name (default:127.0.0.1) :
Write UserID : sys
Write Password : manager      -- The password on the screen is not displayed.
ISQL_CONNECTION = TCP, SERVER = 127.0.0.1, PORT_NO = 20300
iSQL(sysdba)>                 -- iSQL is connected to the server, and SQL, iSQL, and PSM commands can be input and executed here.

Administrator

Reference

Developer

Tools

External Tools

Logging In to iSQL