VSI Datatrieve Installation Guide

Software Version:
VSI Datatrieve T7.4-3
Operating System and Version:
VSI OpenVMS Alpha Version 8.4-2L1 or higher
VSI OpenVMS IA-64 Version 8.4-1H1 or higher
VSI OpenVMS x86-64 Version 9.2-3 or higher

Preface

This manual describes how to install the Datatrieve software and use the Datatrieve User Environment Test Packages (UETPs).

This manual does not contain any release note information. Printed release notes for Datatrieve are found in the VSI Datatrieve Version T7.4-3 Release Notes. Release notes for Datatrieve are also shipped with the installation kit and can be printed during the installation procedure.

1. About VSI

VMS Software, Inc. (VSI) is an independent software company licensed by Hewlett Packard Enterprise to develop and support the OpenVMS operating system.

2. Intended Audience

This manual is intended for persons responsible for installing and maintaining Datatrieve software. To install the software, you should be familiar with VMSINSTAL, the command procedure used to install software products in the OpenVMS environment. For information on VMSINSTAL, refer to the relevant section in the VSI OpenVMS System Manager's Manual, Volume 1: Essentials.

3. Document Structure

This manual consists of five chapters:

4. Related Documents

For further information on the topics covered in this manual, you can refer to the following documentation:

  • VSI Datatrieve User Guide

    Describes how to use Datatrieve interactively. The manual includes information on using Datatrieve to manipulate data and on using Datatrieve with forms, relational databases, and database management systems. It also describes how to improve performance and how to work with remote data.

  • VSI Datatrieve Reference Manual

    Contains reference information for Datatrieve.

5. VSI Encourages Your Comments

You may send comments or suggestions regarding this manual or any VSI document by sending electronic mail to the following Internet address: . Users who have VSI OpenVMS support contracts through VSI can contact for help with this product.

6. OpenVMS Documentation

The full VSI OpenVMS documentation set can be found on the VMS Software Documentation webpage at https://docs.vmssoftware.com.

7. Conventions

The following conventions are used in this manual:

ConventionMeaning

Ctrl/x

A sequence such as Ctrl/x indicates that you must hold down the key labeled Ctrl while you press another key or a pointing device button.

A horizontal ellipsis in examples indicates one of the following possibilities:
  • Additional optional arguments in a statement have been omitted.

  • The preceding item or items can be repeated one or more times.

  • Additional parameters, values, or other information can be entered.

A vertical ellipsis indicates the omission of items from a code example or command format; the items are omitted because they are not important to the topic being discussed.

()

In command format descriptions, parentheses indicate that you must enclose the options in parentheses if you choose more than one.

[]

In command format descriptions, brackets indicate optional choices. You can choose one or more items or no items. Do not type the brackets on the command line. However, you must include the brackets in the syntax for OpenVMS directory specifications and for a substring specification in an assignment statement.

|

In command format descriptions, vertical bars separate choices within brackets or braces. Within brackets, the choices are options; within braces, at least one choice is required. Do not type the vertical bars on the command line.

Bold type

Bold type represents the name of an argument, an attribute, or a reason. It also represents the introduction of a new term.

Italic type

Italic type indicates important information, complete titles of manuals, or variables. Variables include information that varies in system output (Internal error number), in command lines (/PRODUCER= name), and in command parameters in text (where dd represents the predefined code for the device type).

UPPERCASE TYPE

Uppercase type indicates the name of a routine, the name of a file, or the abbreviation for a system privilege.

Monospace type

Monospace type indicates code examples and interactive screen displays.

In the C programming language, monospace type in text identifies the following elements: keywords, the names of independently compiled external functions and files, syntax summaries, and references to variables or identifiers introduced in an example.

  • Bold
  • monospace
  • type

Bold monospace type indicates a command, command qualifier, or statement.

-

A hyphen at the end of a command format description, command line, or code line indicates that the command or statement continues on the following line.

Numbers

All numbers in text are assumed to be decimal unless otherwise noted. Nondecimal radixes—binary, octal, or hexadecimal—are explicitly indicated.

8. References to Products

The VSI Datatrieve documentation to which this manual belongs often refers to products by their abbreviated names:

  • Oracle Common Data Dictionary/Plus software is referred to as CDD/Plus.

  • VSI Datatrieve software is referred to as Datatrieve.

  • Oracle Rdb/VMS software is referred to as Rdb/VMS.

  • VSI Terminal Data Management System software is referred to as TDMS.

  • VSI Forms Management System software is referred to as FMS.

This manual also uses the term relational database or relational source to refer to Oracle Rdb/VMS.

Chapter 1. Pre-Installation Considerations

Warning

The content of this manual does not yet reflect the VSI Datatrieve T7.4-3 migration from the Common Data Dictionary (CDD) to the VSI Data Dictionary (VDD).

This chapter includes important installation considerations that you must be aware of before you install VSI Datatrieve T7.4-3. Read this chapter carefully before you proceed.

To prepare your system for installing VSI Datatrieve, you must perform the following tasks:

  • Verify that your system has enough memory and available disk space to install and use Datatrieve.

  • Register the Product Authorization Key (PAK) that is shipped with this version of Datatrieve.

  • Verify that your system has the correct versions of the optional and required software you will be using with Datatrieve.

  • Check your system and the installing account to ensure that parameters and quotas are sufficient for installing and using Datatrieve.

This chapter tells you what actions to take to prepare your system for installing VSI Datatrieve.

1.1. Prerequisite Hardware

To install this version of VSI Datatrieve, you must have 16,000 blocks of storage available on the system disk. After installation, Datatrieve requires a maximum of 11,000 blocks of disk space if you install all optional software with Datatrieve. To check the number of blocks of storage available on the system disk, use the SHOW DEVICES command at the DCL prompt.

1.2. OpenVMS Licensing Management Facility (LMF)

This version of VSI Datatrieve supports the License Management Facility provided by OpenVMS. See the VSI OpenVMS License Management Utility Guide for more information.

You should register the information contained in the Product Authorization Key (PAK) that is shipped with Datatrieve before you begin the installation. You can register by using the OpenVMS License command procedure using the following command:

$ @SYS$UPDATE:VMSLICENSE

You can also use the LICENSE REGISTER command to register the information contained in the PAK. Both methods are described in the VSI OpenVMS License Management Utility Guide.

Datatrieve asks you early in the installation procedure whether or not you have registered and loaded an authorization key. You can install this version of Datatrieve without the authorization key information, but you cannot run Datatrieve or the Installation Verification Procedure (IVP).

1.3. Prerequisite Software

You must have the correct versions of the optional and required software products you will be using with Datatrieve. Install those products in the order specified in Section 1.3.3, ''Order of Product Installation''.

1.3.1. Required Software Products

This version of Datatrieve is a complete kit. You do not need any previous versions of Datatrieve to install it.

To install VSI Datatrieve T7.4-3, you must be running one of the following versions of OpenVMS:

  • VSI OpenVMS Alpha Version 8.4-2L1 or higher.

  • VSI OpenVMS IA-64 Version 8.4-1H1 or higher.

  • VSI OpenVMS x86-64 Version 9.2-3 or higher.

To check which version of VSI OpenVMS is currently installed on your system, use the SHOW SYSTEM command at the DCL prompt.

You must have Version 4.1 of Oracle CDD/Plus before you can install VSI Datatrieve. To check which version of CDD/Plus is currently installed on the system, use the following command:

$ DICTIONARY OPERATOR

The CDO banner gives the version of CDD/Plus currently installed on your system. For example:

Welcome to CDO Vl.0
The CDD/Plus V4.l User Interface
Type HELP for help
CDO>

1.3.2. Optional Software Products

The following optional products can be used along with VSI Datatrieve:

  • DECwindows

  • Oracle DBMS

  • Oracle Rdb/VMS

  • VSI TDMS

  • VSI FMS

  • VSI Language-Sensitive Editor (LSE)

If an optional product is on the system but is not the version required by Datatrieve, the installation procedure will not install the User Environment Test Package (UETP) for that product. Note that not all optional software products have a UETP.

1.3.3. Order of Product Installation

When you install required and optional software products with Datatrieve, you should install these products in the following order:

  1. DECwindows (Optional)

    If you plan to use Datatrieve with DECwindows, install DECwindows before installing other required or optional software products. If you choose to install DECwindows at a later date, you must reinstall Datatrieve to take advantage of DECwindows features.

  2. LSE (Optional)

    If you plan to use LSE with Datatrieve, you should install LSE after optionally installing DECwindows and before installing other required or optional software products. However, if you choose to install LSE at a later date, the Datatrieve installation procedure provides you with the option of performing a modified Datatrieve installation to provide Datatrieve support for LSE at that time.

  3. CDD/Plus

  4. Forms products such as TDMS and FMS (Optional)

  5. Database products such as Oracle DBMS and Rdb/VMS (Optional)

    Install Oracle DBMS and Rdb/VMS before installing Datatrieve to ensure that the installation includes sample databases and User Environment Test Packages. You do not have to install these optional database products before Datatrieve to use the products with Datatrieve.

  6. VSI Datatrieve

1.4. OpenVMS Cluster Considerations

The following considerations pertain to OpenVMS clusters:

  • If you installed a version of Datatrieve lower than Version 3.2 on an OpenVMS cluster, the installation procedure placed files in SYS$SPECIFIC:[DTR]. Before installing any version of Datatrieve higher than Version 3.1, you must delete the old files in SYS$SPECIFIC:[DTR] and the SYS$SPECIFIC:[DTR] directory itself.

    Follow these steps to delete the files and the directory:

    1. Log in to a privileged account on the system on which the previous version of Datatrieve was installed.

    2. Delete all files from the directory using the following command:

      $ DELETE SYS$SPECIFIC: [DTR]*.*;*
    3. Delete the directory itself using the following command:

      $ DELETE SYS$SPECIFIC: [OOOOOO]DTR.DIR;*
  • This installation procedure lets you install Datatrieve only on a system-rooted device. Whether you are installing Datatrieve on an OpenVMS cluster or in a non-clustered environment, the installation procedure places the files that it generates in SYS$COMMON, not in SYS$SPECIFIC. The installation defines the logical name DTR$LIBRARY as SYS$COMMON:[DTR].

1.5. Preparing Your System and the Installing Account

