Software Product Description ___________________________________________________________________ PRODUCT NAME: DEC DB Integrator Gateway for SPD 47.34.00 EDA/SQL[TM], Version 3.1 DESCRIPTION DEC DB Integrator Gateway for EDA/SQL (EDA/SQL Gateway) provides ap- plications and tools with direct, read-only access to databases served by EDA/SQL servers. This access can be via interactive or dynamic SQL interfaces. Support for client/server access is provided by the SQL/Services server and ODBC drivers for Microsoft[R] Windows[TM] and Windows NT[TM] ap- plications. Optional support for embedded SQL and SQL module language programming is available. DEC DB Integrator (DBI) extends the functionality of the EDA/SQL Gate- way by providing a native integration of databases accessed by EDA/SQL Gateways and other DB Integrator gateways. DBI clients may directly access and join views of tables existing on multiple databases. These views may be horizontally or vertically partitioned and be based on tables existing on any database accessible by these gateways. DBI views may be pre-defined or dynamically declared. DBI servers maintain a persistent catalog of metadata extracted from databases served by EDA/SQL servers. DBI uses this metadata along with information on network and underlying database manager capabilities to optimize cross-database joins. The EDA/SQL Gateway is available on the DEC OSF/1[R] Operating Sys- tem on AXP systems, workstations and servers and on the OpenVMS Op- erating System on Digital AXP and VAX systems, workstations and servers. DIGITAL November 1994 AE-QDA5A-TE DEC DB Integrator Gateway for SPD 47.34.00 EDA/SQL[TM], Version 3.1 Features Standard SQL Interfaces The EDA/SQL Gateway provides direct, read-only access to EDA/SQL data sources through standard DEC SQL interfaces. These interfaces include a dynamic SQL interface, an interactive SQL facility and the SQL/Services server. SQL data manipulation language (DML) is fully supported. SQL data def- inition language (DDL) is not supported. The dynamic SQL interface compiles and executes SQL requests passed through its call interface. This programming approach is highly ef- fective in applications such as ad-hoc query access where the exact parameters of requests are not known until runtime. It is compatible with any programming language that supports the operating system's call- ing standards. The dynamic memory handling capabilities of Ada, C and P/I enable these languages to take full advantage of the power and flex- ibility of this approach. The interactive SQL facility supports the interactive query of databases accessed through EDA/SQL servers. Required data format translations are automatically performed. EDA/SQL Server Support EDA/SQL supports many network protocols and server platforms. Data sources accessible through EDA/SQL servers include: ADABASE[R], ALLBASE/SQL, Btrieve, C-ISAM[R], CA-Datacom/DB, CA-IDMS/DB, DB2, DB2/2, DB2/6000, dBASE, IMS/DB, INFORMIX[R], INGRES[R], MUMPS[R], NonStop SQL, PACE, SQL/DS, Supra Server, System 2000, TOTAL, Teradata, TurboIMAGE, UL- TRIX/SQL, Unify, VSAM and ASCII files. Contact Information Builders for current information on EDA/SQL supported data sources. Connectivity to a specific EDA/SQL server depends on the existence of a common network transport between the EDA/SQL server platform and the EDA/SQL Gateway Platform. 2 DEC DB Integrator Gateway for SPD 47.34.00 EDA/SQL[TM], Version 3.1 Desktop Connectivity The EDA/SQL Gateway includes Microsoft Open Database Connectivity (ODBC) drivers for Microsoft Windows and Windows NT. These drivers enable read access to databases via EDA/SQL servers over DECnet, TCP/IP and Nov- ell[R] NetWare[R] (IPX/SPX) transports. Network transport alternatives depend on the selected desktop and EDA/SQL Gateway platforms. [1] Performance The EDA/SQL Gateway selects access strategies that minimize data trans- fer activity. Wherever possible, selection, filtering, and statisti- cal operations are managed by the EDA/SQL server. A log of communi- cations activity and errors may be maintained to assist in problem iso- lation and evaluation. Data Dictionary Support The SQL INTEGRATE command updates CDD/Repository with definitions ex- tracted from databases accessed through EDA/SQL servers. The use of CDD/Repository with the EDA/SQL Gateway encourages consolidated main- tenance of data definitions in a repository where they can be shared by all applications, databases and programming tools that use them.[2] Optional SQL Support Support for interactive SQL and SQL application development is avail- able with the optional purchase of interactive and development licenses for DEC DB Integrator or DEC SQL. Optional SQL Development Support The optional SQL development license provides precompiler support for embedded SQL applications, a compiler for SQL module language programs and application programming interfaces (APIs) to support the devel- opment of client/server applications. ____________________ [1] ODBC client access via the Novell NetWare (IPX/SPX) transport is sup- ported only by EDA/SQL Gateways running on OpenVMS VAX platforms [2] CDD/Repository is not available on the DEC OSF/1 AXP Platform 3 DEC DB Integrator Gateway for SPD 47.34.00 EDA/SQL[TM], Version 3.1 Optional SQL Compiler Support Embedded SQL programming places SQL language statements in line with host language statements. Precompilers replace these SQL statements with call statements and object modules. The modified host language program is compiled and linked with the object modules to form an ex- ecutable image. Refer to the DEC DB Integrator SPD (SPD 47.25.xx) for more detailed information on the language precompiler support available on each gate- way platform. The SQL module language compiler included with the development option allows SQL statements and multistatement procedures to be grouped into modules. When these modules are compiled, the resulting object mod- ules can be linked with objects created by any language compiler that supports the server operating system calling standards. These compiler and precompilers support the Federal Information Pro- cessing Standards (FIPS) flagger that allows the user to identify any SQL statements which are not in the current ANSI/ISO SQL standard. An exception flagger for the Multivendor Integration Architecture (MIA) standard is also provided. Optional Client API Support The optional development license also includes the SQL/Services and SQL Multimedia API libraries. These libraries may be used by client applications on MS-DOS, Microsoft Windows, Windows NT, Macintosh[R], ULTRIX, OpenVMS and DEC OSF/1 platforms to access data in EDA/SQL data sources through EDA/SQL gateways. Refer to the DEC DB Integrator SPD (SPD 47.25.xx) for information on the clients, transports and language compilers supported by these APIs on EDA/SQL Gateway platforms. 4 DEC DB Integrator Gateway for SPD 47.34.00 EDA/SQL[TM], Version 3.1 CONFORMANCE TO STANDARDS When used in conjunction with DEC DBI, the EDA/SQL gateway complies with the International Standard, ISO/IEC 9075:1992, and the American National Standard, ANSI X3.135-1992, Database Language SQL, Entry-Level specification and the Federal Information Processing Standard for Database Language SQL (FIPS SQL) as defined in FIPS PUB 127-2. The DEC ODBC Driver for MS Windows complies with the Microsoft Open Database Connectivity specification V2.0. HARDWARE REQUIREMENTS Processors Supported AXP: DECpc AXP 150 Systems DEC 2000 Models 300, 500 Digital 2100 Server Models A500MP, A600MP DEC 3000 Models 300, 300L,300LX, 300X, 400, 400S 500, 500S, 500X, 600, 600S, 700, 800, 800S and 900 DEC 4000 Models, 600, 610, 620, 700, 710, 720 DEC 7000 Models 600, 610, 620, 700, 710, 720 DEC 10000 Model 600 Series VAX: VAX 4000 Models 50, 100, 100A, 200, 200A, 300, 300A, 500, 500A 600, 700A VAX 6000 Models 210, 220, 230, 240, 310, 320, 330, 340, 360, 410, 420, 440, 440, 450, 460, 510, 520, 530, 540, 550, 560, 610, 620, 630, 640 VAX 7000 Models 610, 620, 630, 640, 650, 660 5 DEC DB Integrator Gateway for SPD 47.34.00 EDA/SQL[TM], Version 3.1 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 9000 Models 110, 110VP, 210, 210VP, 310, 310VP, 320, 320VP, 330, 330VP 410, 410VP, 420, 420VP, 430, 430VP VAX 10000 600 Model Series VAX-11/730, VAX-11/750 VAX-11/780, VAX-11/785 VAXft: VAXft 3000 Models 110, 310, 410, 610, 612 MicroVAX: MicroVAX II, MicroVAX 2000, MicroVAX 3200, MicroVAX 3300, MicroVAX 3400, MicroVAX 3500, MicroVAX 3600, MicroVAX 3800, MicroVAX 3900, MicroVAX 3100 Models 10, 10E, 20, 20E, 30, 40, 80, 90 VAXstation: VAXstation II, VAXstation II/GPX, VAXstation II/QVSS VAXstation 2000, VAXstation 2000/GPX, VAXstation 2000/MFB VAXstation 3100 Models 30, 38, 40, 48, 76 VAXstation 3100/SPX Models 38, 48, 76 VAXstation 3100/GPX Models 38, 48, 76 VAXstation 3200, VAXstation 3500, VAXstation 3520, VAXstation 3540 VAXstation 4000 Models 60, 90, VLC VAXserver: VAXserver 3100, VAXserver 3200, VAXserver 3300, VAXserver 3400, VAXserver 3500, VAXserver 3600, VAXserver 3800, VAXserver 3900 6 DEC DB Integrator Gateway for SPD 47.34.00 EDA/SQL[TM], Version 3.1 VAXserver 4000 Models 200, 300, 400, 500, 600 VAXserver 6000 Models 210, 220, 310, 320, 410, 420, 510, 520 VAXserver 8200,VAXserver 8250, VAXserver 8300,VAXserver 8350, VAXserver 8530,VAXserver 8550, VAXserver 8600,VAXserver 8650, VAXserver 8700,VAXserver 8800, VAXserver 8810,VAXserver 8830, VAXserver 8840 Unsupported Processors MicroVAX I, VAXstation I, VAX-11/725, VAX-11/782, VAXstation 8000 AXP Processor Restrictions o A CD-ROM drive is required to install this product on an AXP pro- cessor. o A minimum of 16 MB of memory is required on AXP systems. VAX Processor Restrictions o A TK50 cartridge tape drive, 9-track 1600 BPI magnetic tape drive or CD-ROM drive is required to install this software on VAX Sys- tems. o A minimum of 4 MB of memory is required on VAX systems Disk Space Requirements Table 1 lists the disk space required to install and operate DBI soft- ware by hardware/operating system platform (Platform). The common re- quirement represents the space required to store software objects that are common to DBI and the DB Integrator family of gateways. If one of 7 DEC DB Integrator Gateway for SPD 47.34.00 EDA/SQL[TM], Version 3.1 these products is not already installed on the system or cluster, the disk space requirement will be increased by this amount. ___________________________________________________________________ Table_1:__Disk_Space_Requirements_by_Platform______________________ Disk Space Required (Blocks) Platform_______Install_____Permanent____Common_____________________ OpenVMS VAX 20,256 9,526 28,000 OpenVMS_AXP____26,940______11,463_______39,000_____________________ 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 for programs, logs, temporary database cache files and user interface software. OPTIONAL HARDWARE For DEC ODBC Driver clients on Microsoft Windows and Windows NT: o Personal Computer AT[R], or equivalent o Ethernet LAN connectivity CLUSTER ENVIRONMENT This product is fully supported when installed on any valid and li- censed VAXcluster or VMScluster configuration. These configurations are described in the VAXcluster SPD (SPD 29.78.xx), and the VMSclus- ter SPD (SPD 42.18.xx). 8 DEC DB Integrator Gateway for SPD 47.34.00 EDA/SQL[TM], Version 3.1 SERVER SOFTWARE REQUIREMENTS This section lists the software required to install and operate the EDA/SQL Gateway. Support of DEC ODBC Driver for MS Windows and DEC ODBC Driver for Windows NT client applications may require additional software. With the re- quired software, all EDA/SQL gateways support access via DECnet and TCP/IP transports. In addition, the OpenVMS VAX gateway may be accessed through the Novell NetWare (IPX/SPX) transport. DEC DB Gateway for EDA/SQL for OpenVMS VAX Platform Software Requirements o OpenVMS VAX Operating System V5.5-2 - V6.1 o EDA/LINK, V2.0 o One of the following network transports[4] - DECnet for OpenVMS VAX, Version 5.5.2 - 6.1 - DEC TCP/IP Services for OpenVMS VAX, V3.1 - TGV Multinet, Version 3.1 - Wollongong: pathway Runtime for OpenVMS, Version 1.0 - DECnet SNA Application Programming Interface for OpenVMS (VAX), Version 2.3 Network Transport Options The EDA/SQL Gateway for OpenVMS VAX will require one or more of the following network software products to support direct access to lo- cal and remote databases by SQL/Services SQL Multimedia and DEC ODBC Driver for MS Windows desktop applications. ____________________ [4] Attaches to a remote EDA/SQL servers require common network proto- col support on both the system running DEC DB Integrator Gateway for EDA/SQL and the remote system running the EDA/SQL server 9 DEC DB Integrator Gateway for SPD 47.34.00 EDA/SQL[TM], Version 3.1 o DECnet transport - DECnet for OpenVMS VAX, V5.5-2 - V6.1 o TCP/IP transport - DEC TCP/IP Services for OpenVMS VAX, V3.1 o Novell NetWare - SQL/Services and DEC ODBC Driver client applica- tions communicating via Novell NetWare[R] require a Novell IPX/SPX transport - InterConnections Leverage for NetWare File Sharing Ser- vices (FSS), V1.5 - V2.0 DEC DB Gateway for EDA/SQL for OpenVMS AXP Platform Software Requirements o OpenVMS AXP Operating System V6.1 o EDA/LINK for OpenVMS AXP, Version 2.0 o One of the following network transports[4] - DECnet for OpenVMS AXP, V1.5 - V6.1 - DEC TCP/IP Services for OpenVMS AXP, Version 3.1 - DECnet SNA Application Programming Interface for OpenVMS (AXP), Version 2.3 Network Transport Options The EDA/SQL Gateway for OpenVMS AXP will require one or more of the following network software products to support direct access to lo- cal and remote databases by SQL/Services SQL Multimedia and DEC ODBC Driver for MS Windows desktop applications. o DECnet transport - DECnet for OpenVMS AXP, V1.5 - V6.1 o TCP/IP transport - DEC TCP/IP Services for OpenVMS AXP, V3.0 - V3.1 10 DEC DB Integrator Gateway for SPD 47.34.00 EDA/SQL[TM], Version 3.1 DEC DB Gateway for EDA/SQL for OSF/1 AXP Platform Software Requirements o DEC OSF/1 AXP Operating System, V3.0 o EDA/LINK for OSF/1 AXP, Version 2 o TCP/IP Services (Included with the DEC OSF/1 Operating System) Network Transport Options The EDA/SQL Gateway for DEC OSF/1 AXP will require one or more of the following network software products to support direct access to lo- cal and remote databases by SQL/Services SQL Multimedia and DEC ODBC Driver for MS Windows desktop applications. o DECnet transport - DECnet/OSI, Version 2.0, for DEC OSF/1 AXP o TCP/IP transport - Included with the DEC OSF/1 Operating System OpenVMS Tailoring EDA/SQL gateways on OpenVMS platforms require installation of the fol- lowing OpenVMS classes. o OpenVMS Required Saveset o Programming Support o Network Support o Utilities DESKTOP CLIENT SOFTWARE REQUIREMENTS The EDA/SQL Gateway includes drivers for Microsoft ODBC clients. This section describes the software required by DEC ODBC Driver for MS Win- dows clients in order to to connect with the EDA/SQL Gateway. Table 2 lists the ODBC clients and network transport support by EDA/SQL Gate- way platform. 11 DEC DB Integrator Gateway for SPD 47.34.00 EDA/SQL[TM], Version 3.1 ___________________________________________________________________ Table_2:__DEC_ODBC_Driver_Network_Support__________________________ Server Platform/ Transport Support _______Client______________DECnet____TCP/IP____IPX/SPX_____________ OpenVMS VAX Microsoft Windows X X X OpenVMS AXP Microsoft Windows X X - OSF/1 AXP Microsoft Windows X X - _______Windows_NT__________X_________X_________-___________________ DEC ODBC Driver for Windows NT Client (TCP/IP Transport): o Microsoft Windows NT Operating System, V3.1 o MS Windows, V3.1 DEC ODBC Driver for Windows NT Intel Client (DECnet Transport): o Microsoft Windows NT Operating System, V3.1 o Microsoft Windows, V3.1 o PATHWORKS for NT, V4.1 DEC ODBC Driver for MS Windows Intel client (DECnet Transport): o MS-DOS Operating System, V5.0 - V6.2 o Microsoft Windows, V3.1 o One of the following network products: - PATHWORKS for DOS, V4.1A 12 DEC DB Integrator Gateway for SPD 47.34.00 EDA/SQL[TM], Version 3.1 - PATHWORKS V5 for DOS and Windows client software DEC ODBC Driver for MS Windows client (TCP/IP Transport): o MS-DOS Operating System, V5.0 - V6.2 o Microsoft Windows, V3.1 o One of the following network products: - PATHWORKS for DOS (TCP/IP), V2.0 - A Windows Sockets V1.1 specification compliant transport.[3] OPTIONAL SOFTWARE o DEC SQL for OpenVMS AXP, V6.0 o DEC SQL for OpenVMS VAX, V6.0 o CDD/Repository for OpenVMS VAX, V5.1 - V5.2 o CDD/Repository for OpenVMS AXP V5.1 - V5.2 GROWTH CONSIDERATIONS The minimum hardware/software requirements for any future version of this product may be different from the requirements for the current version. ____________________ [3] PATHWORKS V5 for DOS and Windows client software and FTP[R] PC/TCP V2.3 have been fully tested with the SQL/Services and DEC ODBC Driver for Microsoft Windows clients. Other transports that comply with the Windows Sockets V1.1 specification may function correctly but have not been fully tested by Digital 13 DEC DB Integrator Gateway for SPD 47.34.00 EDA/SQL[TM], Version 3.1 DISTRIBUTION MEDIA Media for OpenVMS VAX systems is distributed on 9-track 1600 BPI Mag- netic Tape, TK50 Streaming Tape and as part of the OpenVMS VAX Con- solidated Software Distribution on CD-ROM (CONDIST). Media for OpenVMS AXP systems is distributed as part of the OpenVMS AXP Layered Product Libraries on CD-ROM. Media for DEC OSF/1 AXP systems is distributed as part of the DEC OSF /1 AXP Layered Product Libraries on CD-ROM. ORDERING INFORMATION DEC DB Integrator Gateway for EDA/SQL for OpenVMS VAX Traditional Software Licenses: QL-0VCA*-** Concurrent Use License: QL-0VCAA-3B Software Media and Doc: QA-0VCA*-** Software Media (CONDIST): QA-VWJ8A-A8 Software Documentation: QA-0VCAA-GZ Software Product Services: QT-0VCA*-** DEC DB Integrator Gateway for EDA/SQL for OpenVMS AXP Traditional Software Licenses: QL-0VDA*-** Concurrent Use License: QL-0VCAA-3B Software Media and Doc: QA-03XAA-H8 Software Documentation: QA-0VCAA-GZ Software Product Services: QT-3E0A*-** DEC DB Integrator Gateway for EDA/SQL for OSF/1 AXP Traditional Software Licenses: QL-2NAA*-** Concurrent Use License: QL-2NAAM-3B Software Media and Doc: QA-054AA-H8 Software Documentation: QA-0VCAA-GZ Software Product Services: QT-2NAA*-** 14 DEC DB Integrator Gateway for SPD 47.34.00 EDA/SQL[TM], Version 3.1 * Denotes variant fields. For additional information on available li- censes, services, and media, refer to the appropriate price book. SOFTWARE LICENSING This software is furnished only under a license. For more information about Digital's licensing terms and policies, contact your local Digital office. License Management Facility Support This layered product supports the Digital License Management Facil- ity as implemented on the OSF/1 and OpenVMS operating systems. Tra- ditional and Concurrent Use licenses are available. A Traditional li- cense permits an unlimited number of authorized users to access this product on a single, identified processor. A Concurrent Use license allows any one user at a time to access the layered product. For this software product a user is defined as an OSF/1 or OpenVMS pro- cess serving either an individual or another local or remote process. For more information on the License Management Facility, refer to the OSF/1 or OpenVMS Operating System documentation. Client Software Licensing Parties selling or distributing a software product that incorporates the Microsoft ODBC application programming interface, may copy and dis- tribute Digital Equipment Corporation's DEC ODBC Driver distribution kit with that software product. The DEC ODBC Driver kit must be dis- tributed in a manner that guarantees the end-user will receive the en- tire contents of the DEC ODBC Driver kit. SOFTWARE PRODUCT SERVICES A variety of service options are available from Digital. For more in- formation, contact your local Digital office. 15 DEC DB Integrator Gateway for SPD 47.34.00 EDA/SQL[TM], Version 3.1 SOFTWARE WARRANTY Warranty for this software product is provided by Digital with the pur- chase of a license for the product as defined in the Software Warranty Addendum of this SPD. [R] AppleTalk and Macintosh are registered trademarks of Apple Computer Inc. [R] INGRES is a registered trademark of Computer Associates Inter- national, Inc. [R] dBASE is a registered trademark of Borland International, Inc. [R] C-ISAM, INFORMIX, INFORMIX-Online and INFORMIX-SE are regis- tered trademarks of Informix Software, Inc. [R] HP-UX is a registered trademark of Hewlett-Packard Company. [R] AIX, AT, IBM and OS/2 are registered trademarks of Interna- tional Business Machines Corporation. [R] MUMPS is a registered trademark Massachusettes General Hospital [R] Microsoft, MS, and MS-DOS are registered trademarks of Mi- crosoft Corporation. [R] Novell and NetWare are registered trademarks of Novell Inc. [R] OSF/1 is a registered trademark of Open Software Foundation, Inc. [R] ORACLE is a registered trademark of Oracle Corporation. [R] FTP is a registered trademark of Schere Laboratories, Inc. [R] ADABASE is a registered trademark of Software AG of North Amer- ica, Inc [R] Sun and Solaris are registered trademarks of Sun Microsystems, Inc. [R] SYBASE is a registered trademark of Sybase, Inc. [R] MultiNet is a registered trademark of TGV, Inc. [TM]MPW is a trademark of Apple Computer Inc. [TM]EDA/SQL is a trademark of Information Builders, Inc. 16 DEC DB Integrator Gateway for SPD 47.34.00 EDA/SQL[TM], Version 3.1 [TM]DB2 is a trademark of International Business Machines Corpora- tion. [TM]Windows and Windows NT are trademarks of Microsoft Corporation. [TM]SunOS is a trademark of Sun Microsystems, Inc. [TM]The DIGITAL Logo, AXP, Bookreader, CDD/Repository, CI, DATATRIEVE, DEC, DEC Ada, DEC Fortran, DEC RALLY, DEC Rdb, DECdtm, DECnet, Digital, MicroVAX, MicroVAX I, MicroVAX II, OpenVMS, PATHWORKS, SQL Multimedia, ULTRIX, VAX, VAX 11/750, VAX 11/780, VAX 6000, VAX 8200, VAX 8250, VAX 8300, VAX 8350, VAX 8500, VAX 8530, VAX 8550, VAX 8600, VAX 9000, VAXcluster, VAXft, VAXserver, VAXstation, VAXstation 4000 VLC, VAX RMS, VMS, VMS RMS and VMScluster are trademarks of Digital Equipment Corporation. All other trademarks and registered trademarks are the property of their respective owners. ©1994 Digital Equipment Corporation. All rights reserved. 17