DIGITAL Software Product Description ___________________________________________________________________ PRODUCT NAME: DIGITAL DATATRIEVE Version 7.2 for OpenVMS Alpha Sys- tems SPD 52.94.03 DESCRIPTION DIGITAL[TM] DATATRIEVE[TM] for OpenVMS[TM] Alpha[TM] systems is a query, report, and data management tool for the OpenVMS Operating System. It provides a uniform access method for data stored by RMS[TM], Oracle Rdb[TM], and Oracle CODASYL DBMS[TM] files on OpenVMS and data residing in other databases accessible by the Oracle Rdb Transparent Gateway[TM] prod- ucts. Using DIGITAL DATATRIEVE, a novice or experienced user can re- trieve or modify data without considering the underlying storage method or physical location. Modes of Operation DIGITAL DATATRIEVE presents information in several different formats. Information can be displayed using simple defaults or can be reported on through a more flexible report writer. Information can be displayed on a terminal or workstation, printed on a hard-copy device, or writ- ten to a file. Information can also be presented graphically with user- defined DEC FMS[TM] forms, as well as with DECforms[TM]. Graphics out- put is ReGIS[TM]; it can be managed by devices or converters accept- ing ReGIS. DIGITAL DATATRIEVE also provides an efficient way to ac- cess information stored on other Alpha, VAX[TM] or PDP[TM]-11 systems linked by DECnet[TM]. October 1997 AE-Q42HD-TE DIGITAL DATATRIEVE Version 7.2 for OpenVMS Alpha SysteSPD 52.94.03 DIGITAL DATATRIEVE can be used interactively to retrieve, modify, store, or delete data using a simple set of commands. Frequently used com- binations of commands can be stored as named procedures and invoked by name. Programs written in other DIGITAL languages can call DIGI- TAL DATATRIEVE, allowing them to be independent of underlying data stor- age methods and physical location. A DECwindows[TM] Motif[R] interface to DIGITAL DATATRIEVE is provided. This allows the user to perform a subset of the DIGITAL DATATRIEVE func- tions using menu bars, scroll bars, pop-up menus, pull-down menus, and buttons. The user can also use a navigator to browse through the dic- tionary directories, select objects, and execute commands on them di- rectly from pop-up menus. Data Dictionary DIGITAL DATATRIEVE is dictionary driven. DIGITAL DATATRIEVE has re- moved the dependencies from Oracle CDD/Repository[TM] by supporting a new textfile dictionary in addition to Oracle CDD/Repository. DIG- ITAL DATATRIEVE provides the following two independent dictionary al- ternatives: o Data Dictionary using Oracle CDD/Repository for OpenVMS. o DIGITAL DATATRIEVE textfile-based dictionary. Data Dictionary using Oracle CDD/Repository for OpenVMS Using this dictionary, data descriptions are stored in and retrieved from Oracle CDD/Repository for OpenVMS. DIGITAL DATATRIEVE includes commands to store, examine, modify, and delete definitions in the dic- tionary and can use definitions stored by other layered products, such as the Oracle CODASYL DBMS schema definitions or the Oracle Rdb for OpenVMS database definitions. DATATRIEVE requires the Oracle/CDD Repos- itory in order to manage the Oracle CODASYL DBMS databases. DIGITAL DATATRIEVE fully supports CDO format dictionaries, including the ability to access shareable fields. Pieces tracking is also sup- ported for these entities. DIGITAL DATATRIEVE includes full support for DMU format dictionaries as well. 2 DIGITAL DATATRIEVE Version 7.2 for OpenVMS Alpha SysteSPD 52.94.03 Textfile-based Dictionary If Oracle CDD/Repository is present on the system, you can select, at installation time, whether to link DIGITAL DATATRIEVE with Oracle CDD/Repository or not. When Oracle CDD/Repository is linked to DIGITAL DATATRIEVE, its use can dynamically be disabled and enabled at run time by using the SET CDD and SET NO CDD commands. When Oracle CDD/Repository is not linked to DIGITAL DATATRIEVE, the alternative textfile dictionary is enabled. The new textfile dictionary stores the DIGITAL DATATRIEVE object def- initions as text in text files. Oracle CDD/Repository objects definitions can be extracted and rede- fined as text files in the new dictionary system. Text file defini- tions cannot be shared with compilers and database systems, but can be accessed and manipulated by applications and OpenVMS utilities. Temporary Definition of Objects DIGITAL DATATRIEVE extends the use of the DECLARE command to define DIGITAL DATATRIEVE objects. Such objects are temporary (time scope is within a DIGITAL DATATRIEVE session) and do not depend on any dictio- nary system, since they are stored in memory. Protection o Protection with Oracle CDD/Repository. When DIGITAL DATATRIEVE accesses the data through data definitions stored by Oracle CDD/Repository for OpenVMS, protection provided by Oracle CDD/Repository applies. An Access Control List associated with an object defini- tion specifies the types of access that are granted to the defi- nition itself and to the defined data. Standard OpenVMS Access El- ements can be used based on usernames, UICs, and rights identifiers. For DMU dictionary objects, passwords and terminals can also be spec- ified. 3 DIGITAL DATATRIEVE Version 7.2 for OpenVMS Alpha SysteSPD 52.94.03 o Protection with the DATATRIEVE resident dictionary using text files. Text file definitions are subject to the OpenVMS ACL protections, and must be defined and managed by the programmer, using the ap- propriate DIGITAL DATATRIEVE or OpenVMS commands. o Protection with in-memory temporary object definitions In-memory temporary object definitions do not use any protection mechanisms, and bypass those definitions defined by either Oracle CDD/Repository or the textfile dictionary. Remote Data Access DIGITAL DATATRIEVE provides access to data on remote systems in two way as follows: o Takes advantage of the remote data access functionality transpar- ently provided by the individual data base management systems (for example, RMS remote files, Oracle Rdb remote databases) according to their rules. o Requests a DATATRIEVE server to start on the remote system (Open- VMS Alpha and VAX systems or PDP-11) to manage the data definitions and process data remotely. Most operations are performed on the server node and only selected data is exchanged between the requester and the server systems. To work in this way, a DATATRIEVE system (DIG- ITAL DATATRIEVE or DATATRIEVE-11) must be installed on the server node. For the Nonprogrammer DIGITAL DATATRIEVE provides the novice user with a tutorial mode called GUIDE Mode. DIGITAL DATATRIEVE offers ADT (Application Design Tool) for the more experienced user who wants to define data structures. ADT takes the user step-by-step through the definition of a domain based on an RMS data file. 4 DIGITAL DATATRIEVE Version 7.2 for OpenVMS Alpha SysteSPD 52.94.03 If DIGITAL DATATRIEVE is used on the same information by experienced and novice users, the novice user can use the full power of the lan- guage by invoking procedures designed by the more experienced user. For the Programmer DIGITAL DATATRIEVE is a highly structured language that provides au- tomatic access optimization, data type conversion, and data valida- tion. Looping and control structures, such as IF THEN ELSE, BEGIN END, REPEAT, WHILE, CHOICE and FOR (each record) can be combined and nested to create complex, powerful procedures. DIGITAL DATATRIEVE responds to programming errors with clear, explicit error messages. The user can issue an EDIT command to invoke a text editor with an erroneous statement as input text, correct the mistake, and resubmit the command. This editor can be either EDT, TPU, or DEC Language-Sensitive Editor (LSE) and is controlled by a user logical name assignment. Data Definition DIGITAL DATATRIEVE stores the fixed attributes of each record in the record definition. In addition to COBOL-like attributes, DIGITAL DATA- TRIEVE allows validation criteria, fields whose values are computed at run-time, missing value expressions, and default values. DIGITAL DATATRIEVE supports most data types used by DIGITAL Fortran[TM], DIGITAL COBOL, DIGITAL Pascal[TM], DIGITAL C, and DIGITAL BASIC[TM]. DIGITAL DATATRIEVE also supports Varying String and Segmented String data types in Oracle Rdb for OpenVMS databases. 5 DIGITAL DATATRIEVE Version 7.2 for OpenVMS Alpha SysteSPD 52.94.03 Views A VIEW is an alternative description of data. It can be used to al- low a user access to a subset of the data items in a record. It can restrict a user by including only some of the data items in a record, or it can combine data items from several files. Information can be linked through common values (or set linkages in Oracle CODASYL DBMS) to produce complex hierarchical structures. Using a predefined VIEW, a user can access and display data from several files at once with the same commands used on a single file. Data accessed through a VIEW can be printed and modified, but data cannot be stored or erased using a VIEW. Call Interface DIGITAL DATATRIEVE provides a client/server API. The DATATRIEVE Client libraries for OpenVMS and Windows[TM] systems are supplied with the kit of the DATATRIEVE product for OpenVMS systems, and can be copied freely to Client systems. DIGITAL DATATRIEVE can be accessed from the following programs: o Programs linked with DIGITAL DATATRIEVE, residing on the same node and process space where DIGITAL DATATRIEVE resides, and written in high-level languages such as DIGITAL Fortran, DIGITAL C, COBOL, DIG- ITAL BASIC, DIGITAL Pascal, and VAX PL/I. o Programs linked with a DIGITAL DATATRIEVE client library, resid- ing on different nodes or platforms, and written in Visual C++[R], Visual Basic[R] or OpenVMS programming languages. DIGITAL DATATRIEVE automatically converts data from its storage for- mat to the format expected by the program. 6 DIGITAL DATATRIEVE Version 7.2 for OpenVMS Alpha SysteSPD 52.94.03 DIGITAL DATATRIEVE Client for Windows[TM] The DIGITAL DATATRIEVE Client/Server architecture allows existing DIG- ITAL DATATRIEVE users to downsize and distribute their applications and interactive DIGITAL DATATRIEVE operations. The DIGITAL DATATRIEVE Client for Windows, previously a separately or- derable package, is now included with the server software. The DIGITAL DATATRIEVE Client for Windows offers a graphical user in- terface that permits users to: o Browse through the dictionary from a Windows desktop. o Access, modify, and execute their existing DIGITAL DATATRIEVE pro- cedures and dictionary objects. o Access the DIGITAL DATATRIEVE language for interactive queries us- ing a graphical query editor. o Operate on data: display, modify, store and plot. o Interoperate (data import/export) with other PC applications. DIGITAL DATATRIEVE Client for Windows contains the following features, that permit users to: o Use a query-by-example mechanism in the Query Editor. You can spec- ify a query by providing constraints on field values and simple links between fields, without using the graphical query editor. o Define DIGITAL DATATRIEVE objects using specific dialog boxes that guide in the creation of the objects themselves. o Use plots. DIGITAL DATATRIEVE Client for Windows PLOT statements produce graphic results in the client environment. o Use Client/Server TCP/IP transport in addition to DECnet. 7 DIGITAL DATATRIEVE Version 7.2 for OpenVMS Alpha SysteSPD 52.94.03 Storage Methods DIGITAL DATATRIEVE uses a single, consistent syntax to provide full access to information stored in RMS for OpenVMS sequential or indexed files (RMS relative files are supported for queries only), Oracle CO- DASYL DBMS, and Oracle Rdb databases. DIGITAL DATATRIEVE can also pro- vide access to information stored in certain IBM[R] mainframe databases through the use of Oracle Rdb Transparent Gateway for DB2[TM], as well as information stored in ORACLE[R] databases through Oracle Rdb Trans- parent Gateway for ORACLE, and SYBASE[R] databases through Oracle Rdb Transparent Gateway for SYBASE. Data from all these sources can be com- bined into a single VIEW. If access to a Oracle CODASYL DBMS database involves explicit set walk- ing or if records must be manually connected or disconnected from sets, the user can employ DIGITAL DATATRIEVE language features that are spe- cific to Oracle CODASYL DBMS access. However, if the user employs VIEWS or implicit set walking, DIGITAL DATATRIEVE can access information in Oracle CODASYL DBMS databases using the same syntax used for data from an RMS file or Oracle Rdb. Report Generation The DIGITAL DATATRIEVE REPORT statement can produce simple formatted reports without formatting statements. It also allows the user to over- ride the default format when more complex reports are required. Re- ports can either be page-based, printable documents, or table-based formatted data that can be input by a spreadsheet. Column headers and, in page-based reports, page headers containing ti- tle, date, and page numbers are produced automatically. Simple state- ments (AT TOP, AT BOTTOM) create page headers and trailers for con- trol breaks, page breaks or a report summary. DIGITAL DATATRIEVE pro- vides all of its statistical functions and value expressions within the REPORT statement. Reports can be output in a variety of output formats: table reports are produced in DTIF format, page-based reports are produced in DDIF, PostScript[R], and Text formats, and online reports in HTML format. 8 DIGITAL DATATRIEVE Version 7.2 for OpenVMS Alpha SysteSPD 52.94.03 DIGITAL DATATRIEVE Version 7.2 features a HTML report format that en- ables the generation of a HTML file suitable for loading into a stan- dard Web browser. HTML is a markup language used to create hypertext documents that are portable across platforms. Usage of DDIF and PostScript allows a variety of text attributes (size, font types, rendition) to be applied to any part of the report to ob- tain a boardroom-quality output. These attributes, and other print- ing characteristics such as page size and orientation, can be selected from DIGITAL DATATRIEVE through simple statements without requiring the use of a graphical terminal. Simple character-cell based reports are also available, using the Text format. Using the CDA[TM] converter library, DTIF and DDIF reports can be converted to a variety of out- put formats, allowing interoperability with a number of popular ap- plications. The CDA converter library is supplied as part of DIGITAL DATATRIEVE Version 7.2. This packaging eliminates the requirement for a separate installation of CDA software or Motif. PostScript reports can be cre- ated direct through the DATATRIEVE Report Statement. The Report Writer provides two layout tools: a grid printout of the CDA report layout with placement of rows and columns, including those with varying font types, and graphical printout of the layout page, with placement of the different report objects (such as header, footer, body) Reports can be generated from data stored in RMS files, Oracle CODA- SYL DBMS and Oracle Rdb databases, and other databases accessed through the use of the appropriate Oracle Rdb Transparent Gateways or DIGI- TAL DATATRIEVE VIEWS that combine any of these without any change in the syntax of the REPORT statement. Graphics DIGITAL DATATRIEVE includes a number of predefined plots invoked with a single command that takes standard record selection expressions as arguments and creates bar, pie, line, and scattered point plots of the 9 DIGITAL DATATRIEVE Version 7.2 for OpenVMS Alpha SysteSPD 52.94.03 information selected. Plots can be displayed on Digital Equipment Cor- poration Graphics terminals such as the VT340 (refer to the OPTIONAL HARDWARE section for a list of specific supported terminals). Hard copy can be obtained from terminals by attaching a DIGITAL device which sup- ports the SIXEL protocol (for example, LA50, LA75). For users with DECwin- dows, graphics can be displayed in DECterm windows. The DATATRIEVE Client for Windows can display, process, modify, print plots which are created by the plot statement, and export the plot us- ing the clipboard to other applications. Printing to postscript print- ers is also supported. Compatibility DIGITAL DATATRIEVE for OpenVMS VAX systems and DIGITAL DATATRIEVE for OpenVMS Alpha systems are highly compatible, with the exception of the support for floating point definitions typical of the Alpha platform. DIGITAL DATATRIEVE is largely upward compatible from DATATRIEVE-11. DATATRIEVE-11 provides a utility that extracts the contents of a DATATRIEVE-11 dictionary in a format to be entered into Oracle CDD/Repository for OpenVMS. Some syntactic and semantic differences do exist between DATATRIEVE-11 and DIGITAL DATATRIEVE. Procedures copied with the EXTRACT utility can require modification. SOURCE CODE INFORMATION The following source code modules are provided with binary, single- use license options on all magnetic distribution media: o Function definitions o Text definitions o Macro library for function and text definitions o Message text o Sample callable DIGITAL DATATRIEVE programs 10 DIGITAL DATATRIEVE Version 7.2 for OpenVMS Alpha SysteSPD 52.94.03 o DIGITAL DATATRIEVE dictionary object definitions: - Plots - Domains - Records - Procedures - Tables o Language INCLUDE files for the DIGITAL DATATRIEVE Access Block (used by Callable DIGITAL DATATRIEVE) o Language INCLUDE files for literal values, external symbols and rou- tine entry point definitions o Language TEMPLATE file for use with DEC Language-Sensitive Editor (LSE) This source code is provided on an "as is" basis without any warranty of any kind, either express or implied. HARDWARE REQUIREMENTS DIGITAL DATATRIEVE Version 7.2 for OpenVMS Alpha is supported on all hardware configurations referenced in the OpenVMS Operating System for Alpha and VAX, Version 7.1, Software Product Description (SPD 25.01.xx). Other Hardware Required: Mass storage with a minimum of 40,000 disk blocks for DIGITAL DATA- TRIEVE system software for Alpha Systems. Disk Space Requirements (Block Cluster Size = 1) Disk space required for 50,000 blocks installation: (30.7 Mbytes) 11 DIGITAL DATATRIEVE Version 7.2 for OpenVMS Alpha SysteSPD 52.94.03 Disk space required for 35,000 blocks use (permanent): (19.9 Mbytes) 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. Memory Requirements for DECwindows Support The minimum supported memory for this application running in a stan- dalone DECwindows environment with both the client and server execut- ing on that same system is 8M bytes. The performance and memory usage of DECwindows applications are par- ticularly sensitive to system configuration. Less memory may be re- quired on the client system (the system where the software is installed and executed) if the server (the component that displays the appli- cation) resides on another system. More memory may be required on a system with several applications running, or where it may be desir- able to improve the performance of an application. OPTIONAL HARDWARE Graphics can be displayed on VT125, VT240, VT241, VT330, and VT340 ter- minals only. For users with DECwindows, graphics can be displayed in DECterm windows. CLUSTER ENVIRONMENT This layered product is fully supported when installed on any valid and licensed cluster configuration without restrictions. The HARDWARE REQUIREMENTS section of this product's Software Product Description details any special hardware required by this product. 12 DIGITAL DATATRIEVE Version 7.2 for OpenVMS Alpha SysteSPD 52.94.03 SOFTWARE REQUIREMENTS For Systems Using Terminals: o OpenVMS Alpha Operating System Version 6.2 or higher. For Fullname support OpenVMS Alpha Version 6.2 is required. For Workstations Running DECwindows: o OpenVMS Alpha Operating System Version 6.2 or higher. For Fullname support OpenVMS Alpha Version 6.2 is required. For Workstations Running DECwindows Motif: o OpenVMS Alpha Operating System Version 6.2 or higher. For Fullname support OpenVMS Alpha Version 6.2 is required. o DECwindows Motif for OpenVMS Alpha V1.2 OpenVMS Tailoring: The following OpenVMS classes are required for full functionality of this layered product: o OpenVMS Required Saveset o Network Support o Programming Support o System Programming Support o Utilities OPTIONAL SOFTWARE o DECwindows Motif V1.2 or higher o Oracle CODASYL DBMS V6.1 or higher o Oracle Rdb Transparent Gateway for DB2 o Oracle Rdb Transparent Gateway for Oracle 7 & 8 13 DIGITAL DATATRIEVE Version 7.2 for OpenVMS Alpha SysteSPD 52.94.03 o Oracle Rdb Transparent Gateway for SYBASE o DIGITAL DECforms V2.1B or higher o DEC FMS V2.3 or higher o DEC Language-Sensitive Editor or DEC Language-Sensitive Editor/Source Code Analyzer V4.4 or higher o Oracle Rdb for OpenVMS Alpha V6.1 or higher o DECnet/OSI for OpenVMS Alpha Version 6.3 or higher for Fullname sup- port. o In order to use the DATATRIEVE Client for Windows with the DATA- TRIEVE server, the following software is required by the Client: * Microsoft[R] Windows Version 3.1 or higher, or Microsoft Win- dows 95[R], or Microsoft Windows NT[TM]. * A compiler or interpreter that can access DLL libraries (only required for the DIGITAL DATATRIEVE Call Interface). The following software has been tested to support DECnet connections: * On the Server: - DECnet Extensions Version 6.3 for OpenVMS VAX or DECnet Version 6.3 or higher for OpenVMS VAX. * On the Client: - PATHWORKS[TM] Version 5.0F or higher for Windows 3.1 and 3.11. The following software has been tested to support TCP/IP connections: * On the Server: - DIGITAL TCP/IP Services for OpenVMS V4.1A or higher - TGV MultiNet[R] V3.3 14 DIGITAL DATATRIEVE Version 7.2 for OpenVMS Alpha SysteSPD 52.94.03 * On the Client: - PATHWORKS[TM] Version 5.0F or higher for Windows 3.1 and 3.11 - TCP/IP for Windows 3.11 - TCP/IP for Windows 95 - TCP/IP for Windows NT V3.5 - Trumpet V2.1 Rev.F Certain versions of these products depend upon a specific version of the operating system. Please refer to the Software Product Descrip- tion of the product in question to determine which version is required. GROWTH CONSIDERATIONS The minimum hardware/software requirements for any future version of this product may be different from the requirements for the current version. DISTRIBUTION MEDIA This product is distributed on the DIGITAL CD-ROM Software Library for OpenVMS Alpha. The software documentation for this product is available in hardcopy and as part of the OpenVMS Alpha Online Documentation Library on CD- ROM. ORDERING INFORMATION Unlimited Use Software Licenses: QL-0JKA*-** Software Documentation: QA-0JKAA-GZ Client Software Documentation: QA-2W6AA-GZ Software Product Services: QT-0JKA*-** Concurrent Use 15 DIGITAL DATATRIEVE Version 7.2 for OpenVMS Alpha SysteSPD 52.94.03 Software License: QL-898A*-3* Personal Use Software License: QL-898A*-2* * Denotes variant fields. For additional information on available li- censes, services, and media, refer to the appropriate price book. The above information is valid at time of release. Please contact your local DIGITAL office for the most up-to-date information. SOFTWARE LICENSING This software is furnished under the licensing provisions of Digital Equipment Corporation's Standard Terms and Conditions. For more in- formation about DIGITAL's licensing terms and policies, contact your local DIGITAL office. Effective with this release of Version 7.2, the rights to use the DIG- ITAL DATATRIEVE Client module are granted under the server license. This module is now bundled with the server binaries. A separate pur- chase is no longer required. License Management Facility Support: This layered product supports the OpenVMS License Management Facil- ity. License units for this product are allocated on an Unlimited System Use plus Personal Use and Concurrent Use basis. This layered product offers a Personal Use license. Each Personal Use license allows one identified individual to use the layered product. This layered product offers a Concurrent Use license. Each Concurrent Use license allows any one individual at a time to use the layered prod- uct. 16 DIGITAL DATATRIEVE Version 7.2 for OpenVMS Alpha SysteSPD 52.94.03 For more information on the License Management Facility, refer to the OpenVMS Alpha Operating System Software Product Description (SPD 25.01.xx) or the OpenVMS Alpha Operating System documentation. For more information about DIGITAL's licensing terms and policies, con- tact your local DIGITAL office. SOFTWARE PRODUCT SERVICES A variety of service options are available from DIGITAL. For more in- formation, contact your local DIGITAL office. 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 LICENS- ING section of this SPD. © 1997 Digital Equipment Corporation. All rights reserved. [TM] DB2 is a trademark of International Business Machines Corpo- ration. [R] IBM is a registered trademark of International Business Ma- chines Corporation. [R] Microsoft, MS, Visual Basic, Visual C++, Windows, and Windows 95 are registered trademarks of Microsoft Corporation. [R] MultiNet is a registered trademark of TGV, Inc. [R] Motif is a registered trademark of Open Software Foundation, Inc. [R] ORACLE is a registered trademark of Oracle Corp. [TM] Oracle CDD/Repository, Oracle CODASYL DBMS, Oracle Expert, Oracle Rdb, Oracle Rdb Transparent Gateway and Oracle TRACE are trademarks of Oracle Corporation. [R] PostScript is a registered trademark of Adobe Systems Corp. [TM] Windows NT is a trademark of Microsoft Corporation. 17 DIGITAL DATATRIEVE Version 7.2 for OpenVMS Alpha SysteSPD 52.94.03 [TM] AlphaServer, CDA, DATATRIEVE, DEC, DEC BASIC, DEC Fortran, DECforms, DECnet, DECwindows, DIGITAL, FMS, OpenVMS, PATH- WORKS, PDP, ReGIS, VAX, VAX 6000, VAX Pascal, VMS RMS, and the DIGITAL logo are trademarks of Digital Equipment Corpora- tion. 18