This section tells you which characteristics of your system and installing account need to be checked before you install Datatrieve. These characteristics include process quotas, access control privileges to CDD$TOP, and system parameters. Instructions are given for checking and modifying the relevant characteristics of your system and installing account.

1.5.1. Required Parameters

You should check the following parameters to make sure they are sufficient for installing Datatrieve:

  • Open file limit (FILLM parameter)

  • Enqueue quota limit (ENQLM parameter)

  • Global pages and global sections (GBLPAGES and GBLSECTIONS parameters)

  • Command line interpreter symbol table (CLISYMTBL parameter)

1.5.1.1. Open File Limit (FILLM Parameter)

For the Datatrieve installation procedure to run successfully, the account used to install Datatrieve should have a minimum open file limit (FILLM parameter) of 30. To check the current open file limit, use the SHOW PROCESS/QUOTAS command at the DCL prompt. In addition; check the documentation of products layered on Datatrieve to see if the open file limit should be further increased.

If the open file limit is too low, VMSINSTAL generates the following message at the beginning of the installation:

%VMSINSTAL-W-LOWQUOTA, One or more account quotas may be too low.

The installation continues, but the Installation Verification Procedure (IVP) that runs as part of this installation may fail.

Users running Datatrieve should also have an open file limit of 30. Users running large applications that open many files may need this value increased further through the Authorize Utility.

Users who exceed their open file limit may see a meaningless display on their screen when they start Datatrieve. They may receive a message without further explanation, such as "quota exceeded" or "ACP file access failed."

Note

Users who are close to or exceed their disk quota limit generate the %SYSTEM-F-ABORT message when they try to invoke Datatrieve. This error occurs because Datatrieve tries to open a work file and cannot. Users with default disks mounted read-only receive the same error message.

1.5.1.2. Enqueue Quota Limit (ENQLM Parameter)

You may need to be concerned with the overall number of locks in the system and the enqueue quota limit (ENQLM parameter) assigned to individual users. To check the current enqueue quota, use the SHOW PROCESS/QUOTAS command at the DCL prompt.

An ENQLM of about 200 locks is sufficient for most activities, including running the Datatrieve User Environment Test Packages (UETPs). However, users running applications that access large databases may require more than 200 locks. If such users do not have more than 200 locks, they receive a quota exceeded message from the OpenVMS system. This message does not mention the ENQLM parameter or locks. You can change the ENQLM by using the Authorize Utility.

Rdb/VMS, in particular, uses many locks and may require raising the ENQLM in the following circumstances:

  • If the account you use to install Datatrieve has an ENQLM under 500, the installation cannot build the sample Rdb/VMS database. The installation continues without building the sample database. To include the sample Rdb/VMS database, you must reinstall Datatrieve using an account with an ENQLM of 500 or more.

  • To use the Rdb/VMS demo, you need an account with an ENQLM of 600.

  • You may receive the quota exceeded message when using Datatrieve with Rdb/VMS. To continue, finish unnecessary databases or selected parts of the database using the FINISH command or exit and reenter Datatrieve. If you still receive the quota exceeded message, have your system manager raise your account enqueue quota limit.

1.5.1.3. Global Pages and Global Sections (GBLPAGES and GBLSECTIONS Parameters)

If you plan to install various Datatrieve images as SHARED, you need sufficient global pages and global sections. The installation procedure asks you about four images: DDMFxx, DTR32xx, DTRSHRxx, and DTRMSGS. The xx at the end of the file name refers to the optional suffix that you can specify in the installation procedure. See Section 2.5.4, ''Specifying Suffixes for Multiple Installations of This Version of VSI Datatrieve'' for more information. You do not have to install all of these images; you only need sufficient global pages and global sections for those you wish to install.

Datatrieve automatically installs two images as SHARED: DTRHELP and DTR$CDDTSHR. You need sufficient global pages and global sections for these images.

The following table indicates the requirements for the GBLPAGES and GBLSECTIONS parameters for the image files that are part of this version of Datatrieve:

FileGlobal SectionsGlobal Pages
DDMFxx1143
DTR32xx1204
DTRSHRxx5952
DTRMSGS1105
DTRHELP161
DTR$CDDTSHR4791

To display the current GBLSECTIONS and GBLPAGES parameters, you can use the SHOW GBLSECTIONS and SHOW GBLPAGES commands of the System Generation Utility (SYSGEN). Note, however, that to modify these parameters, you should use the AUTOGEN Utility.

If the global pages and global sections already on your system are not sufficient, you will need to modify the parameters before installing Datatrieve. To modify these parameters, follow the instructions in the relevant section in the VSI OpenVMS System Manager's Manual, Volume 2: Tuning, Monitoring, and Complex Systems.

1.5.1.4. Command Line Interpreter Symbols Table (CLISYMTBL) Limits

The Datatrieve installation procedure creates a number of DCL symbols. To ensure that your system can accommodate the number of symbols created at installation time, set the CLISYMTBL limit to at least 250.

To check the current CLISYMTBL limit, use the SHOW CLISYMTBL command while in SYSGEN. To modify this parameter, run SYSGEN as follows:

$ RUN SYS$SYSTEM:SYSGEN
SYSGEN> SET CLISYMTBL 250
SYSGEN> WRITE ACTIVE
SYSGEN> WRITE CURRENT

You will receive a message indicating that the system has been modified. You can then exit SYSGEN. For more information on SYSGEN, see the relevant section in the VSI OpenVMS System Manager's Manual, Volume 2: Tuning, Monitoring, and Complex Systems.

If you do increase the CLISYMTBL limit to 250, you may reduce it to the normal level after the installation is completed.

1.5.2. CDD/Plus Considerations

Before you install Datatrieve, you should perform the following tasks:

  • Check the contents of the dictionary directory CDD$TOP.DTR$LIB for user definitions and subdirectories. Back these up if they exist.

  • Make sure the installation procedure has all access privileges to CDD$TOP.

The following two sections explain these procedures.

1.5.2.1. Effect of Installation Procedure on Existing DTR$LIB Directory

The directory CDD$TOP.DTR$LIB is reserved for use by VSI. The installation procedure builds, or rebuilds, this directory each time you install Datatrieve. The directory should contain only directories that contain definitions for the plots and sample domains, records, and tables that are shipped with the product. Users should not create any dictionary objects or directories that have DTR$LIB as part of their path names.

When the installation procedure rebuilds DTR$LIB, it deletes the existing DTR$LIB hierarchy. Therefore, you should check that Datatrieve users have not placed their own definitions either in DTR$LIB or in any part of its substructure. Extract user definitions you want to save and redefine them in another directory.

1.5.2.2. Required Privileges to CDD$TOP

As the installation procedure builds or rebuilds DTR$LIB, the procedure must have all access control privileges to CDD$TOP. You can check these privileges with the following command sequence:

$ SET PROCESS/PRIVILEGE=NOBYPASS
$ RUN SYS$SYSTEM:DMU
DMU> SHOW PROTECTION CDD$TOP

The resulting privileges list should include the following:

CONTROLEXTENDLOCAL_DELETE
DTR_EXTENDFORWARDPASS_THRU
DTR_MODIFYGLOBAL_DELETESEE
DTR_READHISTORYUPDATE
DTR_WRITE  

After checking the privileges list, type Exit and press the Return key to return to DCL command level.

If any of the required privileges are not available, or if they are denied or banished, you must change the access control list (ACL) entry to provide all privileges for the duration of the installation. One way you can do this is to enter the following sequence of commands:

$ SET PROCESS/PRIVILEGES=BYPASS
$ RUN SYS$SYSTEM:DMU
DMU> SET PROTECTION/GRANT=ALL/UIC=[l,4]­
DMU> /POSITION=l CDD$TOP
DMU> EXIT
$ SET PROCESS/PRIVILEGES=NOBYPASS

If you are using an account other than [1,4] for the installation, replace [1,4] with the UIC of that account.

After the installation procedure is complete, you can remove the ACL entry with the following command sequence:

$ SET PROCESS/PRIVILEGES=BYPASS
$ RUN SYS$SYSTEM:DMU
DMU> DELETE/PROTECTION/POSITION=l CDD$TOP
DMU> EXIT
$ SET PROCESS/PRIVILEGES=NOBYPASS

For your convenience during future installations of Datatrieve, you might want to create command files containing these two sequences of commands.

Note

The command procedure VMSINSTAL removes BYPASS privilege. Therefore, you cannot give yourself BYPASS privilege as a substitute for these sequences.

1.5.3.  Effect of Installation Procedure on the Logical DTR$LIBRARY

The installation defines the logical DTR$LIBRARY as SYS$COMMON:[DTR]. If the installation fails, DTR$LIBRARY may be left deassigned, and you must redefine it. To redefine the logical, use either the ASSIGN command or the DEFINE command, as follows:

$ ASSIGN/SYSTEM SYS$COMMON:[DTR] DTR$LIBRARY
$ DEFINE/SYSTEM DTR$LIBRARY SYS$COMMON:[DTR]

1.5.4. More Than One Installation of This Version of Datatrieve

You can install this version of Datatrieve a number of times to produce different sets of images and files. Note, however, that you cannot install multiple different versions of Datatrieve. For example, the installation procedure could be run first to install VSI Datatrieve T7.4-3 with TDMS. You could then install VSI Datatrieve T7.4-3 a second time to support FMS. The resulting images and file names would be differentiated by a suffix added to the default names. The installation procedure prompts you to choose this suffix.

The suffix you specify will be given to the following files created during installation. The two letters xx at the end of a file name stand for the 1- to 26-character suffix you specify:

  • SYS$SHARE:DTRSHRxx.EXE

  • SYS$SYSTEM:DTR32xx.EXE

  • SYS$SYSTEM:DDMFxx.COM

  • SYS$SYSTEM:DDMFxx.EXE

  • DTR$LIBRARY:DTRBLDxx.COM

  • DTR$LIBRARY:DTRLIBxx.OLB

  • DTR$LIBRARY:DTRFNDxx.MAR

  • DTR$LIBRARY:DTRFNDxx.OBJ

  • DTR$LIBRARY:DTRFUNxx.OLB

  • SYS$STARTUP:DTRSTUPxx.COM

Note

The installation procedure does not append the xx suffix to all images and files. See the restrictions regarding the DTR$LIB:TERMSERVE.OLB file in the release notes for more information.

Chapter 2. VSI Datatrieve Installation Procedure

