3.7.2 Connecting to the HADB server
After the HADB server has started, use the client program for creating HADB users (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) in response to the system request.
When you execute the adbsql command, the system asks you to enter an HADB user's user ID (authorization identifier). The user ID (authorization identifier) specified here is used to connect to the HADB server. In this case, specify ADBUSER01 and press Enter.
USER-ID? ADBUSER01
-
Enter a password in response to the system request.
When you enter a user ID (authorization identifier), the system asks you to enter a password. In this case, specify #HelloHADB_01 and press Enter.
PASSWORD? #HelloHADB_01 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. An example of the execution result follows.
- ■ Execution result example
-
COMMAND ? +----2----+----3----+----4----+----5----+----6----+----7----+
If the above execution result is displayed, you can enter SQL statements.
- Important
-
If the entered HADB user's user ID (authorization identifier) or password is invalid, the attempt to connect to the HADB server fails and the KFAA30561-E message is output. If this occurs, see 3.12.4 The KFAA30561-E message is output while attempting to connect to the HADB server.
(3) Related item
adbsql (Execute SQL Statements) in the manual HADB Command Reference