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:
Chapter 1, "Pre-Installation Considerations" explains how to plan the installation and prepare your system.
Chapter 2, "VSI Datatrieve Installation Procedure" explains the installation procedure and the questions asked during installation.
Chapter 3, "Post-Installation Considerations" identifies important post-installation considerations.
Chapter 4, "User Environment Test Packages" describes the User Environment Test Packages (UETPs) and provides instructions for running them.
Chapter 5, "Maintaining VSI Datatrieve" explains the procedures to follow if problems arise after you install Datatrieve.
4. Related Documents
For further information on the topics covered in this manual, you can refer to the following documentation:
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: <docinfo@vmssoftware.com>. Users who have VSI OpenVMS support contracts through VSI can contact <support@vmssoftware.com> 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:
| Convention | Meaning |
|---|---|
|
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:
|
| ⋮ |
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
( |
|
UPPERCASE TYPE |
Uppercase type indicates the name of a routine, the name of a file, or the abbreviation for a system privilege. |
|
|
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 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:
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.
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.
CDD/Plus
Forms products such as TDMS and FMS (Optional)
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.
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:
Log in to a privileged account on the system on which the previous version of Datatrieve was installed.
Delete all files from the directory using the following command:
$ DELETE SYS$SPECIFIC: [DTR]*.*;*
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
FINISHcommand 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:
| File | Global Sections | Global Pages |
|---|---|---|
| DDMFxx | 1 | 143 |
| DTR32xx | 1 | 204 |
| DTRSHRxx | 5 | 952 |
| DTRMSGS | 1 | 105 |
| DTRHELP | 1 | 61 |
| DTR$CDDTSHR | 4 | 791 |
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:
| CONTROL | EXTEND | LOCAL_DELETE |
| DTR_EXTEND | FORWARD | PASS_THRU |
| DTR_MODIFY | GLOBAL_DELETE | SEE |
| DTR_READ | HISTORY | UPDATE |
| 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
DatatrieveDCL 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:DTRBLDxx2.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
Yesto use the NEWUSER.COM file. If you typeNo, 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
NoorYes. If you typeNo, 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.COMBe 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.0Note
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:24Note
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.COM3.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:
Issue the
LICENSE LOADcommand to activate the OpenVMS license.Execute the Datatrieve startup command file as follows:
$ @SYS$STARTUP:DTRSTUPxx.COMInstall 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.EXE3.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:
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.
Invoke NCP to associate DDMF (known object 30) with the default DECnet account DECNET_DTR. Use the
DEFINE OBJECTcommand 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.
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.
Assemble DTRFNDxx.MAR with the
MACROcommand:$ MACRO DTR$LIBRARY:DTRFNDxx.MARThis command creates the object file DTRFNDxx.OBJ.
Replace the object module in the function library with the newly created object file:
$ LIBRARY/REPLACE DTR$LIBRARY:DTRFUNxx DTRFNDxx
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
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
RUNas follows:$ RUN SYS$SYSTEM:DTR32xx.EXEThe 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
RUNcommand. For example:$ DTR32
Use the DCL command
DATATRIEVEas follows:$ DATATRIEVE
The DCL command
DATATRIEVEis 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 theDATATRIEVEcommand to invoke Datatrieve, you can specify the/INTERFACE=CHARACTER_CELLqualifier to invoke Datatrieve without the DECwindows interface.If you have installed more than one Datatrieve image, you can specify the
/VARIANT=image-suffixqualifier 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=xxThe 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: TTAt 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,480The 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 FSIf 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:
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.
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.
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.
The UETP tests the
STOREstatement. 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.The UETP tests the
MODIFYstatement controlling theDISPLAY_FORMstatement. 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.The UETP tests the
PRINTstatement again, using the SAILBOATS view domain. The UETP waits for you to enter a character and press Return before eachPRINTstatement. 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.