Previous Topic Next topic Print topic


SQLPASS.TXT environment variable

Deprecated. Supplies login credentials for a DB2 database connection.
Restriction: This topic applies to Windows environments (local development) only.

Syntax:

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.

Comments:

Attention: SQLPASS.TXT is deprecated, and provided for backward compatibility only. We recommend using the PASS compiler directive option to supply login credentials.

Example:

SET SQLPASS.TXT=D:\BATCH.TXT 
Previous Topic Next topic Print topic