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.
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:
Is the Oracle release (92 for Oracle 9 and 10 for Oracle 10).
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:
Is the default user ID for connecting to Oracle.
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:
Is the Oracle user ID for this user.
Is the Oracle password for this user.
Information Builders |