D3 Oracle Gateway User's Guide

D3 Oracle Gateway User's Guide

The D3 Oracle Gateway is an OSFI interface that allows the D3 programmer to open, read, write and select data from an Oracle database with all the standard D3 tools such as BASIC, Update Processor, Editor, AQL, and so on. Oracle’s OCI interface is used to implement the D3 Oracle Gateway.

Due to differences in library code between versions of Oracle and D3, the D3 Oracle Gateway is shipped as an unlinked object that must be linked with your Oracle libraries. This procedure enumerates the tasks that must be completed to install the D3 Oracle Gateway.

  1. Limitations
    The following limitations apply to the D3 Oracle Gateway.
  2. Software requirements
    Review the following system requirements prior to installing D3 Oracle Gateway.
  3. Before starting
    It is important to back up some Unix files prior to installing D3 Oracle Gateway.
  4. Installing for D3 AIX or Linux
    Complete these instructions to install D3 Oracle Gateway for D3 AIX or Linux,
  5. Defining D3 Oracle Gateway dm,hosts, file
    The D3 Oracle Gateway dm,hosts, file entries can be configured during installation or at a later time. All OSFI data sources MUST be identified by an entry in the dm,hosts, file. The dm,hosts, file converts a host name to a driver number and connection information. Each Oracle dm,hosts, file item identifies a specific schema -- the intersection of the computer name, the Oracle instance name within that computer, and the schema name within that instance.
  6. Creating Q-pointers
    Create the D3 Oracle Gateway Q-pointers for each Oracle database. The remote Q-pointer defines the D3 view of an Oracle table. The name of each Oracle table column available to D3 is enumerated within the Q-pointer.