3.8.1 Connecting to the HADB server
After the HADB server has started, use the client program for creating tables (adbsql command) to connect to the HADB server.
- Organization of this subsection
(1) Executing the connection command
-
Execute the adbsql command.
As the HADB administrator (adbmanager), enter the following HADB command and press Enter:
adbsql
-
Enter a user ID (authorization identifier).
When you execute the adbsql command, the system asks you to enter the HADB user's user ID (authorization identifier). This user ID (authorization identifier) is used to connect to the HADB server. Here, specify ADBUSER02 and press Enter.
USER-ID? ADBUSER02
-
Enter a password.
When you enter a user ID (authorization identifier), the system asks you to enter a password. Here, specify #HelloHADB_02 and press Enter.
PASSWORD? #HelloHADB_02 The entered password is not displayed.
(2) Confirming that the client program has connected to the HADB server
When you specify a password and press Enter, the client program connects to the HADB server, allowing you to enter SQL statements. The following shows an example of the execution result.
- ■ Execution result example
-
COMMAND ? +----2----+----3----+----4----+----5----+----6----+----7----+
If the above execution result is displayed, you can enter SQL statements.
(3) Related item
adbsql (Execute SQL Statements) in the manual HADB Command Reference