3.3 Accessing the Gateway

This topic describes how to access the gateway.

To access the gateway, complete the following steps on the Oracle database:

1. Log into the Oracle database to access the gateway.
2. Create a database link to the DRDA database. For example:

   CREATE PUBLIC DATABASE LINK DRDA
   CONNECT TO ORADRDA IDENTIFIED BY oracle_pw 
   USING 'tns_name_entry' 

3. Retrieve data from the DRDA database.

   This query fetches the TABLE table in the schema SECURE, using the name ORADRDA as the DRDA server user profile. The ORADRDA user profile must have the appropriate privileges on the DRDA server to access the SECURE.TABLE files:

   SELECT * FROM SECURE.TABLE@DRDA
   

   The following is an example of the error messages that are displayed if insufficient privileges are displayed:

   ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
   [Oracle][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and
   Linux]ORADRDA DOES NOT HAVE PRIVILEGE TO PERFORM OPERATION SELECT ON THIS
   OBJECT SECURE.TABLE.
   ORA-02063: preceding 2 lines from DRDA