Before you install VSI Datatrieve T7.4-3, make sure that your system meets all requirements listed in the previous chapter.

The installation procedure is described in the sections that follow. Note that as the procedure progresses, the installation command procedure sends questions to your screen to guide you through the installation process. The sections that follow explain these questions in detail.

After you answer questions from the installation procedure, installation of Datatrieve takes approximately 10 to 30 minutes.

2.1. Starting the Installation Procedure

Log in under a privileged account, such as the system manager's account.

Invoke the command procedure VMSINSTAL. In the command line, include the name of the device on which the distribution medium is to be mounted. Be sure to type a colon after the device name. Include the qualifier OPTIONS N if you want to print or display release notes during the installation (see Section 2.3, ''Answering Questions About Release Notes'' for more information). If you do not want to print or display release notes, do not include OPTIONS N.

The following example shows how to install VSI Datatrieve T7.4-3 with the OPTIONS N qualifier on device MTA0. Be sure to replace MTA0 with the name of the specific device you are using:

$ @SYS$UPDATE:VMSINSTAL DTR050 MTA0: OPTIONS N

Note that you can specify the AUTOANSWERBACK option when you invoke VMSINSTAL. This option creates the file SYS$UPDATE:DTR050.ANS, which contains the installation questions and your responses. This file can then be used in subsequent installations. Refer to the relevant section in the VSI OpenVMS System Manager's Manual, Volume 1: Essentials for more information about VMSINSTAL.

The AUTOANSWERBACK option is not recommended for Datatrieve installations. Questions asked during the Datatrieve installation are based on the system environment. The system environment at the time of the original installation determines which questions the installation procedure will ask. When you proceed with a subsequent installation, the questions change according to changes in the system environment. Thus, if you specify AUTOANSWERBACK during the original installation, you probably will not receive the appropriate questions during the subsequent installation.

The installation procedure prompts you for input at various times. Whenever you are prompted for input, you can type a question mark (?) symbol for help.

Most installation prompts include a default response in brackets. To enter the default bracketed response, you can either explicitly enter that response or press the Return key.

Before the installation procedure begins, VMSINSTAL checks if you are logged in to the system account. If not, you receive the following warning message:

%VMSINSTALL-W-NOTSYSTEM, You are not logged in to the system account.

In addition, before the installation procedure begins, VMSINSTAL checks for active processes on the system. If your DECnet network is running, you receive the following warning message:

%VMSINSTAL-W-DECNET, Your DECnet network is up and running.

If there are still users on the system, you receive the following warning message with a list of process names:

%VMSINSTAL-W-ACTIVE, The following processes are still active:
.
.
.

The list of the process names is followed by this question:

* Do you want to continue anyway? [NO]

If you want to stop the installation process to get all users off the system, enter No or press the Return key.

At the start of the VMSINSTAL procedure, you need to answer the following question:

* Are you satisfied with the backup of your system disk [YES]?

After you have performed the necessary backup, enter Yes or press the Return key. If you reply with No, the installation stops.

2.2. Mounting the Distribution Medium

VMSINSTAL displays the following message:

Please mount the first volume of the set on MTA0:
* Are you ready?

Type Yes after you mount the distribution medium.

The installation procedure then checks if the following necessary conditions for the installation have been fulfilled:

  • The target of the installation is SYS$COMMON on the system-rooted device.

  • A compatible version of OpenVMS is installed.

  • At least 16,000 blocks are available on the system disk.

  • A compatible version of CDD/Plus is installed on the system.

  • The installation procedure has ACL access rights to CDD$TOP.

If any of these conditions has not been fulfilled, the installation procedure displays a message describing the problem. After satisfying the requirement, you can rerun the installation procedure by invoking the command procedure VMSINSTAL again.

Note

Systems that do not have DECnet cannot support the Datatrieve remote server. On such systems, the installation procedure next displays a message noting that it cannot define a DECnet object for the remote server. If you later install DECnet, you will then need to define a DECnet object for the remote server. See Section 3.4, ''DECnet Considerations (Phase IV Only)'' for more information.

This ends the initial series of questions generated by VMSINSTAL. If you have successfully completed this portion of the installation, a message similar to the following is displayed:

The following products will be processed:
   DTR V5.0
      Beginning installation of DTR V5.0 at 8:15
VMSINSTAL-I-RESTORE, Restoring product saveset A...

The installation continues with questions about release notes.

2.3. Answering Questions About Release Notes

If you specified the qualifier OPTIONS N at the beginning of the installation, the procedure offers these options regarding VSI Datatrieve T7.4-3 online release notes:

Release Notes Options:

1.  Display release notes
2.  Print release notes
3.  Both 1 and 2
4.  Copy release notes to SYS$HELP
5.  Do not display, print or copy release notes

* Select option [2]:

Enter the number corresponding to the option you choose. If you enter option 2 or 3, the procedure prompts you for the printer queue name. It then prints a message showing that the job has been queued for printing:

*Queue name [SYS$PRINT]:

Job DTROXX (queue YOURSYS_DQS$PRINT, entry 1248) started on
YOURSYS_DQS$PRINT

The procedure now asks if you want to continue the installation:

*Do you want to continue the installation [N]?

If you want to continue, enter Yes.

If you selected one of the print options, you must wait until the release notes finish printing before you enter the No or press the Return key. If you did not select a print option and wish to exit, enter No or press the Return key.

2.4. Answering Questions About the OpenVMS Licensing Management Facility (LMF)

VSI Datatrieve T7.4-3 supports the License Management Facility provided by OpenVMS. The installation procedure asks whether you have registered and loaded a Product Authorization Key (PAK) as required:

         Product:       DTR or DTR-USER
         Producer:      DEC
         Version:       5.0
         Release Date:  27-OCT-1989

* Does this product have an authorization key registered and loaded?

If you answer Yes, the procedure continues. If you answer No, you receive the following message:

You have not registered the LMF authorization key as required.
The DATATRIEVE installation will continue. However, you
cannot run the product until you register the license authorization
key.

When the DATATRIEVE installation is completed, please register the
authorization key using the following command:

$ @SYS$UPDATE:VMSLICENSE

The IVP cannot be run until the authorization key is registered.
However, the IVP command file will be put in the same directory
as the UETPs. Once you register the authorization key, you may
run the IVP by entering DATATRIEVE and issuing the following
command:

DTR> @SYS$COMMON: [SYSTEST.DTR]DTR$IVP.DTR

The installation continues with a series of Datatrieve-specific questions.

2.5. Answering Questions During the Datatrieve Installation

The installation procedure asks you a number of questions concerning default installation, forms management products, multiple Datatrieve installations, and Datatrieve files. The following sections give examples of these questions.

2.5.1. Installing Datatrieve With the Default Answers

The installation procedure now asks if you want to install Datatrieve using default answers for all questions.

Note

While this question may simplify the installation procedure, it may not be appropriate for your situation. For example, if your system supports more than one installation of this version of Datatrieve, you should not select the default installation option. Read the summary of the default responses that follows the question before you choose this option.

The installation procedure prompts you with the following question:

*Do you want to use default answers for all questions [No]?

If you type Yes, the Datatrieve installation procedure automatically does the following:

  • Performs a complete installation of Datatrieve; it will not allow a partial installation to provide Datatrieve support for LSE.

  • Checks your system for a forms management product. If Datatrieve does not find a forms product, the automatic installation procedure provides no forms management support.

  • If a forms product already exists on the system, Datatrieve:

    • Supplies FMS support, if only FMS is on the system

    • Supplies TDMS support, if only TDMS is on the system

    • Supplies only TDMS support, if both FMS and TDMS are found on the system

  • Does not prompt you for the unique 1- to 26-character suffix that identifies the DTR32xx.EXE image of this installation. Note that if you have already installed this version of Datatrieve and did not supply a suffix during that installation, you will need a suffix to differentiate the image of that prior installation from the image currently being installed. In such a case, the default installation procedure is not appropriate.

  • Does not prompt you for the default image to be used with the Datatrieve DCL command and DCL help. The default image will be DTR32.

  • Does not supply the Datatrieve object library in DTR$LIBRARY. This means that you will not be able to relink this image of Datatrieve.

  • Checks if the Datatrieve remote server has been defined by a previous installation of Datatrieve. The Datatrieve remote server is called the Distributed Data Manipulation Facility (DDMF).

    When the installation procedure checks for a previously defined DDMF:

    • If there is no remote server or if the remote server is obsolete, the DDMF files from this installation become the remote server for Datatrieve.

    • If there is a current remote server already on the system, the default installation procedure uses that as the remote server for this installation of Datatrieve.

  • Checks if there is a current version of NEWUSER.COM available.

    When the installation procedure checks NEWUSER.COM:

    • If NEWUSER.COM is not current, Datatrieve automatically replaces the NEWUSER.COM file.

    • If the NEWUSER.COM is current, Datatrieve does not replace the new user file.

  • Checks the status of the DCL help for Datatrieve. If DCL help is unavailable or out-of-date, Datatrieve automatically updates DCL help.

  • Installs DTRSHR.EXE, DTRMSGS.EXE, DTR32.EXE, and DDMF.EXE (if applicable) as SHARED.

  • Installs DTRHELP and DTR$CDDTSHR as SHARED.

  • Supplies the plot definitions for the current version.

  • Does not supply the optional text and message files, sample programs, and callable programming aids that can be tailored at the installed site.

  • Deletes all obsolete files.

  • Purges files replaced by this installation.

If you type No, the installation procedure continues with the questions about LSE.

2.5.2. Installing With Support for VSI Language-Sensitive Editor (LSE)

To use LSE with Datatrieve, LSE must already be installed on your system. If LSE is not already installed on your system, you see the following message on your screen:

    **************************************************************

    The VSI Language-Sensitive Editor is not installed on your
    system. To have the VSI Language-Sensitive Editor support,
    you must:

        1.  Install the VSI Language-Sensitive Editor
        2.  Install or reinstall this product

    **************************************************************

* Do you want to continue the installation [No]?

If you enter Yes, the installation continues; however, you will not be able to use LSE with Datatrieve. If you enter the default value by entering No or by pressing the Return key, the installation aborts, giving you the opportunity to install LSE on your system. Once LSE is installed, you can begin the Datatrieve installation procedure from the beginning. If LSE is already installed on your system, you will be prompted with the following:

   LSE is installed on your system.

   You now have the following options:

        1.  Do a complete VSI DATATRIEVE installation including
            VSI DATATRIEVE support for LSE.
        2.  Do only VSI DATATRIEVE support for LSE without
            installing VSI DATATRIEVE.

