Create the Adapter Configuration Files

Reference:

The Adapter requires one configuration file named EDASERVE. In addition, if you want all users to connect with the same credentials, you need to create another configuration file named FOCPROF in which to issue the SET CONNECTION_ATTRIBUTES command with the user ID and password for connecting to Oracle. If you want each user to connect with separate credentials, do not create the FOCPROF member. Each user will then have to issue the SET USER command in the batch input stream, in a FOCEXEC, or at the command line.

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.


Top of page

x
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:

ora_oci = y
ora_access = y
ora_rel = xx 

where:

xx

Is the Oracle release (92 for Oracle 9 and 10 for Oracle 10).


Top of page

x
Reference: Create the FOCPROF Configuration File

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

ENGINE SQLORA SET CONNECTION_ATTRIBUTES CON1 <local>/username,password  

where:

username

Is the default user ID for connecting to Oracle.

password

Is the default password for connecting to Oracle.

If you do not want every user to connect with the same credentials, do not create the FOCPROF member. Each user must then issue the SET USER command in the batch input stream, in a FOCEXEC, or at the command prompt. The syntax is

SQL SQLORA SET USER /username,password  

where:

username

Is the Oracle user ID for this user.

password

Is the Oracle password for this user.


Information Builders