Supplies login credentials required to connect to a DB2 database.
Syntax:
PASS={password | userid.password}
NOPASS
Parameters:
- password
- Visual COBOL accepts a maximum of 18 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.
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.