* Select option [1]:

If you want to install a new version of Datatrieve (including LSE support), select option 1. If you want only to provide Datatrieve support for LSE (without installing a new version of Datatrieve), select option 2. If you select option 2, this installation will terminate after Datatrieve support for LSE is provided.

2.5.3. Installing With Support for Forms Products

Each installation of Datatrieve on a system can support only one of two forms management products. These products are:

  • VSI TDMS (Terminal Data Management System)

  • VSI FMS (Forms Management System)

A series of questions determines which product Datatrieve will support for the image currently being installed.

The installation procedure checks which forms management products are on the system. If no forms products are found (or only lower versions of TDMS or FMS not supported by Datatrieve are found), the installation procedure displays the following message:

    **************************************************************

    No Forms Management product has been found on this
    system. If desired, the installation may be aborted
    at this point to install a Forms Management product.
    If the installation continues, VSI DATATRIEVE will
    be built without Forms Management support.

    **************************************************************

* Do you wish to continue with the installation [YES]?

If you type Yes or press the Return key, the installation continues with the series of questions about more than one installation of this version of Datatrieve. See Section 2.5.4, ''Specifying Suffixes for Multiple Installations of This Version of VSI Datatrieve'' for more information.

If you type No, the installation aborts, giving you an opportunity to install a forms product on your system.

If one or more forms products are found, you receive a listing of the products on your system, followed by a message and question similar to the following:

    VSI DATATRIEVE can be built to support any one
    of these products, or, if desired, VSI DATATRIEVE
    can be built without support of any of these Forms
    Management products.

* Do you want DATATRIEVE to support one of these products [YES]?

If you do not want forms support, enter No. The installation procedure resumes with questions on suffixes and more than one installation of this version of Datatrieve.

If you do want forms support, enter Yes or press the Return key. Then, for each forms product on the system, you are asked if you want Datatrieve to support this forms product. Remember that each installation of Datatrieve can support only one forms product. After you enter Yes to specify support for one forms product, you do not receive questions about the other forms products.

For example, if you have both TDMS and FMS on the system, you receive the following question first:

* Do you wish to have TDMS Forms Management support [YES]?

If you type Yes or press the Return key, the Datatrieve image being installed will support TDMS. Then the installation procedure moves on to a series of questions on suffixes and more than one installation of this version of Datatrieve.

If you type No, you receive a question about support for FMS.

If you type No after each question in the series, you receive the following message:

    There are no other Forms Management products on this
    system. If desired, the installation may be aborted
    at this point to install a Forms Management product.
    If the installation continues, the questions pertaining
    to the selection of a Forms Management product will
    be asked again.

* Do you wish to continue with the installation [YES]?

If you type Yes or press the Return key, you have another opportunity to answer questions about forms. If you type No, the installation procedure aborts.

2.5.4. Specifying Suffixes for Multiple Installations of This Version of VSI Datatrieve

The installation procedure asks whether you intend to complete more than one installation of this version of Datatrieve on your system, as follows:

    It is possible to do more than one installation of this
    version of VSI DATATRIEVE. More than one installation of a
    single version may be desirable for a number of reasons
    including:

        o  Use of multiple forms management products

        o  Use of multiple foreign language translations of VSI
           DATATRIEVE (such as French or German)

* Do you plan to install this version more than once [NO]?

If you type No or press the Return key, the installation procedure continues with questions about retaining Datatrieve files (see Section 2.5.5, ''Deleting the Datatrieve Object Library'' for more information). At a later date, you can decide to install Datatrieve using file names other than the defaults by typing Yes in response to the previous question.

If you type Yes, the installation procedure displays messages requesting that you specify a suffix for the image you are installing and the default image for the DCL command DATATRIEVE.

The following message and question about the suffix are displayed:

    To differentiate the files and images produced by this
    installation from those produced by some other
    VSI DATATRIEVE installation, it is necessary to append a
    suffix to some of the file and image names. For each
    installation of this version of VSI DATATRIEVE, this suffix
    should be unique. This suffix can be 1 to 26 characters.

* What is the suffix you intend to use for this installation [none]?

Only one set of Datatrieve images and files can use the default file names that have no suffix (see Section 1.5.4, ''More Than One Installation of This Version of Datatrieve'' for a list of these images and files). If you install this version of Datatrieve a second or subsequent time, you should identify the subsequent image and file names by a unique suffix. This step allows you to later identify which version of Datatrieve you want to run.

For example, on the first run through the installation procedure, you could respond to the question about the suffix by pressing the Return key. The result is that each of the Datatrieve file names includes no suffix. To run the image produced by this procedure, type:

$ RUN SYS$SYSTEM:DTR32

During the second or subsequent installation of this version of Datatrieve, for example, you might use TDMS as the forms product supported by this image. You could uniquely identify the files and images by responding with TDMS for the suffix. To run the image produced by this procedure, type the following line:

$ RUN SYS$SYSTEM:DTR32TDMS

If you specify the same suffix for a later installation, the later image supersedes the previous image installed with the same suffix. If you choose to purge files during the installation, those earlier images will be deleted (see Section 2.5.10, ''Deleting Obsolete Files'' for more information).

For the remainder of this manual, the two letters xx at the end of a file name stand for the 1- to 26-character suffix you specify.

You can invoke Datatrieve with either the RUN command or the DCL command DATATRIEVE. The installation procedure allows you to choose which DTR32 image will be executed by default by the DATATRIEVE command. The following message and question are displayed:

    The DATATRIEVE DCL command allows you to choose which DTR32 image
    to execute by means of the /VARIANT qualifier. You may now choose
    an image to be executed by default, when the /VARIANT qualifier
    is not specified on the DATATRIEVE command. This default image
    will be the image referenced by DCL HELP.

DTR32, DTR32xx

* Which of the above images should be the default [DTR32xx]:

The installation procedure checks which Datatrieve images are on the system. All existing image names, plus the name of the image you are currently installing, are listed. The current image name is provided as the default response to the question.

Only one Datatrieve image can be chosen as the default for the DCL command DATATRIEVE. You must use the /VARIANT qualifier to invoke any other Datatrieve image using the DCL command DATATRIEVE.

For example, on the first run through the installation procedure, you could respond to both the question about the suffix and the question about the DCL default by pressing the Return key. The result is that the image name is DTR32, and that image is the default when you invoke Datatrieve using the DCL command DATATRIEVE as follows:

$ DATATRIEVE

During the second or subsequent installation of this version of Datatrieve, you might choose TDMS as the suffix. You might then choose DTR32 as the default image name with the DCL command DATATRIEVE. You can use the DCL command DATATRIEVE to invoke the DTR32TDMS image as follows:

$ DATATRIEVE/VARIANT=TDMS

If, however, you choose DTR32TDMS as the default with the DATATRIEVE DCL command, you must use the /VARIANT qualifier to invoke the DTR32 image as follows:

$ DATATRIEVE/VARIANT

2.5.5. Deleting the Datatrieve Object Library

The installation procedure asks whether you want to keep the Datatrieve object library on disk in DTR$LIBRARY. The following question is displayed:

* Do you wish to leave the DATATRIEVE library on line [NO]?

If you do not want to keep the Datatrieve library on line, type No or press the Return key. Type Yes if you want to keep the library files.

You should keep the library on line if you anticipate having to relink this image of Datatrieve. If you do not keep the library files on line and later need to relink Datatrieve, you must reinstall this kit.

You have to relink Datatrieve if you:

  • Add a user-defined function

  • Customize the text file DTRTEXT.MAR

  • Install or patch a new version of CDD/Plus

  • Install a new version of the OpenVMS Run-Time Library

  • Install a new version of FMS

If you keep the library on line, you may enter the following command to relink Datatrieve:

$ @DTR$LIBRARY:DTRBLDxx

2.5.6. Defining the Datatrieve Remote Server

The installation procedure checks if the Datatrieve remote server has been defined by previous installations of Datatrieve. The remote server for Datatrieve is called the Distributed Data Manipulation Facility (DDMF). Although there can be several shareable images of Datatrieve installed on the same system, there can be only one remote server for each system.

Note

You do not receive the question discussed in this section if you are installing Datatrieve on an OpenVMS system without DECnet. If you later install DECnet, you then need to define a DECnet object for the remote server. See Section 3.4, ''DECnet Considerations (Phase IV Only)'' for more information on defining a DECnet object.

If no remote server has been defined previously or if a previously-defined remote server is obsolete, the DDMF files from this installation become the remote server for Datatrieve on the system. You do not receive a question about the remote server, and the installation procedure continues with questions about the file for new users (see Section 2.5.7, ''Creating a DCL Command File for New Users'' for more information).

However, if an up-to-date remote server has already been defined (by a previous installation of this Datatrieve release, for example), the installation procedure asks if the remote server established by the current installation should be the remote server for the system. The DECnet object number for DDMF is defined as 30 by the installation procedure. You receive the following question:

* Do you want DDMFxx.EXE to be used for distributed access [NO]?

Type Yes if you want the remote server (DDMF) established by the current installation to be the remote server for your system. You might want to type Yes if this image will contain options that users on remote systems need to access frequently, for example, user-defined functions that PDP-11 users need to access. In such cases, it is more efficient to make the remote server file for this image the remote server for your system.

Type No or press the Return key if these considerations do not apply to this installation of Datatrieve.

2.5.7. Creating a DCL Command File for New Users

The installation procedure continues with questions about the new user file. The new user file, NEWUSER.COM, helps new users get started with Datatrieve. It provides the necessary files to perform the examples in the Datatrieve documentation set. The NEWUSER.COM file is installed in DTR$LIBRARY. Users can invoke the NEWUSER command file by entering:

$ @DTR$LIBRARY: NEWUSER

There are three questions associated with the NEWUSER.COM file; however, you may not be asked all three. To determine which questions you will be asked, the installation procedure checks if your system has a current NEWUSER.COM in DTR$LIBRARY.

If the installation procedure does not find a NEWUSER.COM file, you will not be asked the first question. The procedure automatically installs the NEWUSER.COM file on your system. This might occur if you are installing Datatrieve for the first time. The installation procedure continues with the two remaining questions in this section that allow you to specify information about parent directories for users of NEWUSER.COM.

