Use the Database Connection User Exit to customize the connection to the particular database. This user exit enhances database security. The default processing of this user exit provides a simple database connection.
There exists a Database Connect User Exit for each supported DBMS: Oracle and DB2.
The default method for CA Gen to acquire DBMS connection information for blockmode applications is for the AEF to locate the trancode in the AEENV file. Connection information includes the username, password, and database name. Each person that executes the application must have read access to the AEENV file that contains the connection information.
|
Database |
Description |
Host Variable |
Declared Type |
|---|---|---|---|
|
Oracle |
user ID |
uid |
VARCHAR(32) |
|
Oracle |
Password |
pwd |
VARCHAR(32) |
|
DB2 |
user ID |
uid |
char(9) |
|
DB2 |
Password |
pwd |
char(9) |
|
DB2 |
database name |
dbname |
char(9) |
We recommend leaving the call to dbid() unchanged, and adding logic immediately before the database connect statements to populate the appropriate variables. Ensure that you add all code that the DBMS requires. For example, verify arr and len elements are populated correctly for VARCHAR. We also recommend that all AEENV files contain character strings as place holders for the database connection information. These character strings do not have to contain valid connection information.
For greater security, add a call to an encryption routine.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|