Supplies login credentials required to connect to a DB2 database.
Syntax:
PASS={{password | userid.password} | MFV_secret-name }
NOPASS
Parameters:
- password
- Enterprise Developer accepts a maximum of 127 characters for the password; however, the length cannot exceed the maximum set by DB2 or the operating
system.
- userid
- Enterprise Developer 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.
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.