If the installation procedure finds a NEWUSER.COM file from a previous installation of Datatrieve, you receive the following question:

* Do you want to replace the NEWUSER file [NO]?

Your answer to this question is determined by one of the following situations:

  • If you have not installed Datatrieve since Version 3.4, you must type Yes to use the NEWUSER.COM file. If you type No, the NEWUSER.COM file is not replaced; therefore:

    • You will not be able to use the NEWUSER.COM file because new user files before Version 4.0 are not compatible with Version 5.0.

    • You will not be prompted with the two remaining questions in this section.

  • If you have already installed Datatrieve Version 4.0 or higher, you can answer either No or Yes. If you type No, the NEWUSER.COM is not replaced; however:

    • A DTR32xx.EXE image from a previous installation of Datatrieve (Version 4.0 or higher) may be used for NEWUSER.COM.

    • The installation procedure will not prompt you for the two remaining questions in this section.

If you answer Yes in either of these two situations, the NEWUSER.COM file is replaced. In addition:

  • The DTR32xx.EXE image from this installation of Version 5.0 is used for NEWUSER.COM.

  • The installation procedure continues with the two remaining questions in this section that deal with CDD/Plus directories.

If you have chosen to replace NEWUSER.COM or if NEWUSER.COM is automatically installed, the installation procedure asks the following two questions concerning the CDD/Plus DMU format directories for new user files. These questions allow you to determine the way new user directories are established and the name of the parent CDD/Plus directory for new user files.

The installation procedure prompts you with the following question:

* Do you want NEWUSER to create CDD/Plus directories for new users [YES]?

Answer Yes or press the Return key if you want to create CDD/Plus directories. A new user of Datatrieve can then invoke the file DTR$LIBRARY:NEWUSER.COM after the installation. NEWUSER creates a CDD/Plus directory for the new user if one does not already exist. The directory is created in the DMU format dictionary, since the contents must be stored in DMU format. The directory is comprised of the parent directory specified in the next question and the new user's OpenVMS username. For example, if the parent directory is CDD$TOP.DTR$USERS and user SMITH invokes NEWUSER, SMITH gets the following:

  • A logical CDD$DEFAULT directory, CDD$TOP.DTR$USERS.SMITH

  • Several CDD/Plus DMU format entries, such as YACHTS and FAMILIES, in the CDD$DEFAULT directory

  • A number of data files, such as YACHT.DAT and FAMILY.DAT, in user SMITH's default OpenVMS directory

If you answer No to this question, NEWUSER does not create a CDD/Plus directory for the new user. NEWUSER loads the sample domain and record definitions in the node defined by the logical name CDD$DEFAULT. If the new user has not defined this logical name, NEWUSER issues an error message and terminates the procedure.

Note

If you answer N to this question, ensure that users who want the new user files define the logical name CDD$DEFAULT to point to a DMU format dictionary directory with a path name beginning with CDD$TOP.

If you indicate that you want NEWUSER to create CDD/Plus directories for new users, you are asked to name the parent CDD/Plus directory. The following question is displayed:

* What would you like the parent dictionary directory
  to be [CDD$TOP.DTR$USERS]?

If you want the parent directory to be CDD$TOP.DTR$USERS, press the Return key. Otherwise, enter some other full CDD/Plus directory path name. If your path name does not begin with CDD$TOP, you receive an informational message and are prompted again for the full path name.

2.5.8. Installing Shared Images

Datatrieve runs most efficiently when all its executable images are installed as shareable images. The installation procedure lets you choose not to do so, however. The installation procedure prompts you with the following question. Note that the file SYS$STARTUP:DTRSTUPxx.COM is built according to your responses:

Do you want DTRSHRxx.EXE and DTRMSGS.EXE to be installed SHARED [YES]?

For best performance, the images DTRSHRxx.EXE and DTRMSGS.EXE should be installed as SHARED. Type Y or press the Return key if you want these images to be installed as SHARED.

The second question about shareable images refers to DTR32xx.EXE. For best performance, this should also be installed as SHARED:

Do you want DTR32xx.EXE to be installed SHARED [YES]?

Type Yes or press the Return key if you want this image to be installed SHARED.

For best performance in environments where you anticipate extensive use of the distributed features of Datatrieve, the image DDMFxx.EXE should also be installed as SHARED. If the DDMF from this installation is to be the remote server, you receive the following question:

* Do you want DDMFxx.EXE to be installed SHARED [YES]?

Type Yes or press the Return key if you want this image to be installed as SHARED.

Note

You do not receive the question about DDMFxx.EXE if you are installing Datatrieve on a system that does not have DECnet. If you later install DECnet, see Section 3.4, ''DECnet Considerations (Phase IV Only)'' for instructions on running the DDMFxx.EXE image as SHARED.

2.5.9. Installing Plot Definitions and Optional Material

The installation procedure continues with a question about plot definitions for Datatrieve graphics. Datatrieve contains graphics features you can use with a VT125, VT240, VT330, or VT340 terminal or on a workstation. To use these features, you must request plot definitions during installation.

Note

If this is your first installation of Datatrieve since Version 3.4, you must answer Yes to the following question. The plot definitions were modified with Version 4.0. Plot definitions provided with Datatrieve installations prior to Version 4.0 are not compatible with Datatrieve Version 5.0.

The following question is displayed:

* Do you wish to have the plot definitions [YES]?

Type Yes or press the Return key if you want the installation procedure to include plot definitions. The plot definitions are installed in a CDD/Plus DMU dictionary, in CDD$TOP.DTR$LIB.PLOTS. They replace the plot definitions of lower versions.

The next question pertains to components of Datatrieve that can be tailored at the installation site. This material includes the Datatrieve text and message files, as well as sample programs and callable Datatrieve programming aids that are the basis for many examples in the Datatrieve documentation.

The following message and question are displayed:

    Some optional material is available with this kit including the
    components of VSI DATATRIEVE that can be tailored at the installed
    site.

* Do you want the optional material [NO]?

Type Yes if you want this material. The installation procedure loads these files in DTR$LIBRARY. If you do not want this material, type No or press the Return key.

After you respond to this question, the installation procedure continues with a question about deleting obsolete files from previous installations of Datatrieve.

2.5.10. Deleting Obsolete Files

If any prior releases of Datatrieve are installed on your system, some files you are currently using have been made obsolete with this version of Datatrieve.

The following message is displayed:

    This version of VSI DATATRIEVE makes obsolete some files
    from previous versions of VSI DATATRIEVE.

* Do you want ALL the obsolete files deleted [YES]?

Answer Yes or press the Return key to delete obsolete files. If you answer No, all obsolete files are retained in the system directories where they reside. All files created and deleted by this installation procedure are listed in the file DTR$LIBRARY:DTRnnn.DAT.

Following installation, you can edit a copy of DTRnnn.DAT to create a command file that deletes any of the listed files that you do not wish to keep. After you respond to this question, the installation procedure asks the following:

* Do you want to purge files replaced by this installation [YES]?

If you wish, you can have all files that were created by this installation procedure purged in the various directories where they were created. No files are purged except those created in this installation. Type Yes or press the Return key to purge the files.

2.6. Finishing the Installation

If you did not request the default installation, the following message is displayed:

    All questions regarding the installation have now been asked.

    The installation of VSI DATATRIEVE will now continue for
    10 minutes to 30 minutes.

If this release of Datatrieve includes changes to the sample functions, the installation procedure displays the following message:

An existing DTRFNDxx.MAR has been found
on the system, but its version does not
match the current level for this installation.
The existing DTRFNDxx.MAR and DTRFUNxx.OLB
have been respectively renamed to
DTR$LIBRARY:DTRFNDxx.OLD and
DTR$LIBRARY:DTRFUNxx.OLD.

See Section 3.5, ''Maintaining User-Defined Functions'' for more information on maintaining user-defined functions.

During installation, you should receive the following message:

    During the installation, a file called
    DTRSTUPxx.COM has been added to SYS$STARTUP:

    The site-dependent startup file, SYS$MANAGER:SYSTARTUP_VMS.COM,
    should have the following line added:

         $ @SYS$STARTUP:DTRSTUPxx.COM

Be sure to update SYS$MANAGER:SYSTARTUP_VMS.COM after installation.

The installation procedure next displays information about User Environment Test Packages (UETPs). The installation provides up to five UETPs, depending on the optional products already on the system (TDMS, FMS, Oracle DBMS, Rdb/VMS, and so on) and your responses to the questions about forms products and plots. Besides a general test of Datatrieve, there are also UETPs for plots, forms, Rdb/VMS, and Oracle DBMS.

The installation displays a message showing how to invoke each UETP it provides:

    *************************************************************

    VSI DATATRIEVE User Environment Test Packages (UETPs)
    have been provided and can be run after the installation is
    complete. They are invoked from VSI DATATRIEVE as follows:

    DTR> @sys$common:[systest.dtr]dtr        ! The general test
    DTR> @sys$common:[systest.dtr]plots      ! The plots test
    DTR> @sys$common:[systest.dtr]dbms       ! The Oracle DBMS test
    DTR> @sys$common:[systest.dtr]rdb        ! The Rdb/VMS test
    DTR> @sys$common:[systest.dtr]forms      ! The Forms test

    *************************************************************

The file type for the UETP files in the directory SYS$COMMON:[SYSTEST.DTR] is .DTR.

Chapter 4, "User Environment Test Packages" discusses the test packages in detail.

The installation procedure now runs the general IVP test and displays the following message:

Executing IVP for:  VSI DATATRIEVE V5.0

Running the general IVP test...
    Test completed successfully

    *************************************

    VSI DATATRIEVE V5.0

    IVP COMPLETED SUCCESSFULLY

    *************************************

IVP completed for:  VSI DATATRIEVE V5.0

Note

The PAK must be registered before either the NP or any of the UETPs can be run. If you answered no to the following question, the NP will not be run at this time:

* Does this product have an authorization key registered and loaded?

If the account you are using to install Datatrieve has an ENQLM quota under 500, the installation procedure displays the following information:

Your ENQLM quota is less than 500; this will be too low for the sample
Rdb/VMS database to be restored. Reinstall VSI DATATRIEVE to build
that database after increasing your ENQLM.

If your system has Rdb/VMS and has an ENQLM over 500, the installation procedure now builds the sample Rdb/VMS database. The procedure displays the following message as the procedure builds the database:

