Supplies login credentials for a DB2 database connection.
Restriction: This topic applies to Windows environments (local development) only.
Syntax:
Note: SQLPASS.TXT is deprecated, and provided for backward compatibility only. We recommend using the PASS compiler directive option
to supply login credentials.
SET SQLPASS.TXT=[path]credfile
Parameters:
- path
- The full path to the directory that contains a text file containing the appropriate login credentials.
- credfile
- The name of a text file containing login credentials in the format
userid.password. For example:
MyId.MyPassword
Note: If the database login is case sensitive, be sure to supply the appropriate case for both the user ID and password.
Example:
SET SQLPASS.TXT=D:\BATCH.TXT