PASS

Supplies login credentials required to connect to a DB2 database.

Syntax:

PASS={{password | userid.password} | MFV_secret-name }
NOPASS

Parameters:

password
Visual COBOL accepts a maximum of 127 characters for the password; however, the length cannot exceed the maximum set by DB2 or the operating system.
userid
Visual COBOL accepts a maximum of 30 characters for the user ID; however, the length cannot exceed the maximum set by DB2 or the operating system.
MFV_secret-name
This is the name of the vault secret that contains your data source credentials, stored in the Enterprise Server Vault Facility. See The mfsecretsadmin Utility for details.
Important: When you create the vault secret containing your data source credentials, be sure to prefix its name with MFV_, and specify the output location as Microfocus/DB2ECM. When the value for the PASS directive consists of MFV_ followed by a vault secret name, the value stored in the following key:
Microfocus/DB2ECM/MFV_secret-name

Is used as the password or userid.password.

Properties:

Default: NOPASS

Comments:

By default, the compiler uses the operating system user credentials to connect to the DB2 database.

When connecting to a database, use PASS only when it is necessary to supply credentials other than the operating system credentials as in the following cases:

  • You are logged into the operating system as a user that does not have the documented DB2 privileges.
  • You are logged into the operating system as a user who is not the owner of unqualified database metadata referenced by the program being compiled.
  • When connecting to a database that resides on a remote server and is catalogued locally.