Restoring VSI DATATRIEVE demonstration RDB/VMS database

Exported by Rdb/VMS V3.0A-0 Export/Import utility
A component of Rdb/VMS V3.0A-0
Previous name was dtr$library:personnel.rdb
It was logically exported on 27-FEB-1989 09:48
Database NUMBER OF USERS is 50
Database NUMBER OF VAXCLUSTER NODES is 16
Database NUMBER OF DBR BUFFERS is 20
Database SNAPSHOT is ENABLED
Database SNAPSHOT is IMMEDIATE
Database BUFFER SIZE is 6 blocks
Database NUMBER OF BUFFERS is 20
IMPORTing relation COLLEGES
IMPORTing relation DEGREES
IMPORTing relation DEPARTMENTS
IMPORTing relation EMPLOYEES
IMPORTing relation JOBS
IMPORTing relation JOB HISTORY
IMPORTing relation SALARY HISTORY
IMPORTing relation WORK STATUS
        Installation of DTR V5.0 completed at 17:24

Note

You might receive one or more DECnet error messages during this part of the installation procedure. You can ignore these messages.

When the installation procedure is finished, control returns to the command procedure VMSINSTAL.

Chapter 3. Post-Installation Considerations

This chapter discusses some important post-installation considerations concerning DECnet, relational databases, Oracle DBMS databases, and user-defined functions.

3.1. Updating SYS$MANAGER:SYSTARTUP_VMS.COM

During installation, a file called DTRSTUPxx.COM was added to SYS$STARTUP. Note that xx represents the 1- to 26-character suffix you specify during installation. After installation, you must update the site­ dependent startup file SYS$MANAGER:SYSTARTUP_VMS.COM by adding the following line:

$ @SYS$STARTUP:DTRSTUPxx.COM

3.2. OpenVMS Cluster Considerations

If you are installing Datatrieve on an OpenVMS cluster, the shareable image created by this installation of Datatrieve is available only from the node where the installation is done. Therefore, after the installation is complete, you should repeat the following steps on each of the other nodes in the OpenVMS cluster where Datatrieve will be used:

  1. Issue the LICENSE LOAD command to activate the OpenVMS license.

  2. Execute the Datatrieve startup command file as follows:

    $ @SYS$STARTUP:DTRSTUPxx.COM
  3. Install the new version of DCLTABLES.EXE that has been updated to include the DCL command DATATRIEVE. Install the file as follows:

    $ INSTALL
    INSTAL> REPLACE SYS$SHARE:DCLTABLES

The second step is not necessary if you plan to reboot the entire OpenVMS cluster after the installation is complete.

3.3. Updating Process Command Tables

The VSI Datatrieve T7.4-3 installation creates a new version of DCLTABLES.EXE including the DCL command DATATRIEVE. To use the DCL command DATATRIEVE, users must log out of their processes and log back in to update their process command tables.

3.4. DECnet Considerations (Phase IV Only)

Important

The content of this section is specific to users of DECnet Phase IV only.

This section describes what you need to do to run the Datatrieve remote server if DECnet is installed after Datatrieve on an OpenVMS system. It also describes how to create a default DECnet account for remote users of Datatrieve on your system.

3.4.1. Defining a DECnet Object

DECnet is normally installed on an OpenVMS system. Unless you install Datatrieve on an OpenVMS system without DECnet, the installation procedure automatically defines a DECnet object for the Datatrieve remote server.

However, if you install Datatrieve on an OpenVMS system that does not have DECnet, the installation procedure cannot use the DECnet Network Control Program (NCP) utility to define a DECnet object.

This section describes how to use NCP to define a DECnet object for the remote server if DECnet is installed on your system after Datatrieve is installed.

The remote server for Datatrieve is called the Distributed Data Manipulation Facility (DDMF). The installation procedure creates two files, DDMFxx.EXE and DDMFxx.COM, in SYS$SYSTEM. To define a DECnet object for DDMFxx.EXE and assign it an object number of 30, type the following commands:

$ NCP == "$NCP"
$ NCP DEFINE OBJECT DDMF NUMBER 30
$ NCP SET OBJECT DDMF NUMBER 30
$ NCP DEFINE OBJECT DDMF FILE DDMFxx.COM
$ NCP SET OBJECT DDMF FILE DDMFxx.COM

For best performance in environments where you anticipate extensive use of the distributed features of Datatrieve, you should run the remote server as SHARED. To run the image DDMFxx.EXE as a SHARED image, edit the file SYS$STARTUP:DTRSTUPxx.COM. This file begins with the following lines:

$!+
$!   VSI DATATRIEVE Start-up File
$!-

Check the file for the following line and add it if it is not already there:

$ DTR$INSTALL := $SYS$SYSTEM:INSTALL/COMMAND_MODE

You will see a dollar sign and the word exit at the end of the file. Enter the following text on the line above $ exit:

ADD/OPEN/SHARED SYS$SYSTEM:DDMFxx.EXE

3.4.2. Creating a Default DECnet Account for Distributed Access

The installation procedure defines a DECnet object called DDMF and assigns it the number 30. After the installation, you may want to create a default DECnet account, such as DECNET_DTR, for this DECnet object. Remote users can then omit the username and password from the node specification when accessing domains on your node.

Note

This section applies to systems on which DECnet was installed before Datatrieve. If Datatrieve is installed on an OpenVMS system that does not have DECnet, you cannot define a default DECnet account. If DECnet is later installed, you must define a DECnet object (see Section 3.4.1, ''Defining a DECnet Object'') before you can create a default DECnet account.

If you wish to set up such a default DECnet account for distributed access, follow these steps:

  1. Add an entry to the user authorization file (UAF) on your system for DECNET_DTR. Specify the same file limits and quotas as you would for any other Datatrieve user.

  2. Invoke NCP to associate DDMF (known object 30) with the default DECnet account DECNET_DTR. Use the DEFINE OBJECT command in NCP to modify the object parameters for DDMF in the permanent database on your system.

You can use the following sample session as a model for your own system. Note that for security reasons, you should use a different password than the one provided:

$ AUTH == "$AUTHORIZE"
$ NCP == "$NCP"
$ SET DEFAULT SYS$SYSTEM
$ AUTH
UAF>ADD DECNET DTR/OWNER="VSI
DATATRIEVE"/PASSWORD=choose_your_password
user record successfully added
UAF>MODIFY DECNET_DTR/DEVICE=SYS$SYSDEVICE/DIRECTORY=[DECNET_DTR]
user record(s) updated
UAF>MODIFY DECNET_DTR/UIC=[376,376]
user record(s) updated
UAF>MODIFY DECNET_DTR/FILLM=30/ENQLM=200 !or 500 for Rdb/VMS users
user record(s) updated
UAF>MODIFY DECNET_DTR/WSDEFAULT=350/WSQUOTA=350
user record(s) updated
UAF>MODIFY DECNET_DTR/FLAGS=(DISCTLY, DEFCLI, LOCKPWD, CAPTIVE)
UAF>SHOW DECNET DTR

Username: DECNET_DTR              Owner:  VSI DATATRIEVE
Account:                          UIC:    [376,376] ([376,376])
CLI:      DCL                     Tables: DCLTABLES
Default:  SYS$SYSDEVICE:[DECNET_DTR]
LGICMD:   LOGIN
Login Flags: Disctly Defcli Lockpwd Captive
Primary days:   Mon Tue Wed Thu Fri
Secondary days:                     Sat Sun
No access restrictions
Expiration:            (none)    Pwdminimum:  6  Login Fails:  0
Pwdlifetime:        180 00:00    Pwdchange:     (pre-expired)
Last Login: (none) (interactive),       (none) (non-interactive)
Maxjobs:         0  Fillm:        30  Bytlm:         4096
Maxacctjobs:     0  Shrfillm:      0  Pbytlm:           0
Maxdetach:       0  BIOlm:        18  JTquota:       1024
Prclm:           2  DIOlm:        18  WSdef:          350
Prio:            4  ASTlm:        24  WSquo:          350
Queprio:         0  TQElm:        10  WSextent:      1000
CPU:        (none)  Enqlm:       500  Pgflquo:      10000
Authorized PRivileges:
  TMPMBX NETMBX
Default Privileges:
  TMPMBX NETMBX

UAF>EXIT
SYSUAF.DAT modified
$ CREATE/DIR/OWN= [376,376] SYS$SYSDEVICE:[DECNET_DTR]
$ ncp
NCP> LIST OBJECT DDMF

Object Permanent Summary as of 31-OCT-1989 15:31:09

Object= DDMF

Number                   = 30
File id                  = DDMF.COM

NCP>DEFINE OBJECT DDMF USER DECNET DTR PASSWORD YACHTS
NCP>LIST OBJECT DDMF

Object Permanent Summary as of 31-OCT-1989 15:31:09

Object DDMF

Number                   = 30
File id                  = DDMF.COM
User id                  = DECNET DTR
Password                 = YACHTS

NCP>SET KNOWN OBJECTS ALL
NCP>EXIT
$

For more information on NCP and DECnet, refer to the relevant section in the VSI OpenVMS System Manager's Manual, Volume 2: Tuning, Monitoring, and Complex Systems.

3.5. Maintaining User-Defined Functions

If this is your first installation of VSI Datatrieve since Version 4.1, and if your site maintains site-specific or user-defined functions, then you should complete the following steps to re-enable user-defined functions.

After an initial installation of Datatrieve Version 4.2 or higher, Datatrieve will always use the DTRFNDxx.MAR and DTRFUNxx.OLB files that are on the system. You will no longer have to re-create and relink Datatrieve as described in this section.

  1. Transfer the user-defined function definitions from DTRFNDxx.OLD (renamed during installation) to DTRFNDxx.MAR. To do this, edit DTRFNDxx.MAH. and add the appropriate definitions. Merely renaming the old file does not enable user-defined functions in the file. They must be transferred to DTRFNDxx.MAR.

  2. Assemble DTRFNDxx.MAR with the MACRO command:

    $ MACRO DTR$LIBRARY:DTRFNDxx.MAR

    This command creates the object file DTRFNDxx.OBJ.

  3. Replace the object module in the function library with the newly created object file:

    $ LIBRARY/REPLACE DTR$LIBRARY:DTRFUNxx DTRFNDxx
  4. Skip to the next step if the user-defined functions for your site consist only of calls to Run-Time Library routines. However, if your site has user-defined functions that call their own routines, there is an additional step before relinking Datatrieve. The object files for those functions routines must be inserted into the new version of the function library.

    There are two ways to do this:

    • If the object files (.OBJ files) for the routines are still available, insert them directly into the function library:

      $ LIBRARY/INSERT -
      _$    DTR$LIBRARY:DTRFUNxx.OLB filename.OBJ
    • If the object files for the routines are not available, extract the modules from the old function library before inserting them into the new:

      $ LIBRARY/EXTRACT=module-name/OUTPUT=filename.OBJ -
      _$    DTR$LIBRARY:DTRFUNxx.OLD
      $ LIBRARY/INSERT -
      _$    DTR$LIBRARY:DTRFUNxx.OLB filename.OBJ
  5. Relink Datatrieve:

    $ @DTR$LIBRARY:DTRBLDxx

