Create the Adapter Configuration Files

The Adapter requires one configuration file named EDASERVE. In addition, if you want to set a default connection to Teradata, you can create another configuration file named FOCPROF.

The two members can either be placed directly in the hlq.ERRORS.DATA data set (which is an alias of hlq.CONF.CFG), or they can be placed in a separate Partitioned DataSet (PDS) and be concatenated to hlq.ERRORS.DATA in your CLIST or JCL.

Reference: The EDASERVE Configuration File

Create a member named EDASERVE and place it in the data set hlq.ERRORS.DATA, where hlq is the high-level qualifier under which you installed FOCUS. Note that hlq.ERRORS.DATA is an alias for hlq.CONF.CFG.

The EDASERVE member must contain the following attributes.

dbc_cli = y                 
dbc_access = y

Reference: Create the FOCPROF Configuration File (Optional)

If you want to set a default connection to Teradata for all users, create another member named FOCPROF in hlq.ERRORS.DATA. Include the SET CONNECTION_ATTRIBUTES command in member FOCPROF.

-SET &CONSTR='location/username,password';       
ENGINE SQLDBC SET CONNECTION_ATTRIBUTES &CONSTR       
END

where:

&CONSTR: Is set to the logon attributes needed to connect to the Teradata instance from which you are reporting. Get this information from your Teradata Database Administrator (DBA). Replace location, username and password with the correct values that are applicable at your site.

Note: If you are passing a username, but no password, you still need to include the comma (,), which will end the line in a comma-semicolon combination (,;).