USER Authentication Clause

The USER Authentication clause specifies information that is used to determine whether the application can access the target computer on a remote host.
USER Authentication Clause

1  USER
2.1 'user_id'
2.1 user_id_var  USING validation_var
Element Description Restrictions Syntax
user_id Valid login name See Restrictions on the User Identifier Parameter. Quoted String
user_id_var Host variable that contains user_id Must be a fixed-length character data type; same restrictions as user_id Language specific
validation_var Host variable that contains a valid password for login name in user_id or user_id_var Must be a fixed-length character type. See Restrictions on the Validation Variable Parameter. Language specific

The USER Authentication clause is required when the CONNECT statement connects to the database server on a remote host. Subsequent to the CONNECT statement, all database operations on the remote host use the specified user name.

In DB-Access, the USING clause is valid within files executed from DB-Access. In interactive mode, DB-Access prompts you for a password, so the USING keyword and validation_var are not used.