The variable A_ODBC_PASSWD should be set to the password assigned to the database account associated with the user name specified by A_ODBC_LOGIN. Not all data sources require a password. Those that do may have case requirements. Check your data source documentation to determine if password is case-sensitive.
For example, specify the following in the run time configuration file if the account with the user name in A_ODBC_LOGIN has the associated password CW021535:
For better security, you can accept a password from the user during program execution; set the A_ODBC_PASSWD variable based on the response:
ACCEPT RESPONSE NO-ECHO. SET ENVIRONMENT "A_ODBC_PASSWD" TO RESPONSE.
If the user has been set up without a password, this variable need not be set. There is no default value for this variable. If no password is specified, none is used.