Note

If your site maintains no user-defined functions, you may choose to delete the .OLD files.

3.6.  Deleting Unused Files for Datatrieve DECwindows Support

If the Datatrieve DECwindows interface is not required at your site, you can delete the following files after the Datatrieve installation has successfully completed:

  • SYS$SYSROOT:[SYSEXE]DTRHELP.EXE

  • SYS$SYSROOT:[SYSLIB]DTR$CDDTSHR.EXE

  • SYS$SYSROOT:[SYSHLP]DTRDECW$HELP.HLB

  • SYS$SYSROOT:[SYSLIB]VSI_DATATRIEVE.UID

  • SYS$SYSROOT:[DTR]REMOTE_DECTERM.COM

If you delete any of the Datatrieve DECwindows files, ensure that you delete all of the listed files.

After the Datatrieve DECwindows interface files are deleted, remove all references to these files from each of your SYS$STARTUP:DTRSTUPxx.COM files.

Chapter 4. User Environment Test Packages

Five User Environment Test Packages (UETPs), which show examples and test product interfaces, are provided with Datatrieve. You can run the UETPs after you install Datatrieve. The following UETPs are provided with Datatrieve:

  • Datatrieve

  • Datatrieve graphics capability

  • Datatrieve and Oracle DBMS interface

  • Datatrieve and Rdb/VMS interface

  • Datatrieve and FMS or TDMS interface

Appendix B of the VSI Datatrieve User Guide includes the data definitions and procedures used in the UETPs.

Note

You must run the Datatrieve UETP before running any other UETP. The Datatrieve UETP creates data definitions used by the other UETPs.

4.1. Invoking Datatrieve

To run the UETPs; you must first invoke Datatrieve in one of the following ways:

  • Use the DCL command RUN as follows:

    $ RUN SYS$SYSTEM:DTR32xx.EXE

    The xx represents the 1- to 26-character optional suffix added to an image of Datatrieve at installation.

  • Use a symbol you have defined to represent the RUN command. For example:

    $ DTR32
  • Use the DCL command DATATRIEVE as follows:

    $ DATATRIEVE

    The DCL command DATATRIEVE is useful if you are working in a DECwindows environment. You should not run the UETPs using the Datatrieve DECwindows interface, as you may get unexpected results. By using the DATATRIEVE command to invoke Datatrieve, you can specify the /INTERFACE=CHARACTER_CELL qualifier to invoke Datatrieve without the DECwindows interface.

    If you have installed more than one Datatrieve image, you can specify the /VARIANT=image-suffix qualifier to run the image of Datatrieve you want to test.

    To invoke Datatrieve using these qualifiers, enter the following command:

    $ DATATRIEVE /INTERFACE=CHARACTER_CELL/VARIANT=xx

    The characters xx represent the 1- to 26-character suffix added at installation to identify a particular image of Datatrieve Version 5.0.

At the DTR> prompt, enter the command to execute the UETP you want to run. The UETPs and the commands to invoke them are described in the following sections.

4.2. VSI Datatrieve UETP

To run the Datatrieve UETP, invoke Datatrieve as described in Section 4.1, ''Invoking Datatrieve'' and type the following command:

DTR> @SYS$GOMMON: [SYSTEST.DTR]DTR

The Datatrieve UETP is approximately 20 pages long, so the entire UETP is not repeated here.

You respond to prompts during the Datatrieve UETP. The parts of the UETP that require a response are included here along with suggested responses.

Note

The Datatrieve UETP suggests at one point that you use LP: to print a report directly to a line printer. The LP: option may not work unless LP is defined as the system printer.

!
! TEST STORE
!
! PLEASE SUPPLY THE FOLLOWING VALUES:
!    MANUFACTURER:       HINKLEY
!    MODEL:              BERMUDA 40
!    RIG:                YAWL
!  * LENGTH-OVER-ALL:    140
!    LENGTH-OVER-ALL:    40
!    DISPLACEMENT:       20000
!    BEAM:               12
!  * PRICE:              82000 AND XX/100
!    PRICE:              $82,000
!    CONFIRM:            N
!
!    Values marked with"*" will generate an error and be reprompted
!

STORE YACHTS: VERIFY
Enter MANUFACTURER: HINKLEY
Enter MODEL: BERMUDA 40
Enter RIG: YAWL
Enter LENGTH OVER ALL: 140
Validation error for field LENGTH OVER ALL.
Re-enter LENGTH-OVER-ALL: 40
Enter DISPLACEMENT: 20000
Enter BEAM: 12
Enter PRICE: 82000 AND XX/100
Non-digit in string "82000 AND XX/100", ignoring character(s).
Re-enter PRICE: $82,000

                              LENGTH
                               OVER
MANUFACTURER   MODEL     RIG   ALL    WEIGHT  BEAM  PRICE

 HINKLEY     BERMUDA 40 YAWL   40     20,000   12  $82,000
DISPLAY: IF RECORD IS OK, CONFIRM WITH Y
Enter CONFIRM: N

!
! Invoke report (suggest TT: as output file)
!
:LOA-REPORT
Enter FILE: TT

At this point, a report is displayed on the screen. When the report finishes, the UETP continues:

!
! Invoke report (suggest LP: as output file)
!
:LOA-REPORT
Enter FILE: LP:

At this point, the procedure sends a report to the line printer and the UETP continues:

READY YACHTS MODIFY
!
! RESPOND WITH 47 (or any two digit value)
!
MODIFY BEAM
Enter BEAM: 47
PRINT TYPE,BEAM

MANUFACTURER   MODEL    BEAM

METALMAST   GALAXY       47
!
! RESPOND WITH 48 (or any two digit value)
!
MODIFY ALL BEAM
Enter BEAM: 48
!
PRINT ALL BEAM

BEAM

 48
 48
 48
 48
 48

!
! Respond each time with 0 (please)
!
FOR CURRENT PRINT TYPE THEN MODIFY BEAM

MANUFACTURER   MODEL

 METALMAST   GALAXY
Enter BEAM: 0
 O'DAY       32
Enter BEAM: 0
 RYDER       S. CROSS
Enter BEAM: 0
 TA CHIAO    FANTASIA
Enter BEAM: 0
 WRIGHT      SEAWIND II
Enter BEAM: 0
!
SET ABORT
READY YACHTS READ
PRINT ALL

                               LENGTH
                                OVER
MANUFACTURER   MODEL     RIG    ALL     DISPLACEMENT  BEAM   PRICE

 METALMAST   GALAXY     SLOOP   32          9,500      00
 O'DAY       32         SLOOP   32         11,500      00   $29,500
 RYDER       S. CROSS   SLOOP   31         13,600      00   $32,500
 TA CHIAO    FANTASIA   SLOOP   35         23,200      00
 WRIGHT      SEAWIND II SLOOP   32         14,900      00   $34,480

The installation is successful if you receive the following message at the end of the UETP:

!
! The VSI DATATRIEVE User Environment Test
! Package has completed successfully.
!

4.3. VSI Datatrieve Graphics UETP

You must run the Datatrieve graphics UETP on a VT125, VT240, VT330, or VT340 terminal, or a workstation. To run the UETP, invoke Datatrieve as described in Section 4.1, ''Invoking Datatrieve'' and type the following command:

DTR> @SYS$COMMON:[SYSTEST.DTR]PLOTS

The Datatrieve graphics UETP does not require any input from you. There are pauses between plots. The Datatrieve graphics UETP displays the results of using the following plot statements:

  • PLOT WOMBAT – A picture of a wombat

  • PLOT DATE_Y – A scattergraph with dates along the horizontal axis

  • PLOT SHADE – The previous scattergraph with shading

  • PLOT DATE_Y– A scattergraph with dates along the horizontal axis

  • PLOT CONNECT – The previous scattergraph with the points connected

  • PLOT DATE_LOGY – A scattergraph with dates along the horizontal axis and a logarithmic scale for the vertical axis

  • PLOT LR – The previous scattergraph with a linear regression line

  • PLOT STACKED_BAR – A bar chart with stacked bars and a legend

  • PLOT MULTI_BAR – A bar chart with multiple bars and a legend

  • PLOT X_Y – A scattergraph

  • PLOT TITLE – The previous scattergraph with a title

  • PLOT LIMITS_Y – The previous X_Y scattergraph with maximum and minimum limits imposed on the Y axis

  • PLOT LIMITS_X – The previous X_Y scattergraph with maximum and minimum limits imposed on the X axis

  • PLOT REFERENCE_Y – The previous X_Y scattergraph with a solid reference line on the Y axis

  • PLOT REFERENCE_X – The previous X_Y scattergraph with a solid reference line on the X axis

  • PLOT LR – The previous scattergraph with a linear regression line

  • PLOT X_LOGY – A scattergraph with a logarithmic scale for the vertical axis

  • PLOT HISTO – A histogram

  • PLOT PIE – A pie chart (with default title heading)

  • PLOT TITLE (pie) – The previous pie chart with a multiline title

  • PLOT BAR – A bar chart using builder and price

  • PLOT SORT_BAR – The previous bar chart with the bars sorted by descending height

  • PLOT BAR – A bar chart using type and price

When the Datatrieve graphics UETP finishes, you see this message:

!
! End of User Environment Test Package for Datatrieve graphics
!
EXIT

4.4. VSI Datatrieve and Oracle DBMS UETP

To run the Datatrieve and Oracle DBMS UETP, invoke Datatrieve as described in Section 4.1, ''Invoking Datatrieve'' and type the following command:

