Connect to a database environment in interactive mode

You can use the CONNECT . . . USER syntax in SQL statements that you issue in interactive mode. However, DB-Access does not support the USER clause of the CONNECT statement when you connect to a default database server.

When you include the USER ‘user identifier' clause in a CONNECT statement in interactive mode, DB-Access prompts you to enter a password.

The following two command examples show how to connect to a database server in interactive mode. The first example uses the CONNECT statement without specifying a user identifier.
dbaccess -nohistory- -

> connect to '@starfish';

If you include the USER clause in a CONNECT statement, as the second example shows, DB-Access uses echo suppression to prompt you for a password:
> connect to '@starfish' user 'marae';


Restriction: For security reasons, do not enter the password on the screen where it can be seen. Also, do not include the USING password clause in a CONNECT statement when you use DB-Access interactively. If you are in interactive mode and attempt to enter a password before the prompt, an error message is displayed.
You can run the USER clause of a CONNECT statement in a DB-Access file that includes the USER clause. The following example uses a command file that contains a CONNECT statement with a USING clause to connect to a database server:
dbaccess - connfile.sql
Important: An SQL command file that contains the following statement is protected from access by anyone other than the user_id that the USER clause identifies:
CONNECT TO '@dbserver' USER 'user_id' USING password
For UNIX, the following example uses a shell file to connect to a database server. DB-Access prompts you for a password.
dbaccess - - <<\!
connect to '@starfish' user 'marae';


Here the delimiting quotation marks preserve letter case in the database server name and in the authorization identifier of the user.

Copyright© 2018 HCL Technologies Limited