|
/ variable
|
This is called a slash variable or a special code character. A slash variable is a
character preceded by a slash, which specifies a named area in memory that
stores an assigned string or value. In Report-IV™, recognized /variables include:
/D system date/DAY
/d terminal date
/F file suffix
/I installation name, centered in a 40-character field
/I terminal ID
/O operator code. See Note: below.
/P page number
/R report name in LL-RRRRRR format
/r report title, centered in a 40-character field
/T current time in 12-hour, HH:MM AM/PM format
/t current time in 24-hour, HH:MM format
Note: Report functions also begin with a slash. The code /O is used as a
report function as well as a / variable.
|
|
/CTR
|
A /variable that specifies that a formula be centered in printing.
|
|
/CWnn
|
The code that specifies the pitch (number of characters per inch) to be printed.
It is usually associated with the report function /PC=. In a report, valid values
for CWnn include 10, 12, and 17, and must be defined in the printer table.
|
|
/D
|
A /variable that specifies the system date (DAY).
|
|
/d
|
A /variable that specifies the terminal date.
|
|
/EJECTnn
|
A report function that causes a form feed command to be executed if there are
fewer than nn lines present. The next line will be printed at the top of a new
page.
|
|
/F
|
A / variable that specifies a file suffix within Thoroughbred Report-IV™.
|
|
/FIELD
|
A report function that serves as a local or temporary Data Name, enabling a
value to be assigned to a Formula Window. In the example below, a value is
conditionally assigned to the window field (/FIELD):
IF CUS-STATE = "NJ" THEN /FIELD = "7%"
ELSE /FIELD = "EXEMPT"
If needed, you can set the field length:
/FIELD(4)
|
|
/I
|
A / variable that indicates an installation name.
|
|
/i
|
A / variable that indicates the terminal ID code.
|
|
/LINES n
|
A report function that specifies the number of lines in a text field to be printed.
The default is the entire text field.
|
|
/O
|
There are two definitions:
1. A Report Function that specifies that a line is to be omitted if it is blank.
2. A / variable that specifies the operator code.
|
|
/OLS
|
A report function that specifies that an alphanumeric Data Name is to omit
leading spaces.
|
|
/OTS
|
A report function that specifies that an alphanumeric Data Name is to omit
trailing spaces.
|
|
/P
|
A / variable that sets the page number.
|
|
/PC
|
Printer control
/PN= page number
/RL=n lines of report length set
/SKIP skip line
/SPACEn number of spaces
The slash is also used to begin variables, sometimes called special code
characters. The code /O is used for both a /variable and a report function.
|
|
/PC=
|
A report function that sends either a printer control code or a hex code to the
printer to set the printing mode. For example, both /PC=CW12 and /PC=$1C$
set the printer to 12 character-per-inch pitch.
|
|
/PN=" "
|
A blank value (/PN=" ") suppresses the page number.
|
|
/PN=n
|
A report function that sets the page number counter, enabling the report to
begin with any specified page number.
|
|
/R
|
A / variable that will print the library and report definition name in the following format: LL-RRRRRR.
|
|
/r
|
A / variable that specifies a report description.
|
|
/RL=n
|
A report function that sets the length of a report in lines per page. It provides
an automatic EJECT (form feed) command to the printer at the appropriate
places. /RL=0 suppresses any automatic EJECT.
|
|
/SKIP
|
A report function that causes the report to skip the line in which it occurs.
|
|
/SPACE=n
|
A report function that specifies the number of character spaces allotted to a Data
Name.
|
|
/T
|
A / variable that specifies the current time in 12-hour format (HH:MM AM/PM).
|
|
/t
|
A / variable that specifies the current time in 24-hr format (HH:MM).
|
|
4GL
|
See Fourth Generation Language.
|
|
ad hoc query
|
An ad hoc query is a temporary query, as opposed to a query that is saved for
re-use. It exists only for the purpose of displaying specific information at the
moment and is a casual use of the database. In Latin, ad hoc means
something created for a specific purpose (literally "toward this") and it can
imply something impromptu, temporary, or even spur-of-the-moment.
|
|
alphanumeric
|
Alphanumeric characters are used to specify data that consists of numerals,
alphabetic characters, and special characters.
|
|
array
|
An array is a group of two or more related numeric or string elements identified
by a single name. Each element of the array is identified by a unique
subscripted variable name.
|
|
audit file
|
An audit file contains records which identify the maintenance performed on a
data file. The default audit file in IDOL-IV™ is IDAUDT.
|
|
audit indicator
|
An audit indicator is used in a format to specify whether the system
automatically keeps track of the file maintenance performed on a field.
|
|
bridge file
|
A file created by Report-IV™ to serve as a connection between two files when the key of a file is not related to a previous file, but Data Names in the file are part of the previous files.
|
|
calculated fields
|
See formulas.
|
|
case-insensitive
|
Case-insensitive implies that the system ignores upper and lowercase
distinction in processing.
|
|
case-sensitive
|
Case-sensitive implies that the system takes upper and lowercase into
consideration during processing (e.g., SMITH does not equal smith).
|
|
CB
|
The line-type-designator-code for Control Break. It designates a line-type
defined in the CONTROL-SECTION and used in the REPORT-SECTION of a
report.
|
|
class
|
A class is a collective name for all definitions of one type. For example, the
format class contains format definitions.
In OPENworkshop™ Classes define a collection of Objects. Classes themselves
are collected into sets with common structures or behavior. For example, all
Views in OPENworkshop™ have similar behavior.
|
|
column
|
A column is a vertical division of display as opposed to a row. The word column is often used to describe the vertical, physical position of a screen or message. A column of data in a view represents a field of data for all records in the file.
The column data is displayed vertically in the query. A column contains information from a data name, although it is not just a data name. It can be a data name, but it can also be a calculation (expression) or a summary of a number of values in the data name.
|
|
command
|
A command is an instruction entered in a script. A command is also called a
statement or directive.
|
|
command-line
|
In the ENTRY-SECTION or REPORT-SECTION of a report definition, a line
that contains one or more commands to be executed, but not text or formulas.
It can be used for the line-types below:
H Header
F Footer
D Detail
CB Control Break
ST Subtotal Line
CT Computed Total
|
|
command-line option
|
A command added to a command-line to modify another command.
|
|
comment line
|
At least one optional line that contains comments and remarks, usually
providing identification or reference information about the report definition.
Comment lines do not print and begin with ! (exclamation point).
|
|
compile
|
The process of generating an executable program from a source script.
|
|
conditional
|
A conditional statement is a statement in which a condition is tested to
determine whether an action will be performed. A conditional statement is
used to conditionally execute other Script-IV commands.
|
|
conditional line
|
Example: CBnn? [text] [formulas]
|
|
continuation script
|
A continuation script serves as a continuation of a primary script or of another
continuation script.
|
|
CONTROL-SECTION
|
Third of the four report areas which must be present in a report definition. It
contains commands and the specification of conditions under which data will
be handled by these commands.
|
|
copy script
|
This script cannot be compiled by itself. When used in conjunction with the
INCLUDE command, this script can serve to save time and avoid duplication
when writing scripts. It usually contains a data environment or common
processing routine that is copied into another script when that script is being
compiled.
|
|
cross-index
|
A cross-index references a data file in an order other than the primary order.
Cross-indexing or sorting provides alternate ways of accessing records and
building relationships between data files.
|
|
CT
|
The line-type-designator-code for Computed Total break. It specifies a
line-type defined in the CONTROL-SECTION and used in the
REPORT-SECTION of a report. Multiple CT codes can be numbered from 0
through 99.
In the CONTROL-SECTION the code is specified as follows:
CTnnA WHEN . . .
!Accumulate
CTnnP WHEN . . . ,with text and formulas
!Print
CTnnM
!Multiple Accumulators
Both CTnnA and CTnnP can exist with the same number, but CTnnA and
CTnnM must be unique. The Print condition specifies the condition under
which the line is executed or printed, and the Accumulate condition specifies
conditions under which the specified data are accumulated.
CTnnM generates five accumulators:
CTnn(0) ! Count
CTnn(1) ! Total
CTnn(2) ! Average or mean
CTnn(3) ! Minimum (low value)
CTnn(4) ! Maximum (high value)
If the Data Name or expression is a string, only CTnn(0), Count, will function.
|
|
custom screen
|
The custom screen is created by the user rather than generated by the system.
Special code characters and display modes can be used in a custom screen.
|
|
custom view
|
The custom view is created by the user rather than generated by the system.
Special display functions and data organization options are provided in a
custom view.
|
|
D
|
The line-type-designator code for a detail line defined in the
REPORT-SECTION.
|
|
data
|
Data is another word for information.
|
|
data element
|
See Data Name.
|
|
data environment
|
This is the sequence and type of data definitions set up in memory for use by
the script. The data definitions can include link, screen, format, and data name
definitions, all of which must be specified at the beginning of the script. The
values in the data environment can change as the script is processed, but the
data environment size does not change.
|
|
data field
|
Within a record, this is the area allocated for a specific category of data.
|
|
data file
|
A data file is a collection of related data records that have been organized in a
specific manner.
|
|
data independence
|
Data independence is a result of defining the structure of data in a system
dictionary, independent of the program or script that uses it.
|
|
data name
|
A data name is the name of a unique field of data. For instance, CUS-CODE
and CUS-NUMBER are data names in the customer file. The terms item, field,
and data element are also used for data name.
A Data Name can be from 3 through 20 characters long, composed of any
combination of uppercase and lowercase letters, hyphens, and the numbers 0
through 9. Spaces are not allowed within a Data Name. Data Names are also
called data-elements.
|
|
database
|
A database is an organized collection of information, which can be stored in
computer data files.
|
|
database maintenance
|
Database maintenance refers to the act of adding, deleting, or updating records
on a central database.
|
|
database management system
|
A database management system denotes software that organizes and provides
access to a database. The Dictionary-IV™ database management system allows
you to create, maintain, and manipulate a database.
|
|
default value
|
The default value is an assumption made by the system when no choice is
specified. Default values are provided by the system in some cases, and must
be predefined by the developer in other situations.
|
|
define data name
|
See DN, under line-type.
|
|
definition
|
The word definition is used to refer to a component stored in the System
Dictionary. Screen, view, menu, message dictionary, help, report, and script are
definitions. A definition is a set of specifications used for a common task. The
specifications may describe an object that is to be used and its attributes or how
to accomplish a task.
|
|
definition name
|
A coded name of 1 through 6 characters which, when preceded by a
2-character Library Name, identifies an IDOL-IV™ definition.
|
|
definition pointers
|
Definition pointers are the field in a database definition that point to another
definition. Screens, views, and links all contain definition pointers.
|
|
description
|
An optional explanation or elaboration of the definition name, used in the
definition of a library, file, Link, report, and so on.
|
|
detail line
|
In a report, a line to be printed if it contains text or executed if it contains a
command or conditional command. The line type designator is D.
|
|
dictionary
|
1) The System Dictionary is a central storage for definitions, allowing definitions
to be accessed and shared by more than one application.
2) A message
dictionary stores messages by type and number for easy access. The individual
message dictionaries are stored in the System Dictionary.
|
|
Dictionary-IV™
|
Thoroughbred Dictionary-IV™ is the database maintenance component of
IDOL-IV™. It enables you to create and maintain a database definition
password, which prevents access to the report definition by unauthorized
users.
Dictionary-IV™ is the system dictionary component of IDOL-IV™, which allows you
to create and maintain definitions.
|
|
dimension
|
This term refers to the defined size of an array or a string variable.
|
|
direct file
|
In a direct file, records are identified and accessed by a key value. A key value
is a unique string value that corresponds to and is associated with the record.
|
|
DN
|
The line-type-designator code defined in the ENTRY-SECTION to specify a
data name definition for use in the current report only. This local data name
must not conflict with any data name in the Format, or with any reserved
Thoroughbred Basic word.
|
|
edit key
|
A key used to add, remove, or modify data, or to move the cursor on the
screen.
|
|
encapsulation
|
An Object may CONNECT to another OPENworkshop™ Object, and allow it to
perform the operations it needs. When it has finished, it may return a value.
It is the combination of these concepts that allows developers to reduce
application development and maintenance costs.
|
|
ENTRY-SECTION
|
First of the four report areas that must be present in a report-definition. It can
contain the line type designator codes DN, FN, I1, and T9.
|
|
EOF
|
The code that indicates end of file.
|
|
F
|
The line type designator code that specifies a footer in the report definition.
|
|
field
|
1) A record is made up of one or more fields. A field or data element is normally
the smallest unit manipulated by a database management system.
2) Each data
element of a record is entered into a corresponding field on a data entry screen.
See data field.
|
|
field separator
|
A field separator is a single character (hexadecimal $8A$) that marks the end of
one unit and beginning of another unit in a data record. This allows the contents
of two or more data elements to be treated as a single unit by a Thoroughbred
Basic program. Field separators are not required in IDOL-IV™.
|
|
file
|
A file is a group of logically related records that are handled as a unit.
|
|
file access option
|
In a Link, any of several sets of criteria for selecting records to be accessed,
for sorting the sequence of access, or both. Valid options follow:
KEY RANGE specifies a range of key values from which records in a DIRECT
file are accessed.
SELECT WHEN sets conditions under which a record is accessed.
SORT BY specifies that data sorted by the specified rules already exist in the
data file to be used.
SORT BY USING specifies a rule or condition by which records in a file are
sorted for subsequent access.
DATA FILE IS specifies a data file to use rather than the file name contained
in the Link. You can open a single Link and override the standard data file by
reopening the Link with the DATA-FILE option.
|
|
file suffix indicator
|
This indicator is the @ character. It can be specified in data, sort, or text file
names, either in the link definition or in the DATA-FILE IS, SORT-FILE IS, or
TEXT-FILE IS clauses of the OPEN command.
|
|
FILE-SECTION
|
Second of the four report areas which must be present in a report definition. It
only contains the file definition line type LN. See LN.
|
|
format
|
A format defines data elements and/or the record format of a data file (the
structure of data in a record of a file). Optional information includes whether the
data will be numeric or alphanumeric and which elements have special
characteristics and processing rules.
|
|
format name [FN]
|
In the ENTRY-SECTION of a report definition, a coded name of 1 through 6
characters which, when combined with a two-character library name, identifies
a report.
|
|
formula
|
A formula is used to create a computed data element field. A computed data
element field is created in a screen definition by using any of the data elements
from the format in an expression.
A specified data item or calculation to be included in a report. It is located in the
REPORT-SECTION.
|
|
fourth generation language
|
A Fourth Generation Language (4GL) is known as a "high-productivity
development language" rather than a programming language. It is a system of
integrated tools designed to be used for developing interactive, online, multi-
user business applications.
|
|
function key
|
One of a series of keys that produce operations rather than characters on the
screen. They are identified by the letter F and a number, for example, F1 or F2.
Their action depends on the software in use at the time.
|
|
global dictionary
|
The Global Dictionary can be created in Dictionary-IV and contains an
alphabetical listing of data elements and their specifications. The purpose of the
dictionary is to provide predefined data elements which can be used in defining
formats.
|
|
group function
|
A group function, also known as an aggregate, or set function, is a predefined
operation that is built into the query language. It operates on an entire column,
or groups of values in a column, and returns a single value. Group functions
make it easy to find the sum of the values, average of the values, or the
minimum or maximum value in the group.
|
|
H
|
The code that specifies a header line-type in the REPORT-SECTION of a
report definition.
|
|
help
|
Defines context-sensitive, online help for menus, database maintenance, data
entry, and messages. Online help is available everywhere the system is
waiting for the operator to enter something. Pressing F6 will display an
information window if a help module was created in the System Dictionary.
Online help is available wherever the system is waiting for you to enter
something. A help network is available within the script editor, providing
information on IDOL-IV™ dictionary definitions, formats, message dictionaries,
help modules, links, libraries, menus, screens, views and scripts. Press the F6
key to get help.
|
|
I1nn
|
The line-type designator code for a command set to be executed before a
report is produced. It is located only in the ENTRY-SECTION of a file
definition. It can consist of valid data names, references to initialization or
termination commands, and appropriate Thoroughbred Basic syntax. The
symbol nn indicates numbers from 01 through 99, producing commands
numbered from 101 through 199. It is known as an initialize command.
Compare with T9nn.
|
|
IDOL-IV™
|
IDOL-IV™ is the name of Thoroughbred's 4GL-based application development
products. IDOL-IV™ includes a database management system (Dictionary-IV™), a
4GL programming language (Script-IV), a report generator (Report-IV™), and an SQL query and information retrieval system (Query-IV™).
|
|
index file
|
In an index file, records are identified by index number, this number refers to
the sequential position, or number of the record within the file. Each record is of
a specific length and may be accessed either sequentially or randomly by index
value.
|
|
indexed file
|
One of several kinds of data files. An indexed file contains data but no primary
key field. Its records are stored and accessed by record number or index
number, and are processed either sequentially or randomly by index value.
See direct file and sort file.
|
|
inheritance
|
In OPENworkshop™ all Classes are created and modified incrementally, and any
definition created is interpreted consistently wherever it is referenced.
OPENworkshop™ Formats and Links are used to collect these definitions
together.
|
|
initialize command
|
A coded command in the ENTRY-SECTION of a report definition, which
specifies operations to be carried out before a report is produced. The
commands are numbered from I101 through I199. See I1nn.
|
|
input message
|
This is a message type stored in a message dictionary. The input message is different from the other message types in that you can specify the following input parameters: input length, input window length, fixed or variable length input, mandatory or optional input, padding type, numeric type, date type, and
valid entries. User responses are restricted by the input parameters.
|
|
input/output (I/O)
|
This term refers to the process of entering data into the computer or of
transferring data from the computer to a printer, terminal, or storage medium.
The Script-IV commands PRINT and INPUT handle all terminal input/output.
The commands ADD, CHANGE, DELETE, and READ handle file input/output.
|
|
integer
|
An integer is any number in the set of all positive and negative whole
numbers, including zero.
|
|
join
|
A join is when two related files are connected together through a common data
name, or join column. The data from both files can be selected in the query.
|
|
key
|
A unique string value that corresponds to and is associated with a record. It
can be used to link data from two or more files. This term may or may not be
capitalized.
A key data element determines the position of a record in a sorted sequence
and can be used to access a record.
Any key on a computer keyboard.
|
|
key (foreign)
|
A foreign key is a data field in a file that is also used as the primary key of
another file, providing a way to connect the files.
|
|
key (primary)
|
A primary key Data Name defines the order of the elements in the physical
data file.
|
|
key (secondary)
|
A secondary key is used to order rows in a query and is created by a Sort
definition.
|
|
key preset value
|
A system-generated preset value used in a Key.
|
|
KEY RANGE
|
In a file definition line-type, the range of Key values that can be accepted from
the accessed record. It consists of a range of the specified lowest and highest
acceptable values.
|
|
key value
|
A unique string value that corresponds to and is associated with a record. It
can be used to link records from two or more files.
|
|
library
|
Libraries are used to organize and maintain groups of definitions. Libraries
grouped definitions into convenient associations based on the first two
characters of the definition name.
A collection of files, programs, or subroutines identified in Thoroughbred
software by a two-character string. A library organizes and maintains Links,
report definitions, Screen and View definitions, and so on.
IDOL-IV™ definitions and scripts are grouped into libraries for easy categorization
and maintenance. The name of each library component is made up of the
2-character library name followed by the name of the component.
|
|
library name
|
A 2-character code that identifies a Library. It forms the first two characters
of the names of formats, links, reports, and other components created within a
library.
|
|
line
|
See Row.
|
|
line option
|
A command available to control the execution of another command or the
appearance of a printed line.
|
|
line type
|
The functional nature of a line in a report. Line-type is indicated by a line-type
designator, a one-character or two-character code (sometimes followed by a
number, a command line option, or both) entered at the left margin of the line.
It can specify text or data to be printed, or one or more commands to be
carried out in generating a report.
|
|
line-type designator
|
The one-character or 2-character command code that specifies the line-type
of a line in the report definition.
|
|
link
|
A link defines an IDOL-IV™ interface to a data file, linking the data file to the
format and providing file-level security and secondary key definitions.
Links are defined in Dictionary-IV™. They are used in reports to access data files. The Link contains the name of the file that is to be accessed, the name of the
Format that describes the record layout, and all sorting that has been defined
for the file.
|
|
link name
|
A coded name of 1 through 6 characters which, when combined with a
2-character library name, identifies a Link.
|
|
link/file
|
In Thoroughbred Query-IV™, the Link is a synonym for a data file. The data file
must be specified in the query.
|
|
LN
|
The line-type designator code used to specify the IDOL-IV™ Link or the
Report-IV™ Link to be accessed, and any options that govern selection or
sorting. Link options are:
LNC
LNU
LNu
LNX
LNS
|
|
local data name
|
A temporary Data Name defined for use in the current report only, as
distinguished from a Data Name in the Format, which is available to many
reports. Its line-type designator code is DN.
|
|
logical format
|
In menus or scripts, a format can be used independently of a data file or link.
This type of format is referred to as a logical format because it has no one
physical referent; a logical format functions similar to data names or variables.
|
|
logical screen
|
A logical screen is used with a logical format to collect data independently of a
data file or link.
|
|
lookup file
|
A key value can be used to access data in a lookup file. If the key matches a
key in the file, the record can be read or compared, etc.
|
|
mandatory field
|
A mandatory field in data entry requires that you enter data before processing
to the next field. Data must be entered in all mandatory fields before the record
can be added.
|
|
masking
|
Masking is a method used to Format output by screening the data according to
the code specifications.
|
|
masks
|
IDOL-IV™ contains two types of masks: output format masks and selection
masks. An output format mask specifies the format in which numeric data is
displayed or printed. A selection mask specifies a name format used to screen
items for selection.
|
|
menu
|
An IDOL-IV™ menu definition specifies the operation of menu selections. The
menu consists of two parts: a screen image that displays a listing of selections
and a menu definition describing the operation of each selection. Menu
selections can include running programs, starting special procedures or
database maintenance, or calling up other menus. Each selection is associated
with a selection code and the information necessary to initiate the selection.
|
|
menu trail
|
A menu trail is created as you move from menu to menu in an application. The
F4 key will always take you to the previous menu in the menu trail.
|
|
message
|
Messages can be created and maintained in Dictionary-IV™ message
dictionaries. These messages can be used in all IDOL-IV™ applications.
|
|
message dictionary
|
The message dictionary is used to define prompt/constant, non-input, yes/no,
and input messages. Using the message dictionary enables you to avoid
placing messages in a script, so user communication can be controlled
externally rather than by modifying procedural code.
The type of message determines the degree of operator input allowed from the
message. The message is accessed by specifying the dictionary name,
message type, and message number.
|
|
method
|
OPENworkshop™ Methods perform operations on Data-names. Some specific
types of operation are identified for particular support by OPENworkshop™,
including:
Pre- and Post-Processing Methods prepare an Object for modification by the
end-user and validate the data afterwards.
Insert Methods assist in creating a new Object.
I/O triggers validate the database and ensure that updates are performed
consistently.
|
|
mode
|
A mode is a method or condition of operation such as the maintenance mode
Add, Change, and Delete.
|
|
multiple occurrence
|
Multiple occurrences provide the ability to define a single data element that
repeats a number of times rather than defining several identical data elements.
Multiple occurrence data elements can be defined in a format. The data name is
referenced by the occurrence number and data entry to this data element could
include all occurrences.
|
|
multi-tasking conflict processing
|
Multi-tasking conflict processing prevents simultaneous access of IDOL-IV™
menu selections.
|
|
non-input message
|
This is a message type stored in a message dictionary. A non-input type
message allows a greater degree of operator response than a prompt/constant
message. You can specify help for the message as well as the position and
display mode. The user is required to press Enter to continue. User responses
allowed from this message type are: Enter, F4, and F6.
|
|
numeric value
|
A numeric value is any constant, variable, or expression that represents a
number.
|
|
object
|
OPENworkshop™ allows the developer to store information that reflects the
properties of real world items in Data-names. The operations that may
manipulate the data are defined in Methods and are associated with the Data-
name.
|
|
overlay script
|
This script serves as an overlay to a primary, continuation, or another overlay
script. You can execute this script by using the RUN OVERLAY script-name
command.
|
|
padding
|
A technique used to fill out a fixed-length block of information with dummy
characters.
|
|
parameters
|
A parameter in command syntax is a symbol that will be replaced by a supplied
value when the command is used by an operator.
|
|
persistence
|
The value of data remains after the Class or Method that created it no longer
exists. An example is Data Objects that can be stored in files, which is the
ultimate form of persistence.
|
|
physical format
|
A physical format is linked to a data file through the link definition. A physical
format describes a record and the data elements in the record along with their
characteristics, default values, valid values, and related data entry restrictions.
|
|
physical fcreen
|
A physical screen is a screen that uses a physical format.
|
|
polymorphism
|
An expression or message can operate on Objects of different Classes. This
type of re-useable code greatly reduces development and maintenance costs.
|
|
pre/post-entry processing
|
Pre- and post-entry processes are programs or scripts which contain special
processing to be executed either before or after data is input.
|
|
pre/post-public script
|
This script serves as a before or after input procedure. They are used only in
IDOL-IV™ file maintenance.
|
|
preset value
|
A preset value specified for a data element in a format is unconditionally used
as the value for a data element in all records. A preset value is defined by
specifying a default value for the data element and a security type of three (no
operator input).
|
|
primary key
|
A primary key is a unique identifier for a record. It also determines the position
of the record in the primary sorted sequence and can be used to access a
record. You can use a number of primary key data elements to form a multi-part
key, but they must be the first data element defined in the format.
|
|
primary script
|
This general purpose script is used as a starting point for processing. This
script initializes the data environment used by the script.
|
|
procedure
|
A procedure is a subroutine that is defined in the script. The procedure is
executed when the procedure name is specified in a DO, input/output process,
and other commands that require a procedure. The procedure name must be
located in the leftmost column of the first line of the subroutine.
|
|
prompt/constant message
|
This is a message type stored in a message dictionary. A prompt/constant
message is the simplest message type. The position, display mode, link
clearing, and message content are specified. No user response is allowed and
online help is not available.
|
|
public script
|
This script serves as an independent subroutine to a primary, continuation,
overlay, or another public script.
|
|
record
|
lection of one or more related fields of data treated as a unit. It
is stored in a data file.
A record is the description of an item in a database, where each item is
represented by a record that consists of one or more fields.
|
|
record layout
|
The record layout is the arrangement and structure of records in a database,
including the size and sequence of its components.
|
|
recursive
|
The ability to interrupt an action to undertake another action or subroutine, and
then to interrupt this again with the same subroutine and so on. For the
Thoroughbred Environment this is equivalent to Public Programs.
|
|
related file
|
Files are related when a file with a key that is the same as the Data Name in
another file. There could be multiple related files.
|
|
relational database
|
A relational database is a database in which some data items in one record
refer to records in another file. Relational databases give the user the flexibility
to create a relationship between information stored in many files. It allows you
to interchange and cross-reference information between two different type of
records.
|
|
relational operators
|
An operator that compared two strings, variables, or constants
(>,<,>=,=>,<=,=<,<>, and ><).
|
|
report area
|
Any one of the four required sections of a report-definition:
ENTRY-SECTION
FILE-SECTION
CONTROL-SECTION
REPORT-SECTION
which must be present in this order.
|
|
report command
|
A command in the ENTRY-SECTION or REPORT-SECTION of the report
definition. It can consist of one or more data names, report functions,
Thoroughbred Basic commands, or any combination of these.
|
|
report definition
|
A complex set of formally arranged specifications which, when processed by
Thoroughbred Report-IV™, produces a report arranged according to the
specifications.
|
|
report description
|
See description.
|
|
report function
|
An optional component of a report command, specified in the
ENTRY-SECTION or REPORT-SECTION on a command line or within a
formula. Report functions are:
/CTR center printing
/EJECT eject page /form feed
/EJECTnn eject page if fewer lines than nn
/FIELD temporary area
/LINES n number of text field lines
/O omit line if blank
/OLS omit leading spaces
/OTS omit trailing spaces
|
|
Report-IV™
|
Thoroughbred Report-IV™ is the report generator that is part of IDOL-IV™. Report
definitions are saved and stored in the System Dictionary.
|
|
REPORT-SECTION
|
The last of the four report areas that must be specified in a report definition. It
can contain the line-types H, F, D, CB, ST, and CT.
|
|
row
|
A row or line is a horizontal division of display as opposed to a column. The line
position is one coordinate which determines display placement. A line of data in
a view represents one record from the file.
A row can even be a summary of a number of records.
|
|
RUN PUBLIC
|
A Thoroughbred Script-IV command that executes a public script when
specified in the REPORT-SECTION of the report definition.
|
|
schema
|
A schema is a schematic diagram of a database which shows the relationships
among various files. Often the data required to complete your query or request
resides in multiple files. Query-IV™ allows you to select multiple files with just
the data names necessary to complete the schema. A single schema definition
can be used for multiple related files using selected data-names from
associated files, while the Link definition is designed for a single data file and
Format.
|
|
screen
|
A screen defines a video display image used for a menu, data entry, single-
record database maintenance, or other display purposes.
|
|
script
|
A script defines a procedure written in the Script-IV programming language,
which uses definitions from the System Dictionary and describes the operation
of an application. Scripts are maintained using a full-screen editor and are
integrated with the other 4GL tools in the system.
|
|
Script-IV
|
Thoroughbred Script-IV is the fourth generation programming language which is
an integral part of the IDOL-IV™ system. Script-IV can access the database and
System Dictionary as well as perform many of the tasks associated with
programming.
|
|
scrolling
|
Scrolling refers to the movement of data on a video display. This movement of
text is repeated until the desired spot in the text has been reached. Scrolling
refers to the ability to move text from right to left and left to right as well as
upward and downward.
|
|
secondary key
|
Secondary keys are used to access data file in an order other than the primary
key order. Unlike primary keys, in IDOL-IV™ secondary keys do NOT have to be
a unique identifier. Secondary keys are defined with SORT command and can
be used to sort and access the file in different ways.
|
|
security
|
Security, as it is used in this manual, is the state achieved by software or data
as a result of successful efforts to prevent damage, corruption, access, or
modification.
|
|
select message
|
Select messages are a special type of input message. They can be specified to
display multiple selections and allow the operator to cursor through the
message, highlighting each selection. Pressing Enter makes a selection.
|
|
SELECT WHEN
|
An option in a file-definition line-type that specifies a rule or condition under
which a record is accessed or skipped. See WHEN condition.
|
|
selection code
|
A selection code is defined for each selection in a menu definition. The code is
used by an operator to initiate a menu selection from the menu.
|
|
slash variable
|
See report function and / variable.
|
|
sort
|
To sort is to arrange records according to a logical system. Records can be
sorted in many different ways depending on the way you wish to access the
data.
A sort is used to order the rows produced by the query. There are 2 types of
sorts: predefined and temporary. A predefined sort is identified by a sort
number and is created in Thoroughbred IDOL-IV™, producing an existing order
for the rows that can then be selected in a query. A temporary sort is created in
Thoroughbred Query-IV™ and orders the rows when the query is executed. Using
a temporary sort with a data file that is very large may cause a delay when the
query is executed and before the query table is produced.
|
|
SORT BY
|
An option in a file-definition line-type that specifies a rule or condition by which
records in a file are sorted for subsequent access. It is possible to select a
previously saved sort file.
|
|
sort file
|
Sort files contain no data, only key values for the records. When you define
sorts for a data file, the secondary keys are stored in a sort file. Sort files are
used as convenient means of accessing data in a sorted fashion.
See also direct file and indexed file.
|
|
SORT FILE IS
|
Specifies a sort file to use rather than the file name contained in the Link.
|
|
special code character
|
Another name for a / variable. See / variable.
|
|
specification
|
Specifications, as used in this manual, refer to the attributes of a System
Dictionary definition (e.g., format specifications include length, numeric type,
and padding).
|
|
SQL (Structured Query Language)
|
The trademarked query language developed by IBM. It has become an
international industry standard.
|
|
ST
|
The line-type designator code for a Subtotal Break. It is defined in the
CONTROL-SECTION and used in the REPORT-SECTION of the report
definition.
|
|
string
|
A string is a connected sequence of characters that are treated as one piece of
data.
|
|
string variable
|
A string variable is a data name that can contain alphanumeric data.
|
|
structural integrity
|
Structural integrity refers to the accuracy, consistency, and completeness of
data and definitions that are maintained by the system.
|
|
substring
|
A substring is a portion of a string.
|
|
syntax
|
Syntax refers to the rules governing the structure of a language and its
expressions.
|
|
system dictionary
|
The System Dictionary is a central storehouse of structured information that can
be shared by programs. It contains data definitions as well as other types of
definitions, such as formats, screens, views, menus, message dictionaries, help
modules, reports, and scripts. These serve as the building blocks for both
database management and software development.
|
|
T9nn
|
The line-type designator code for a command set to be executed after a report
is produced. It is located in the ENTRY-SECTION of a file definition. It can
consist of valid data names, references to termination commands, and
appropriate Thoroughbred Basic™ syntax. The symbol nn indicates numbers
from 01 to 99, producing commands numbered from 901 through 999. It is
known as a terminate command. Compare with I1nn.
|
|
table
|
A table is a result of a query. It can be thought of as a logical view of the data
produced in vertical columns and horizontal rows. A table can contain data
from more than one file, as well as calculated data that does not come directly
from a file. The simplest table is one with a single column and a single row.
|
|
terminate command
|
A coded command in the ENTRY-SECTION of a report definition, which
specifies operations to be carried out after a report is produced. The
commands are numbered from T901 through T999. See T9nn.
|
|
text
|
At least one more alphanumeric character to be printed in a report. Text can
be words, phrases, numerals, and so on.
|
|
text field/text fields
|
Text fields are used for storing large amounts of text or text that may vary in
size from one data record to another. The text is entered into a window and
edited. Text fields do not affect the size of the data record and more than one
text field can exist in a format.
|
|
Thoroughbred Basic™ syntax
|
The rules that specify how the symbols of Thoroughbred Basic™ are put
together to produce commands, data, and so on, in a form usable by a
computer.
|
|
valid entry
|
A valid entry is data which is screened by the system before it is accepted. A
valid entry is often referred to as a valid value.
|
|
value
|
A value is a constant or quantity.
|
|
variable
|
A variable is a quantity that does not have fixed value.
A variable is used to store and manipulate data. It is elastic in nature. Variable
data exists outside of the data environment and is used to manipulate variable
size data.
|
|
verification
|
Verification is a process which checks to see that a procedure has been
accomplished accurately or reaffirms an operation.
|
|
view
|
A view defines a video display image used for multi-record database
maintenance and multi-record interactive windowing.
|
|
WHEN condition
|
An option available in the CONTROL-SECTION, where it governs Control,
Subtotal, and Computed Total Breaks, and the FILE-SECTION, where it
governs LN. It imposes a condition of literal values, data names, mathematical,
string, or logical operators. If the condition is evaluated as true, the specified
line or action is initiated.
|
|
window
|
A window is an independently controlled part of the video display screen that
can display information and interact with the user. It is usually dedicated to a
specific purpose, such as a text field or help window.
|
|
work file
|
A work file is a temporary file which is a copy of a source file or part of a source
file. Changes to the work file do not affect the source file.
|
|
yes/no message
|
This is a message type stored in a message dictionary. A yes/no message is
different from a non-input message in that the user is required to answer "yes"
or "no" in response to the message. User responses allowed are: Y, y, N, n, F4,
and F6.
|
