Tandem ENFORM 058057 Manuale utente
Data Management Library
Tandem Computers Incorporated
ENFORM™
Reference Manual
Abstract This manual provides detailed information about the syntax of the ENFORM language.
Part Number 058057
Document History Edition Part Number Operating System Version Date
First Edition 82348 A00 GUARDIAN A04/E05 October 1982
Second Edition 82348 B00 GUARDIAN A05/E06 April 1983
Update 1 82194 GUARDIAN A06/E07 December 1983
Update 2 82205 GUARDIAN B00/E08 March 1985
Third Edition 058057 GUARDIAN B00/E08 July 1991
The second edition of this manual, including updates 1 and 2, was reformatted in July 1991; no changes
were made to the manual’s content at that time. The reformatted manual became the third edition.
Copyright All rights reserved. No part of this document may be reproduced in any form, including photocopying or
translation to another language, without the prior written consent of Tandem Computers Incorporated.
Copyright 1991 Tandem Computers Incorporated.
Ordering Information For manual ordering information: domestic U.S. customers, call 1-800-243-6886; international customers, contact your
local sales representative.
Document Disclaimer Information contained in a manual is subject to change without notice. Please check with your authorized Tandem
representative to make sure you have the most recent information.
Export Statement Export of the information contained in this manual may require authorization from the U.S. Department of Commerce.
Examples Examples and sample programs are for illustration only and may not be suited for your particular purpose. Tandem does
not warrant, guarantee, or make any representations regarding the use or the results of the use of any examples or sample
programs in any documentation. You should verify the applicability of any example or sample program before placing the
software into productive use.
U.S. Government
Customers FOR U.S. GOVERNMENT CUSTOMERS REGARDING THIS DOCUMENTATION AND THE ASSOCIATED SOFTWARE:
These notices shall be marked on any reproduction of this data, in whole or in part.
NOTICE: Notwithstanding any other lease or license that may pertain to, or accompany the delivery of, this computer
software, the rights of the Government regarding its use, reproduction and disclosure are as set forth in Section 52.227-19
of the FARS Computer Software-Restricted Rights clause.
RESTRICTED RIGHTS NOTICE: Use, duplication, or disclosure by the Government is subject to the restrictions as set
forth in subparagraph (c)(1)(ii) of the Rights in Technical Data and Computer Software clause at DFARS 52.227-7013.
RESTRICTED RIGHTS LEGEND: Use, duplication or disclosure by the Government is subject to restrictions as set forth
in paragraph (b)(3)(B) of the rights in Technical Data and Computer Software clause in DAR 7-104.9(a). This computer
software is submitted with “restricted rights.” Use, duplication or disclosure is subject to the restrictions as set forth in
NASA FAR SUP 18-52 227-79 (April 1985) “Commercial Computer Software — Restricted Rights (April 1985).” If the
contract contains the Clause at 18-52 227-74 “Rights in Data General” then the “Alternate III” clause applies.
U.S. Government Users Restricted Rights — Use, duplication or disclosure restricted by GSA ADP Schedule Contract.
Unpublished — All rights reserved under the Copyright Laws of the United States.
Document History Edition Part Number Operating System Version Date
First Edition 82348 A00 GUARDIAN A04/E05 October 1982
Second Edition 82348 B00 GUARDIAN A05/E06 April 1983
Update 1 82194 GUARDIAN A06/E07 December 1983
Update 2 82205 GUARDIAN B00/E08 March 1985
Third Edition 058057 GUARDIAN B00/E08 July 1991
The second edition of this manual, including updates 1 and 2, was reformatted in July 1991; no changes were made to the manual’s content at that time. The
reformatted manual became the third edition.
New and Changed Information
058057 Tandem Computers Incorporated iii
This update to the ENFORM Reference Manual describes the following principal
changes:
The @ CENTER-PAGE Option Variable clause now centers the entire report body
on the page. The CENTER clause centers items on the page independently of
@ CENTER-PAGE.
ENFORM now issues error message 123 when the file type given in the DDL
record description does not match the physical file type read by the query
processor.
The following areas have been clarified, and examples have been added:
Reserved words
Subscript ranges
Qualification aggregates and target records
BEGINS WITH and CONTAINS
Aggregates and scale
Display format and scale
Default display format
Default time display format
Conversion of a WHERE clause to conjunctive normal form
Examples of summary reports (with LIST statement)
Other minor technical and editorial changes have been made.
All changes from the last edition are marked with a revision bar in the margin. Each
page containing a change carries the message “March 1985” at the bottom of the page.
It is assumed that the user has already integrated the December, 1983 update package
into the manual.
New and Changed Information
iv 058057 Tandem Computers Incorporated
(This page left intentionally blank)
New and Changed Information
058057 Tandem Computers Incorporated v
Contents
058057 Tandem Computers Incorporated v
Preface xv
Notation Conventions xvii
Section 1 Introduction
ENFORM Terminology 1-1
Section 2 Running ENFORM
Interactive Mode 2-2
Noninteractive Mode 2-2
The Current Output Listing File 2-3
Pressing the Terminal BREAK Key 2-3
Logical File Assignments 2-5
Passing Parameters to Compiled Query Files 2-6
A Server Query Processor 2-6
The Command Interpreter ASSIGN Command 2-8
The Command Interpreter PARAM Command 2-8
The Command Interpreter QP Command 2-9
Example of Server Query Processor Creation 2-9
Generic Files 2-10
Generic Files and a Dedicated Query Processor 2-12
Generic Files and a Server Query Processor 2-13
Generic Files and the Current Output Listing File 2-13
Section 3 ENFORM Language Elements
Reserved Words 3-3
Special Characters 3-4
Comments 3-4
Statements 3-5
Clauses 3-5
Commands 3-5
Rules for Naming User-Defined Elements 3-6
Rules for Referencing Data Base Elements 3-6
Record Name References 3-6
Field Name References 3-6
Primary Key References 3-7
Contents
vi 058057 Tandem Computers Incorporated
Subscripts 3-9
Aggregates 3-12
Predefined Aggregates 3-14
User Aggregates 3-15
Target Aggregates 3-16
Target Aggregate with OVER ALL Syntax 3-16
Target Aggregate with OVER Syntax 3-17
Qualification Aggregates 3-18
Qualification Aggregate with OVER ALL Syntax 3-18
Qualification Aggregate with OVER Syntax 3-18
Qualification Aggregates and Target Records 3-19
Qualification Aggregate with Embedded WHERE Clause 3-21
Aggregates and Scale 3-21
Literals 3-22
Numeric Literals 3-22
String Literals 3-22
Arithmetic Expressions 3-23
Evaluation Order of Arithmetic Expressions 3-23
Scale Factor of the Result 3-24
Logical Expressions 3-24
Effect of Parentheses on Compound Logical Expressions 3-26
BEGINS WITH and CONTAINS 3-27
Range of Values in Logical Expressions 3-27
Pattern-Match in Logical Expressions 3-28
IF/THEN/ELSE Expressions 3-28
Parameters 3-29
User Variables 3-29
User Variable as a Target-item 3-30
A User Variable in Request-Qualification 3-32
User Tables 3-32
Arithmetic Overflow Conditions 3-32
Contents
058057 Tandem Computers Incorporated vii
Section 4 Statements
AT END Statement 4-3
Specifying a Field Name in an AT END Statement 4-3
Spacing Considerations 4-3
AT END Information for Current Report or All Reports 4-4
Cancelling Session-Wide AT END Information 4-4
AT START Statement 4-5
Specifying a Field Name in an AT START Statement 4-5
Spacing Considerations 4-5
AT START Information for Current Report or All Reports 4-6
Cancelling Session-Wide AT START Information 4-6
CLOSE Statement 4-7
The Effect of a CLOSE Statement on the Internal Table 4-7
DECLARE Statement 4-8
Declaring a User Aggregate 4-9
Declaring a User Variable or User Table 4-10
DELINK Statement 4-11
DICTIONARY Statement 4-12
Identifying the Location of the Dictionary 4-12
Clearing the Internal Table 4-13
EXIT Statement 4-14
FIND Statement 4-15
Output Record Dictionary Description 4-16
Group Definition and Sorting 4-17
Output Fields 4-17
Input Elements 4-19
Request-Qualification 4-20
Summary Records 4-20
Statements and Clauses that Do Not Apply to the FIND Statement 4-22
FOOTING Statement 4-23
Specifying a Field Name within a FOOTING Statement 4-23
Spacing Considerations 4-23
Footing for Current Report or All Reports 4-24
Cancelling Session-Wide Footing 4-24
LINK Statement 4-25
Duration of Link Established by LINK or LINK OPTIONAL
Statement 4-26
LINK Statement Considerations 4-26
Contents
viii 058057 Tandem Computers Incorporated
LINK OPTIONAL Statement Considerations 4-27
Rules for Using LINK OPTIONAL Statements 4-27
How ENFORM Handles “Non-Contributing” Record
Descriptions 4-28
LIST Statement 4-31
Input Record Description 4-33
Group Definition and Sorting 4-33
How Values Are Displayed in Report Columns 4-33
Request-Qualification 4-35
Conditional Printing 4-35
Summary Reports 4-35
Optional Clauses 4-37
OPEN Statement 4-39
Using OPEN AS A COPY OF 4-39
PARAM Statement 4-40
How ENFORM Treats Parameters 4-41
SET Statement 4-42
Initializing User-Defined Elements 4-43
Redefining Option Variables 4-43
SUBFOOTING Statement 4-44
Specifying Field Names within a SUBFOOTING Statement 4-44
Spacing Considerations 4-44
Subfooting for Current Report or All Reports 4-45
Cancelling Session-Wide Subfooting 4-45
SUBTITLE Statement 4-46
Specifying a Field Name within a SUBTITLE Statement 4-46
Spacing Considerations 4-46
Subtitle for Current Report or All Reports 4-47
Cancelling Session-Wide Subtitle 4-47
TITLE Statement 4-48
Specifying a Field Name within a TITLE Statement 4-48
Spacing Considerations 4-48
Title for Current Report or All Reports 4-49
Cancelling Session-Wide Title 4-49
Questo manuale è adatto per i seguenti modelli
1
Indice
Manuali Software popolari di altre marche
PS Audio
PS Audio PowerPlay Manuale del proprietario
Brady
Brady LOCKOUT PRO 3.0 Manuale di servizio
Avaya
Avaya Interaction Center Manuale utente
Texas Instruments
Texas Instruments TI-83 Plus Silver Edition Manuale
Novell
Novell GROUPWISE 8 - INTERNET AGENT Manuale utente
Oracle
Oracle Application 9i Manuale utente
Acer
Acer RDM Manuale utente
Canon
Canon Vixia HF21 Manuale utente
Canon
Canon ZR950 Manuale utente
Samsung
Samsung Auto Backup Manuale utente
Polycom
Polycom Vortex EF2201 Istruzioni per l'installazione e il funzionamento
Brocade Communications Systems
Brocade Communications Systems Brocade 8/12c Manuale utente