Software Product Description ________________________________________________________________ PRODUCT NAME: DEC RdbAccess for ORACLE on VMS, Version 1.0 SPD 32.80.00 DESCRIPTION DEC RdbAccess is a family of database interoperability prod- ucts which provide direct, transparent access from VAX Rdb/VMS applications to non-VAX Rdb/VMS databases and files. DEC RdbAc- cess servers are specialized VAX Rdb/VMS run-time systems which can be accessed by most applications and tools which work with VAX Rdb/VMS. DEC RdbAccess for ORACLE[R] on VMS (referred to as RdbAccess for ORACLE) provides direct, transparent, read-only access to ORACLE databases residing on VAX/VMS systems from applications developed using products such as VAX RALLY, VAX DATATRIEVE, VAX TEAMDATA, and DECdecision. RdbAccess for ORACLE also supports access from the VAX Rdb/VMS interactive utilities, SQL and RDO, from precompiled 3GL appli- cations with embedded SQL or RDML, and from desktop applications using SQL/Services. VAX Data Distributor can be used to ex- tract data from ORACLE and replicate the information across the network in VAX Rdb/VMS. RdbAccess for ORACLE runs under VMS on VAX, MicroVAX, VAXserver, and VAXstation systems. Features o RdbAccess for ORACLE provides direct database access to VMS- based ORACLE tables and views. The user application accesses ORACLE data the same way it would access Rdb/VMS data. Data retrieved from ORACLE can be displayed at a user's terminal, printed, or copied to another database or file. DIGITAL August 1990 AE-PCB7A-TE DEC RdbAccess for ORACLE on VMS, Version 1.0 SPD 32.80.00 o RdbAccess for ORACLE does not require users to create a copy of the ORACLE database in order to make the data available to VAX Rdb/VMS applications. Creating VAX Rdb/VMS extracts of ORACLE data is a matter of user preference and convenience. o RdbAccess for ORACLE is a specialized VAX Rdb/VMS run-time system. All requests for ORACLE data are processed by the VAX Rdb/VMS run-time system. A user or programmer makes requests to ORACLE using exactly the same commands as would be used to access VAX Rdb/VMS. o RdbAccess for ORACLE supports most of the same user inter- faces that can be used with VAX Rdb/VMS. o ORACLE data can be accessed directly from precompiled 3GL programs using embedded SQL, SQL module language, dynamic SQL, callable RDO, or RDML. These data access sublanguages are the same sublanguages used to access VAX Rdb/VMS data tables and views. Reference VAX Rdb/VMS (SPD 25.59.xx) for a complete description of programming language support. o ORACLE data can be accessed interactively using the VAX Rdb/VMS interactive utilities, SQL and RDO. o ORACLE data can be accessed through SQL/-Services directly from desktop applications running on MS-DOS[R], OS/2[TM], Macintosh[TM], ULTRIX or VMS. Reference VAX Rdb/VMS (SPD 25.59.xx) for a complete description of SQL/Services. o ORACLE data can be extracted and stored in Rdb/VMS tables us- ing VAX Data Distributor. Data from multiple ORACLE databases can be rolled up into a single Rdb/VMS table. o When RdbAccess for ORACLE is used with VAX DATATRIEVE, users can generate DATATRIEVE queries and reports that include data from both ORACLE tables or views and Rdb/VMS tables or views. o When RdbAccess for ORACLE is used with DECdecision or VAX TEAMDATA, end users can access ORACLE data tables and views directly, join them with Rdb/VMS tables, store the results in folders, download the data to a PC-based spreadsheet, 2 DEC RdbAccess for ORACLE on VMS, Version 1.0 SPD 32.80.00 etc., for use in decision support and other personal and departmental applications. o VAX RALLY can use RdbAccess for ORACLE to retrieve informa- tion directly from ORACLE at application execution time. o When a user attaches to the ORACLE database, RdbAccess for ORACLE retrieves metadata from the ORACLE catalog and con- verts the definitions into Digital relational data defi- nitions. These definitions can be integrated into CDD/Plus using the RDO or SQL INTEGRATE commands. 3GL programs can be compiled against data definitions in CDD/Plus. o When a request is made for ORACLE data, the VAX Rdb/VMS runtime system passes the request to RdbAccess for ORACLE. RdbAccess for ORACLE converts the request into ORACLE SQL and submits it to ORACLE using dynamic SQL. RdbAccess for ORACLE performs any necessary data translations and returns the results to the calling program. o RdbAccess for ORACLE supports remote access to ORACLE data using either VAX Rdb/VMS remote data access capabilities or ORACLE remote data access capabilities. RdbAccess for OR- ACLE must be installed on the same node as an ORACLE DBMS instance. Applications on a remote node can access ORACLE provided that the remote node is running VAX Rdb/VMS. Rd- bAccess for ORACLE can direct a request to a remote ORACLE database using ORACLE's SQL*Net[R]. o RdbAccess provides a logging facility that can trace communi- cations activity, log errors, and help isolate problems. Limitations RdbAccess for ORACLE provides read-only access to ORACLE databases running on VAX systems. HARDWARE REQUIREMENTS VAX, MicroVAX, VAXstation, or VAXserver configuration as speci- fied in the System Support Addendum (SSA 32.80.00-x). 3 DEC RdbAccess for ORACLE on VMS, Version 1.0 SPD 32.80.00 SOFTWARE REQUIREMENTS* VMS Operating System VAX Rdb/VMS DECnet-VAX o Refer to the System Support Addendum (SSA 32.80.00-x) for availability and required versions fo prerequisite software. ORDERING INFORMATION Software Licenses: QL-YQVA*-** Software Media: QA-YQVA*-** Software Documentation: QA-YQVA*-GZ Software Product Services: QT-YQVA*-** * Denotes variant fields. For additional information on avail- able licenses, services and media, refer to the appropriate price book. SOFTWARE LICENSING This software is furnished under the licensing provisions of Digital Equipment Corporation's Standard Terms and Conditions. For more information about Digital's licensing terms and poli- cies, contact your local Digital office. LICENSE MANAGEMENT FACILITY SUPPORT This layered product supports the VMS License Management Facil- ity. License units for this product are allocated on a CPU-capacity basis. For more information on the License Management Facility, refer to the VMS Operating System Software Product Description (SPD 25.01.xx) or the License Management Facility manual of the VMS Operating System documentation set. 4 DEC RdbAccess for ORACLE on VMS, Version 1.0 SPD 32.80.00 For more information about Digital's licensing terms and poli- cies, contact your local Digital office. SOFTWARE PRODUCT SERVICES A variety of service options are available from Digital. For more information, contact your local Digital office. SOFTWARE WARRANTY Warranty for this software product is provided by Digital with the purchase of a license for the product as defined in the Software Warranty Addendum of this SPD. [R] ORACLE and SQL*Net are registered trademarks of Oracle Corporation. [TM] OS/2 is a trademark of IBM Corporation. [TM] Macintosh is a trademark of Apple Computer, Inc. [R] MS-DOS is a registered symbol of Microsoft Corporation. [TM] The DIGITAL Logo, VMS, VAX, VAXstation, VAXserver, DECnet and MicroVAX are trademarks of Digital Equipment Corpora- tion. 5 System Support Addendum ________________________________________________________________ PRODUCT NAME: DEC RdbAccess for ORACLE on VMS, Version 1.0 SSA 32.80.00-A HARDWARE REQUIREMENTS Processors Supported VAX: VAX 6000 Model 200 Series, VAX 6000 Model 300 Series, VAX 6000 Model 400 Series VAX 8200, VAX 8250, VAX 8300, VAX 8350, VAX 8500, VAX 8530, VAX 8550, VAX 8600, VAX 8650, VAX 8700, VAX 8800, VAX 8810, VAX 8820, VAX 8830, VAX 8840, VAX 8842, VAX 8974, VAX 8978 VAX-11/780, VAX-11/785 MicroVAX: MicroVAX II, MicroVAX 2000, MicroVAX 3100, MicroVAX 3300, MicroVAX 3400, MicroVAX 3500, MicroVAX 3600, MicroVAX 3800, MicroVAX 3900 VAXstationVAXstation II, VAXstation 2000, VAXstation 3100 Series, VAXstation 3200, VAXstation 3500, VAXstation 3520, VAXstation 3540 DIGITAL August 1990 AE-PCB8A-TE DEC RdbAccess for ORACLE on VMS, Version 1.0 SSA 32.80.00-A VAXserver:VAXserver 3100, VAXserver 3300, VAXserver 3400, VAXserver 3500, VAXserver 3600, VAXserver 3602, VAXserver 3800, VAXserver 3900 VAXserver 6000-210, VAXserver 6000-310, VAXserver 6000-410, VAXserver 6000-420 Processors Not Supported VAX-11/730, VAX-11/750, VAXstation 8000 A minimum system configuration includes: o One TK50 cartridge tape drive, or one 9-track 1600 BPI mag- netic tape for installation of software o 4 MB memory o WCS microcode version 123 or later (VAX-11/78x systems only) o ECO level 4 or later (VAX-11/780 systems only) Block Space Requirements (Block Cluster Size = 1) Disk space required 4,500 blocks for installation: (2.30M bytes) Disk space required 1,900 blocks for use (permanent): (.97M bytes) 2 DEC RdbAccess for ORACLE on VMS, Version 1.0 SSA 32.80.00-A These counts refer to the disk space required on the system disk. The sizes are approximate; actual sizes may vary depending on the user's system environment, configuration and software options selected. Additional space must be allowed space for programs, logs, and temporary database cache files, and user interface software such as VAX Data Distributor and VAX DATATRIEVE. CLUSTER ENVIRONMENT This product is fully supported when installed on any valid and licensed VAXcluster* configuration without restrictions. The HARDWARE REQUIREMENTS sections of this product's Software Product Description and System Support Addendum detail any special hardware required by this product. * VAXcluster configurations are fully described in the VAXclus- ter Software Product Description (SPD 29.78.xx) and include CI, Ethernet and Mixed Interconnect configurations. SOFTWARE REQUIREMENTS o VMS Operating System V5.2 - V5.4 o VAX Rdb/VMS V3.1 * o DECnet-VAX V5.2 - V5.4 3 DEC RdbAccess for ORACLE on VMS, Version 1.0 SSA 32.80.00-A * NOTE. At least one VAX Rdb/VMS full development license must be installed on the network, although VAX Rdb/VMS does not need to be installed on the same node as RdbAc- cess for ORACLE. RdbAccess for ORACLE must be installed on the same node as an ORACLE DBMS instance. To access ORACLE data from nodes in a network other than a node on which RdbAccess is installed, either VAX Rdb/VMS De- velopment Option, VAX Rdb/VMS Interactive Option, or VAX Rdb/VMS Run-Time Only Option software must be installed on the node from which the user initiates the access. Refer- ence VAX Rdb/VMS (SPD 25.59.xx) for more information on runtime, interactive, and full development options. Other Software RdbAccess for ORACLE does not include a user interface. Refer to the Optional Software section for choices. VMS Tailoring For VMS V5.x the following VMS classes are required for full functionality of this layered product. o VMS Required Saveset o Programming Support o Network Support o Utilities For more information on VMS classes and tailoring, refer to the VMS Operating System Software Product Description (SPD 25.01.xx) OPTIONAL SOFTWARE One of the following must be used to provide an Rdb-Access for ORACLE user interface: For interactive query access use one or more of the following: o VAX RALLY V2.1 - V2.2 4 DEC RdbAccess for ORACLE on VMS, Version 1.0 SSA 32.80.00-A o VAX DATATRIEVE V4.2 o DECdecision V1.0 o VAX TEAMDATA V1.3 - V1.4 o Interactive SQL and RDO (Rdb/VMS V3.1) For application development using high level languages, use one or more of the following precompilers supplied with the VAX Rdb/VMS V3.1 Full Development Option. For more information about VAX Rdb/VMS application development options and supported version of high level language compilers, please refer to the VAX Rdb/VMS Software Product Description (SPD 25.59.xx). o SQL$PRE SQL precompilers for VAX Ada, VAX C, VAX COBOL, VAX FORTRAN, VAX PASCAL and VAX PL/I o RDBPRE precompilers for VAX BASIC, VAX COBOL, and VAX FORTRAN o RDML precompilers for VAX C and VAX PASCAL o SQL Module Language for any language that supports the VMS calling standard o Callable RDO for any language that supports the VMS calling standard o SQL/Services API Other Optional Software o VAX CDD/Plus V4.0 o VAX Data Distributor V2.1 GROWTH CONSIDERATIONS The minimum hardware/software requirements for any future ver- sion of this product may be different from the minimum require- ments for the current version. DISTRIBUTION MEDIA Tape: 9-track 1600 BPI Magtape (PE), TK50 Streaming Tape 5 DEC RdbAccess for ORACLE on VMS, Version 1.0 SSA 32.80.00-A This product is also available as part of the VMS Consolidated Software Distribution on CDROM. ORDERING INFORMATION Software Licenses: QL-YQVA*-** Software Media: QA-YQVA*-** Software Documentation: QA-YQVAA-GZ Software Product Services: QT-YQVA*-** * Denotes variant fields. For additional information on avail- able licenses, services and media, refer to the appropriate price book. The above information is valid at time of release. Please con- tact your local Digital office for the most up-to-date informa- tion. [R] ORACLE and SQL*Net are registered trademarks of Oracle Corporation. [TM] OS/2 is a trademark of IBM Corporation. [TM] Macintosh is a trademark of Apple Computer, Inc. [R] MS-DOS is a registered trademark of Microsoft Corporation. [TM] The DIGITAL Logo, VMS, VAX, VAXstation, VAXserver, DECnet and MicroVAX are trademarks of Digital Equipment Corpora- tion. 6