Software Product Description ___________________________________________________________________ PRODUCT NAME: HP DATATRIEVE Version 7.3 for OpenVMS Alpha and Integrity Systems SPD 52.94.05 DESCRIPTION HP[TM]DATATRIEVE [TM] for OpenVMS[TM] Alpha[TM] and Integrity[TM] sys- tems is a query, report, and data management tool for the OpenVMS Op- erating System. It provides a uniform access method for data stored by RMS[TM], Oracle Rdb[TM], and Oracle CODASYL DBMS[TM] files on Open- VMS and data residing in other databases accessible by the Oracle Rdb Transparent Gateway[TM] products. Using DATATRIEVE, a novice or experienced user can retrieve or modify data without considering the underlying storage method or physical location. Modes of Operation DATATRIEVE presents information in several different formats. Infor- mation 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 HP 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. DATATRIEVE also provides an efficient way to access infor- mation stored on other Alpha, VAX[TM] or PDP[TM]-11 systems linked by DECnet[TM]. DATATRIEVE can be used interactively to retrieve, modify, store, or delete data using a simple set of commands. Frequently used combina- tions of commands can be stored as named procedures and invoked by name. Programs written in other HP languages can call DATATRIEVE, allowing January 2006 AE-Q42HE-TE HP DATATRIEVE Version 7.3 for OpenVMS Alpha and Integrity Systems SPD 52.94.05 them to be independent of underlying data storage methods and phys- ical location. A HP DECwindows[TM] Motif[R] interface to DATATRIEVE is provided. This allows the user to perform a subset of the DATATRIEVE functions us- ing menu bars, scroll bars, pop-up menus, pull-down menus, and but- tons. The user can also use a navigator to browse through the dictio- nary directories, select objects, and execute commands on them directly from pop-up menus. Data Dictionary DATATRIEVE is dictionary driven. DATATRIEVE has removed the dependen- cies from Oracle CDD/Repository[TM] by supporting a new textfile dic- tionary in addition to Oracle CDD/Repository. DATATRIEVE provides the following two independent dictionary alternatives: o Data Dictionary using Oracle CDD/Repository for OpenVMS. o 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. DATATRIEVE includes commands to store, examine, modify, and delete definitions in the dictionary 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 Repository in order to manage the Oracle CODASYL DBMS databases. DATATRIEVE fully supports CDO format dictionaries, including the abil- ity to access shareable fields. Pieces tracking is also supported for these entities. DATATRIEVE includes full support for DMU format dic- tionaries as well. 2 HP DATATRIEVE Version 7.3 for OpenVMS Alpha and Integrity Systems SPD 52.94.05 Textfile-based Dictionary If Oracle CDD/Repository is present on the system, you can select, at installation time, whether to link DATATRIEVE with Oracle CDD/Repository or not. When Oracle CDD/Repository is linked to 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 DATATRIEVE, the alternative textfile dictionary is enabled. The new textfile dictionary stores the DATATRIEVE object definitions 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 DATATRIEVE extends the use of the DECLARE command to define DATATRIEVE objects. Such objects are temporary (time scope is within a DATATRIEVE session) and do not depend on any dictionary system, since they are stored in memory. Protection o Protection with Oracle CDD/Repository. When 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. o Protection with the DATATRIEVE resident dictionary using text files. 3 HP DATATRIEVE Version 7.3 for OpenVMS Alpha and Integrity Systems SPD 52.94.05 Text file definitions are subject to the OpenVMS ACL protections, and must be defined and managed by the programmer, using the ap- propriate 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 DATATRIEVE provides access to data on remote systems in two way as fol- lows: 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 (DATA- TRIEVE or DATATRIEVE-11) must be installed on the server node. For the Nonprogrammer DATATRIEVE provides the novice user with a tutorial mode called GUIDE Mode. DATATRIEVE offers ADT (Application Design Tool) for the more experi- enced 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. If DATATRIEVE is used on the same information by experienced and novice users, the novice user can use the full power of the language by in- voking procedures designed by the more experienced user. 4 HP DATATRIEVE Version 7.3 for OpenVMS Alpha and Integrity Systems SPD 52.94.05 For the Programmer DATATRIEVE is a highly structured language that provides automatic ac- cess optimization, data type conversion, and data validation. Loop- ing and control structures, such as IF THEN ELSE, BEGIN END, REPEAT, WHILE, CHOICE and FOR (each record) can be combined and nested to cre- ate complex, powerful procedures. 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 as- signment. Data Definition DATATRIEVE stores the fixed attributes of each record in the record definition. In addition to COBOL-like attributes, DATATRIEVE allows validation criteria, fields whose values are computed at run-time, miss- ing value expressions, and default values. DATATRIEVE supports most data types used by HP Fortran[TM], HP COBOL, HP Pascal[TM], HP C, and HP BASIC[TM]. DATATRIEVE also supports Vary- ing String and Segmented String data types in Oracle Rdb for OpenVMS databases. 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. 5 HP DATATRIEVE Version 7.3 for OpenVMS Alpha and Integrity Systems SPD 52.94.05 Call Interface 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. DATATRIEVE can be accessed from the following programs: o Programs linked with DATATRIEVE, residing on the same node and pro- cess space where DATATRIEVE resides, and written in high-level lan- guages such as HP Fortran, HP C, COBOL, HP BASIC, HP Pascal, and PL/I. o Programs linked with a DATATRIEVE client library, residing on dif- ferent nodes or platforms, and written in Visual C++[R], Visual Basic[R] or OpenVMS programming languages. DATATRIEVE automatically converts data from its storage format to the format expected by the program. DATATRIEVE Client for Windows[TM] The DATATRIEVE Client/Server architecture allows existing DATATRIEVE users to downsize and distribute their applications and interactive DATATRIEVE operations. The DATATRIEVE Client for Windows, previously a separately orderable package, is now included with the server software. The DATATRIEVE Client for Windows offers a graphical user interface that permits users to: o Browse through the dictionary from a Windows desktop. o Access, modify, and execute their existing DATATRIEVE procedures and dictionary objects. o Access the DATATRIEVE language for interactive queries using a graph- ical query editor. o Operate on data: display, modify, store and plot. 6 HP DATATRIEVE Version 7.3 for OpenVMS Alpha and Integrity Systems SPD 52.94.05 o Interoperate (data import/export) with other PC applications. 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 DATATRIEVE objects using specific dialog boxes that guide in the creation of the objects themselves. o Use plots. DATATRIEVE Client for Windows PLOT statements produce graphic results in the client environment. o Use Client/Server TCP/IP transport in addition to DECnet. Storage Methods 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 CODASYL DBMS, and Oracle Rdb databases. DATATRIEVE can also provide access to in- formation 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 Transparent Gateway for ORACLE, and SYBASE[R] databases through Oracle Rdb Transparent Gate- way for SYBASE. Data from all these sources can be combined into a sin- gle 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 DATATRIEVE language features that are specific to Oracle CODASYL DBMS access. However, if the user employs VIEWS or im- plicit set walking, DATATRIEVE can access information in Oracle CO- DASYL DBMS databases using the same syntax used for data from an RMS file or Oracle Rdb. 7 HP DATATRIEVE Version 7.3 for OpenVMS Alpha and Integrity Systems SPD 52.94.05 Report Generation The DATATRIEVE REPORT statement can produce simple formatted reports without formatting statements. It also allows the user to override the default format when more complex reports are required. Reports can ei- ther 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. DATATRIEVE provides 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. DATATRIEVE Version 7.3 features a HTML report format that enables the generation of a HTML file suitable for loading into a standard 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 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 output formats, allowing interoperability with a number of popular applications. The CDA Postscript converter is supplied as part of DATATRIEVE Ver- sion 7.3. This packaging eliminates the requirement for a separate in- stallation of CDA software or Motif. PostScript reports can be cre- ated direct through the DATATRIEVE Report Statement. 8 HP DATATRIEVE Version 7.3 for OpenVMS Alpha and Integrity Systems SPD 52.94.05 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 DATA- TRIEVE VIEWS that combine any of these without any change in the syn- tax of the REPORT statement. Graphics DATATRIEVE includes a number of predefined plots invoked with a sin- gle command that takes standard record selection expressions as ar- guments and creates bar, pie, line, and scattered point plots of the information selected. Plots can be displayed on HP Computer Corpora- tion Graphics terminals such as the VT340 (refer to the OPTIONAL HARD- WARE section for a list of specific supported terminals). Hard copy can be obtained from terminals by attaching a HP device which supports 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 DATATRIEVE for OpenVMS VAX systems and DATATRIEVE for OpenVMS Alpha systems are highly compatible, with the exception of the support for floating point definitions typical of the Alpha platform. 9 HP DATATRIEVE Version 7.3 for OpenVMS Alpha and Integrity Systems SPD 52.94.05 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 DATATRIEVE. Procedures copied with the EXTRACT utility can re- quire modification. A user on a DATATRIEVE Version 7.3 can only ready a domain on a re- mote node when DATATRIEVE Version 7.3 is also installed on that node also. This requirement is new to DATATRIEVE Version 7.3. 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 DATATRIEVE programs o DATATRIEVE dictionary object definitions: - Plots - Domains - Records - Procedures - Tables o Language INCLUDE files for the DATATRIEVE Access Block (used by Callable DATATRIEVE) o Language INCLUDE files for literal values, external symbols and rou- tine entry point definitions 10 HP DATATRIEVE Version 7.3 for OpenVMS Alpha and Integrity Systems SPD 52.94.05 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 DATATRIEVE Version 7.3 for OpenVMS Alpha is supported on all hardware configurations referenced in the OpenVMS Operating System for Alpha and Integrity. Software Product Description (SPD 25.01.xx). Other Hardware Required: Mass storage with a minimum of 40,000 disk blocks for DATATRIEVE sys- tem software for Alpha and Integrity Systems. Disk Space Requirements (Block Cluster Size = 1) Disk space required for 50,000 blocks installation: (30.7 Mbytes) 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. 11 HP DATATRIEVE Version 7.3 for OpenVMS Alpha and Integrity Systems SPD 52.94.05 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. SOFTWARE REQUIREMENTS For Systems Using Terminals: o OpenVMS Alpha Operating System Version 6.2 or higher. For Workstations Running DECwindows: o OpenVMS Alpha Operating System Version 6.2 or higher. For Workstations Running DECwindows Motif: o OpenVMS Alpha Operating System Version 6.2 or higher. o DECwindows Motif for OpenVMS Alpha V1.2 o OpenVMS Integrity Operating System 8.2-1 12 HP DATATRIEVE Version 7.3 for OpenVMS Alpha and Integrity Systems SPD 52.94.05 o DECwindows Motif for OpenVMS Integrity V1.5 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 Oracle7 & 8 o Oracle Rdb Transparent Gateway for SYBASE o HP DECforms V2.1B or higher o HP FMS V2.5 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. 13 HP DATATRIEVE Version 7.3 for OpenVMS Alpha and Integrity Systems SPD 52.94.05 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 98[R], or Microsoft Windows NT[TM]. * A compiler or interpreter that can access DLL libraries (only required for the 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: - HP TCP/IP Services for OpenVMS V5.3 or higher * 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 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. 14 HP DATATRIEVE Version 7.3 for OpenVMS Alpha and Integrity Systems SPD 52.94.05 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 HP CD-ROM Software Library for Open- VMS Alpha and the HP Layered Product Library for Integrity. The software documentation for this product is available in hardcopy and as part of the OpenVMS Alpha Online Documentation Library on CD- ROM. The HP Datatrieve for Integrity documentation is the Alpha set plus release notes. 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 Software License: QL-898A*-3* Personal Use Software License: QL-898A*-2* Integrity Per-processor Core License: BA354AA 15 HP DATATRIEVE Version 7.3 for OpenVMS Alpha and Integrity Systems SPD 52.94.05 Integrity Media on Layered Product Library: BA322AA (with Foundation OE Media) BA323AA (with Enterprise OE Media) BA324AA (with Missiion Critical OE Media) (No subscription service offered) Integrity Media designator (required for purchase of SW Updates Services): BA354AA HP Datatrieve VMS I64 Media * 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 HP office for the most up-to-date information. SOFTWARE LICENSING This software is furnished under the licensing provisions of HP Com- puter Corporation's Standard Terms and Conditions. For more informa- tion about HP's licensing terms and policies, contact your local HP office. Effective with this release of Version 7.3, the rights to use the DATA- TRIEVE Client module are granted under the server license. This mod- ule is now bundled with the server binaries. A separate purchase is no longer required. License Management Facility Support: This layered product supports the OpenVMS License Management Facil- ity. License units for the Alpha product are allocated on an Unlimited Sys- tem Use plus Personal Use and Concurrent Use basis. The Alpha layered product offers a Personal Use license. Each Personal Use license allows one identified individual to use the layered prod- uct. 16 HP DATATRIEVE Version 7.3 for OpenVMS Alpha and Integrity Systems SPD 52.94.05 The Alpha layered product offers a Concurrent Use license. Each Con- current Use license allows any one individual at a time to use the lay- ered product. Integrity-specific info: License type for Integrity is "per-processor core license". One PCL license is required for each processor core running OpenVMS. The media product number must be included in a software layered prod- uct order if SW Updates service (delivery of update media/online doc- umentation) is planned. This product number is used for update only. The initial delivery of media is on the OpenVMS Integrity Layered Prod- uct Library, included with the Operating Environment Media: BA323AA (FOE), BA323AA (EOE), BA324AA (MCOE). 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 HP's licensing terms and policies, contact your local HP office. SOFTWARE PRODUCT SERVICES A variety of service options are available from HP. For more infor- mation, contact your local HP office. SOFTWARE WARRANTY Warranty for this software product is provided by HP with the purchase of a license for the product as defined in the SOFTWARE LICENSING sec- tion of this SPD. © 2006 HP Computer Corporation. All rights reserved. [TM] DB2 is a trademark of International Business Machines Corpo- ration. 17 HP DATATRIEVE Version 7.3 for OpenVMS Alpha and Integrity Systems SPD 52.94.05 [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. [TM] AlphaServer, CDA, DATATRIEVE, DEC, DEC BASIC, DEC Fortran, DECforms, DECnet, DECwindows, Compaq, FMS, OpenVMS, PATH- WORKS, PDP, ReGIS, VAX, VAX 6000, VAX Pascal, VMS RMS, and the Compaq logo are trademarks of HP Computer Corporation. 18