DTR> @SYS$COMMON:[SYSTEST.DTR]DBMS

The Datatrieve and Oracle DBMS UETP is long, so the entire UETP is not repeated here.

You respond to prompts during the Datatrieve and Oracle DBMS UETP. The parts of the UETP that require answers are included here along with suggested responses:

SELECT
PRINT

Part                                        Unit    Unit
Number   ------Part Description------  St   Price   Cost   Sp

TI-6789-01     RK HOUSING              G    $300    $190   FS
!
! Respond with 123 (or any three digit value)
!
MODIFY PART_PRICE
Enter PART_PRICE: 123
PRINT PART_ID, PART_PRICE

  Part            Unit
  Number          Price

TI-6789-01         $123
!
! Respond with 321 (or any three digit value)
!
MODIFY ALL PART_PRICE
Enter PART_PRICE: 321
PRINT ALL PART_PRICE

       Unit
       Price

         $321
         $321
         $321
         $321
         $321
!
! Respond each time with 0 (Please)
!
FOR CURRENT
  PRINT PART_ID THEN MODIFY PART_PRICE

  Part
  Number

TI-6789-01
Enter PART PRICE: 0
BR-8901-23
Enter PART PRICE: 0
TE-2345-67
Enter PART PRICE: 0
TE-2178-90
Enter PART PRICE: 0
TI-1334-56
Enter PART PRICE: 0
PRINT ALL

Part                                        Unit    Unit
Number   ------Part Description------  St   Price   Cost   Sp

TI-6789-01     RK HOUSING              G    $0      $190   FS

BR-8901-23     LA36                    G    $0      $750   FS

TE-2345-67     RP05                    G    $0    $1,900   FS

TE-2178-90     RK06                    G    $0    $1,100   FS

TI-1334-56     RP HOUSING              G    $0      $300   FS

If the Datatrieve and Oracle DBMS UETP runs successfully, you see the following message:

!
! End of DATATRIEVE/DBMS User Environment Test Package
!

4.5. VSI Datatrieve and Oracle Rdb/VMS UETP

To run the Datatrieve and Rdb/VMS UETP, invoke Datatrieve as described in Section 4.1, ''Invoking Datatrieve'' and type the following command:

DTR> @SYS$COMMON:[SYSTEST.DTR]Rdb

The Datatrieve and Rdb/VMS UETP is 12 pages long, so the entire UETP is not repeated here.

You respond to prompts during the Datatrieve and Rdb/VMS UETP. The parts of the UETP that require answers are included here along with suggested responses:

!
! Test Store
!
! Please supply the following values:
!
! WAGE_CLASS : 4
! JOB_TITLE: ANYTHING
! MINIMUM_SALARY: 12000
! MAXIMUM_SALARY: 123000
!

STORE JOBS USING
BEGIN
JOB_CODE= "XXXX"
WAGE_CLASS= *.WAGE_CLASS
JOB_TITLE= *.JOB_TITLE
MINIMUM_SALARY *.MINIMUM_SALARY
MAXIMUM_SALARY *.MAXIMUM_SALARY
END

Enter WAGE_CLASS: 4
Enter JOB_TITLE: ANYTHING
Enter MINIMUM_SALARY: 12000
Enter MAXIMUM_SALARY: 123000
!

STORE JOBS USING
BEGIN
JOB_CODE= "YYYY"
WAGE_CLASS= 2
JOB_TITLE= "FILE CLERK"
MINIMUM_SALARY 8000
MAXIMUM_SALARY= 20000
END
!
PRINT JOBS WITH JOB_CODE "XXXX", "YYYY"

JOB WAGE JOB MINIMUM MAXIMUM
CODE CLASS TITLE SALARY SALARY

XXXX 4 ANYTHING $12,000.00 $123,000.00
YYYY 2 FILE CLERK $8000.00 $20,000.00
!
! Test Erase
!
FOR JOBS WITH JOB_CODE= "XXXX" ERASE
PRINT JOBS WITH JOB_CODE= "XXXX"
!
FIND JOBS WITH JOB_CODE= "YYYY"
[l record found]
PRINT ALL

JOB WAGE JOB MINIMUM MAXIMUM
CODE CLASS TITLE SALARY SALARY

YYYY 2 FILE CLERK $8,000.00 $20,000.00

SELECT LAST
ERASE
PRINT JOBS WITH JOB_CODE "YYYY"
!
! Test Update
!
FIND EMPLOYEES WITH EMPLOYEE_ID = "00168"
[1 record found]
SELECT
!
PRINT EMPLOYEE_ID, LAST_NAME, STREET, TOWN, STATE

EMPLOYEE LAST
ID NAME STREET TOWN STATE
00168 Nash 87 West Rd. Meadows NH
!
! Change this employee's address
!
! Please supply the following value:
!
! STREET: 8 FLINT POND
!
MODIFY STREET
Enter STREET: 8 FLINT POND
PRINT EMPLOYEE_ID, LAST_NAME, STREET, TOWN, STATE

EMPLOYEE LAST
ID NAME STREET TOWN STATE
00168 Nash 8 FLINT POND Meadows NH
!
! Don't really want to do this; rollback this change
!
ROLLBACK
ROLLBACK executed; collection CURRENT automatically released.

!
PRINT EMPLOYEE_ID, LAST_NAME, STREET, TOWN, STATE OF EMPLOYEES WITH
EMPLOYEE ID= "00168"

EMPLOYEE LAST
ID NAME STREET TOWN STATE
00168 Nash 87 West Rd. Meadows NH
!
FIND ALL EMPLOYEES WITH STATE "MA"
[8 records found]
PRINT ALL STATE

STATE

MA
MA
MA
MA
MA
MA
MA
MA

!
!Respond with VT (or another two-character state abbreviation)
!
MODIFY ALL STATE
Enter STATE: VT
PRINT ALL STATE

STATE

VT
VT
VT
VT
VT
VT
VT
VT

!
! Move them back to MA
!
FOR CURRENT
MODIFY USING STATE = "MA."
PRINT ALL STATE
STATE

MA
MA
MA
MA
MA
MA
MA
MA

If the Datatrieve and Rdb/VMS UETP runs successfully, you see the following message:

!
! End of DATATRIEVE/Rdb User Environment Test Package
!

ROLLBACK
ROLLBACK executed; collection CURRENT automatically released.
FINISH ALL
DTR>

4.6. VSI Datatrieve and Forms UETP

You need a VT52-, VTl00-, VT200-, or VT300-family terminal or a workstation to run the Datatrieve and forms UETP.

If Datatrieve was installed with support for TDMS or FMS, you can run the forms UETP to test the forms interface.

To run the forms UETP, set your OpenVMS default to a directory that contains YACHT.DAT and OWNER.DAT. Be sure that you have WRITE access (W) to these files. You can copy YACHT.DAT and OWNER.DAT from the directory DTR$LIBRARY if you do not have them in your directory. Then, invoke Datatrieve as described in Section 4.1, ''Invoking Datatrieve'' and type the following command:

DTR> @SYS$COMMON: [SYSTEST.DTR]FORMS

When Datatrieve uses a form to print records, the screen clears before the first record is printed. The Datatrieve and forms UETP asks you to enter a character and press Return before each statement, causing the forms product to erase the screen.

The following is a summary of the Datatrieve and forms UETP:

  1. The UETP sends instructions to your screen and waits for you to enter a character and press Return. After you respond, the UETP defines three domains that use the forms product: YACHTS, SAILBOATS, and FAMILIES. The definitions use forms libraries that are located in DTR$LIBRARY.

  2. The UETP readies YACHTS and prints a few records without using the forms product. Then the UETP sends more instructions to your screen and waits for you to enter a character and press Return. After you respond, the UETP prints a record using the forms product. Press Return after the forms product displays the record.

  3. The UETP sends instructions to your screen and waits for you to enter a character and press Return. After you respond, the UETP prints several records using the forms product. Press Return after the forms product displays each record.

  4. The UETP tests the STORE statement. The UETP sends instructions to your screen and waits for you to enter a character and press Return. After you respond, the forms product puts a form on the screen for you to fill in. To move the cursor from one field to another, use the Tab and Backspace keys. The Tab key moves the cursor to the next field; the Backspace key moves the cursor back to the previous field. Help is also available for some fields if you have trouble entering an acceptable value. Position the cursor on that field and press the Help key. After you fill in the form, press Return.

  5. The UETP tests the MODIFY statement controlling the DISPLAY_FORM statement. The UETP sends instructions to your screen and waits for you to enter a character and press Return. After you respond, the forms product displays the first record for you to modify. Use the Tab and Backspace keys to move from one field to another. Modify only the BEANI field in each record. Any other modifications are not written to the data file. After you modify each record, press Return.

  6. The UETP tests the PRINT statement again, using the SAILBOATS view domain. The UETP waits for you to enter a character and press Return before each PRINT statement. After the forms product displays the SAILBOAT records, the UETP sends the following message to your screen:

    !
    ! End of DATATRIEVE/Forms User Environment Test Package
    !

Chapter 5. Maintaining VSI Datatrieve

This chapter explains the procedures to follow if problems arise after you install Datatrieve.

5.1. Writing a Session Log to a File

A session log file often contains information vital to tracking down the cause of an error. Sometimes, this information can help you determine the cause of an error and correct it or work around it. Session logs are also a useful tool for the Customer Support Center (CSC) and should be used if you call the CSC, submit an SPR to VSI, or both.

You can use the OPEN command to create a log file of your DATATRIE'VE session in your OpenVMS directory. After you execute a command file, you can close this file with a close command and exit Datatrieve to print it. A session log is useful to troubleshoot a long command file, or one that produces so much output that your screen does not accommodate all the lines you need to see at one time. In the following example, PROBLEMS.LOG is the log file name, but you can choose any valid OpenVMS file specification you want:

DTR> OPEN PROBLEMS.LOG
DTR> SET VERIFY
DTR> @MYFILE
. . .
. . .
. . .
DTR> CLOSE ! Do not enter the file name following CLOSE.
DTR> SET NO VERIFY
DTR> EXIT
$ PRINT/QUEUE=SYS$PRINT PROBLEMS.LOG

During your log session, if you make calls to other products or if you use a command like the Datatrieve CDO command to request information from another product, that information is not written to the file specified by the OPEN command. A print-out of your log session displays your Datatrieve commands but does not include the output generated by the other product.