In addition to setting the variables required for ODBC, you will need to do the following:
To set up your user environment to use Database Connectors, the most convenient method is to populate an ACUFH configuration file with the configuration variables to suit your requirements; you can make a personalized copy of the ACUFH configuration file and set the A_CONFIG variable to point to this. Populate this file with the variables as detailed in ACUFH Configuration File Variables.
Alternatively, if you do not use a configuration file, you must set each required variable directly in the environment, either from the command line or programmatically.
Whichever method you use, you must at least set the valid user login details for your data source. These are A_ODBC_LOGIN and A_ODBC_PASSWD.
SET ENVIRONMENT "A_ODBC_PASSWD" TO user-entry