This glossary defines terms as they are used throughout
the QMF library.
- abend
- The abnormal termination of a task.
- ABENDx
- The keyword for an abend problem.
- Advanced Peer-to-Peer Networking(R)
- A distributed network and session control architecture that
allows networked computers to communicate dynamically as equals. Compare
with Advanced Program-to-Program Communication (APPC). An implementation
of the SNA synchronous data link control LU 6.2 protocol that allows interconnected
systems to communicate and share the processing of programs.
- Advanced Program-to-Program Communication (APPC)
- An implementation of the SNA synchronous data link control
LU 6.2 protocol that allows interconnected systems to communicate
and share the processing of programs.
- aggregation function
- Any of a group of functions that summarizes data in a column. They
are requested with these usage codes on the form panels: AVERAGE,
CALC, COUNT, FIRST, LAST, MAXIMUM, MINIMUM, STDEV, SUM, CSUM, PCT,
CPCT, TPCT, TCPCT.
- aggregation variable
- An aggregation function that is placed in a report using either
the FORM.BREAK, FORM.CALC, FORM.DETAIL, or FORM.FINAL panels. Its
value appears as part of the break footing, detail block text,
or final text when the report is produced.
- alias
- In DB2 UDB for OS/390(R),
an alternate name that can be used in SQL statements to refer to
a table or view in the same or a remote DB2 UDB for OS/390 subsystem.
In OS/2(R), an
alternate name used to identify a object, a database, or a network
resource such as an LU. In QMF,
a locally defined name used to access a QMF table
or view stored on a local or remote DB2 UDB for OS/390 subsystem.
- APAR
- Authorized Program Analysis Report.
- APPC
- Advanced Program-to-Program Communication
- application
- A program written by QMF users
that extends the capabilities of QMF without
modifying the QMF licensed
program. Started from a QMF session
by issuing a RUN command for a QMF procedure,
an installation-defined command, or a CMS or TSO command that invokes
an EXEC or CLIST, respectively.
- application requester
- (1) A facility that accepts a database request from an application process
and passes it to an application server. (2) In DRDA(R),
the source of a request to a remote relational database management
system.
The application requester is the DBMS code that handles the QMF end
of the distributed connection. The local DB2 UDB for OS/390 subsystem
to which QMF attaches
is known as the application requester for QMF,
because DB2 UDB for OS/390's
application requester is installed within the local database manager.
Therefore, an entire DB2 UDB for OS/390 subsystem
(including data) is associated with the application requester, but
the SQL statements are processed at the current location. This subsystem
is called the "local DB2 UDB for OS/390".
With DB2 for
VM and VSE the application requester runs in the same virtual machine
as QMF;
that is, no database is inherently associated with the DB2 for
VM and VSE application requester.
- application server
- The target of a request from an application requester. (1)
The local or remote database manager to which the application process
is connected. The application server executes at the system containing
the desired data. (2) In DRDA,
the target of a request from an application requester. With DB2 UDB for OS/390,
the application server is part of a full DB2 UDB for OS/390 subsystem.
With DB2 for
VM and VSE, the application server is part of a DB2 for
VM and VSE database machine.
- application-support command
- A QMF command
that can be used within an application program to exchange information
between the application program and QMF.
These commands include INTERACT, MESSAGE, STATE, and QMF.
- area separator
- The barrier that separates the fixed area of a displayed report
from the remainder of the report.
- argument
- An independent variable.
- base QMF environment
- The English-language environment of QMF,
established when QMF is
installed. Any other language environment is established after installation.
- batch QMF session
- A QMF session
running in the background. Begins when a specified QMF procedure
is invoked and ends when the procedure ends. During a background QMF session,
no user interaction and panel display interaction are allowed.
- bind
- In DRDA,
the process by which the SQL statements in an application program
are made known to a database management system over application
support protocol (and database support protocol) flows. During a
bind, output from a precompiler or preprocessor is converted to
a control structure called a package. In addition, access paths to
the referenced data are selected and some authorization checking
is performed. (Optionally in DB2 UDB for OS/390,
the output may be an application plan.)
- built-in function
- Generic term for scalar function or column function. Can also
be "function."
- calculation variable
- CALCid is a special variable for forms that contains a user-defined calculated
value. CALCid is defined on the FORM.CALC panel.
- callable interface
- A programming interface that provides access to QMF services.
An application can access these services even when the application
is running outside of a QMF session.
Contrast with command interface.
- chart
- A graphic display of information in a report.
- CICS(R)
- Customer Information Control System.
- client
- A functional unit that receives shared services from a server.
- CMS
- Conversational Monitor System.
- column
- A vertical set of tabular data. It has a particular data type (for
example, character or numeric) and a name. The values in
a column all have the same data characteristics.
- column function
- An operation that is applied once to all values in a column,
returns a single value as a result, and is expressed in the form
of a function name followed by one or more arguments enclosed in
parentheses.
- column heading
- An alternative to the column name that a user can specify
on a form. Not saved in the database, as are the column name and
label.
- column label
- An alternative descriptor for a column of data that is saved
in the database. When used, column labels appear by default on the
form, but they can be changed by users.
- column wrapping
- Formatting values in a report so that they occupy several
lines within a column. Often used when a column contains values
whose length exceeds the column width.
- command interface
- An interface for running QMF commands.
The QMF commands
can only be issued from within an active QMF session.
Contrast with callable interface.
- command synonym
- The verb or verb/object part of an installation-defined command. Users
enter this for the command, followed by whatever other information
is needed.
- command synonym table
- A table each of whose rows describes an installation-defined command.
Each user can be assigned one of these tables.
- commit
- The process that makes a data change permanent. When a commit
occurs, data locks are freed enabling other applications to reference
the just-committed data. See also "rollback".
- concatenation
- The combination of two strings into a single string by appending
the second to the first.
- connectivity
- The enabling of different systems to communicate with each
other. For example, connectivity between a DB2 UDB for OS/390 application
requester and a DB2 for
VM and VSE application server enables a DB2 UDB for OS/390 user
to request data from a DB2 for
VM and VSE database.
- conversation
- A logical connection between two programs over an LU 6.2 session
that allows them to communicate with each other while processing
a transaction.
- correlation name
- An alias for a table name, specified in the FROM clause of
a SELECT query. When concatenated with a column name, it identifies
the table to which the column belongs.
- CP
- The Control Program for VM.
- CSECT
- Control section.
- current location
- The application server to which the QMF session
is currently connected. Except for connection-type statements, such
as CONNECT (which are handled by the application requester), this
server processes all the SQL statements. When initializing QMF,
the current location is indicated by the DSQSDBNM startup program
parameter. (If that parameter is not specified, the local DB2 UDB for OS/390 subsystem
- current object
- An object in temporary storage currently displayed. Contrast
with saved object.
- Customer Information Control System (CICS)
- An IBM(R) licensed
program that enables transactions entered at remote terminals to
be processed concurrently by user-written application programs.
It includes facilities for building, using, and maintaining databases.
- DATA
- An object in temporary storage that contains the information
returned by a retrieval query. Information represented by alphanumeric
characters contained in tables and formatted in reports.
- database
- A collection of data with a given structure for accepting,
storing, and providing on demand data for multiple users. In DB2 UDB for OS/390,
a created object that contains table spaces and index spaces. In DB2 for
VM and VSE, a collection of tables, indexes, and supporting information
(such as control information and data recovery information) maintained
by the system. In OS/2,
a collection of information, such as tables, views, and indexes.
- database administrator
- The person who controls the content of and access to a database.
- database management system
- A computer-based system for defining, creating, manipulating,
controlling, managing, and using databases. The database management system
also has transaction management and data recovery facilities to
protect data integrity.
- database manager
- A program used to create and maintain a database and to communicate
with programs requiring access to the database.
- database server
- (1) In DRDA,
the target of a request received from an application server (2)
In OS/2,
a workstations that provides database services for its local database
to database clients.
- date
- Designates a day, month, and year (a three-part value).
- date/time default formats
- Date and time formats specified by a database manager installation
option. They can be the EUR, ISO, JIS, USA, or LOC (LOCAL) formats.
- date/time data
- The data in a table column with a DATE, TIME, or TIMESTAMP
data type.
- DB2 UDB for OS/390
- DB2 Universal Database for OS/390(TM) (an IBM relational
database management system).
- DB2 for AIX(R)
- DATABASE2 for AIX.
The database manager for QMF's
relational data.
- DBCS
- Double-byte character set.
- DBMS
- Database management system.
- default form
- The form created by QMF when
a query is run. The default form is not created if a saved form
is run with the query.
- destination control table (DCT)
- In CICS,
a table containing a definition for each transient data queue.
- detail block text
- The text in the body of the report associated with a particular
row of data.
- detail heading text
- The text in the heading of a report. Whether or not headings
will be printed is specified in FORM.DETAIL.
- dialog panel
- A panel that overlays part of a Prompted Query primary panel
and extends the dialog that helps build a query.
- distributed data
- Data that is stored in more than one system in a network,
and is available to remote users and application programs.
- distributed database
- A database that appears to users as a logical whole, locally accessible,
but is comprised of databases in multiple locations.
- distributed relational database
- A distributed database where all data is stored according to
the relational model.
- Distributed Relational Database Architecture(TM)
- A connection protocol for distributed relational database
processing that is used by IBM and
vendor relational database products.
- distributed unit of work
- A method of accessing distributed relational data in which users
or applications can, within a single unit of work, submit SQL statements
to multiple relational database management systems, but no more
than one RDBMS per SQL statement.
DB2 UDB for OS/390 introduced
a limited form of distributed unit of work support in its V2R2 called
system-directed access, which QMF supports.
- DOC
- The keyword for a document problem.
- double-byte character
- An entity that requires two character bytes.
- double-byte character set (DBCS)
- A set of characters in which each character is represented
by two bytes. Languages such as Japanese, Chinese, and Korean, which contain
more symbols that can be represented by 256 code points, require
double-byte character sets. Because each character requires two
bytes, the typing, display, and printing of DBCS characters requires
hardware and programs that support DBCS. Contrast with single-byte
character set.
- DRDA
- Distributed Relational Database Architecture.
- duration
- An amount of time expressed as a number followed by one of
seven keywords: YEARS, MONTHS, DAYS, HOURS, MINUTES, SECONDS, MICROSECONDS.
- EBCDIC
- Extended Binary-Coded Decimal Interchange Code.
- echo area
- The part of the Prompted Query primary panel in which a prompted
query is built.
- EUR (European) format
- A format that represents date and time values as follows:
- Date: dd.mm.yyyy
- Time: hh.mm.ss
- extended syntax
- QMF command
syntax that is used by the QMF callable
interface; this syntax defines variables that are stored in the
storage acquired by the callable interface application and shared
with QMF
- example element
- A symbol for a value to be used in a calculation or a condition
in a QBE query.
- example table
- The framework of a QBE query.
- fixed area
- That part of a report that contains fixed columns.
- fixed columns
- The columns of a report that remain in place when the user
scrolls horizontally. On multiple-page, printed reports, these columns
are repeated on the left side of each page.
- form
- An object that contains the specifications for printing or
displaying a report or chart. A form in temporary storage has the
name of FORM.
- function key table
- A table containing function key definitions for one or more QMF panels,
along with text describing the keys. Each user can be assigned one
of these tables.
- gateway
- A functional unit that connects two computer networks of different
network architectures. A gateway connects networks or systems of
different architectures, as opposed to a bridge, which connects
networks or systems with the same or similar architectures.
- GDDM(R)
- Graphical Data Display Manager.
- global variable
- A variable that, once set, can be used for an entire QMF session.
A global variable can be used in a procedure, query, or form. Contrast
with run-time variable.
- Graphical Data Display Manager
- A group of routines that allows pictures to be defined and
displayed procedurally through function routines that correspond
to graphic primitives.
- grouped row
- A row of data in a QBE target or example table that is summarized
either by a G. or a built-in function.
- HELP
- Additional information about an error message, a QMF panel,
or a QMF command and
its options.
- host
- A mainframe or mid-size processor that provides services in
a network to a workstation.
- HTML
- Hypertext Markup Language. A standardized markup language
for documents displayed on the World Wide Web.
- ICU
- Interactive Chart Utility.
- INCORROUT
- The keyword for incorrect output.
- index
- A collection of data about the locations of records in a table,
allowing rapid access to a record with a given key.
- initial procedure
- A QMF procedure
specified by the DSQSRUN parameter on the QMF start
command which is executed immediately after QMF is
invoked.
- initialization program
- A program that sets QMF program
parameters. This program is specified by DSQSCMD in the callable
interface. The default program for interactive QMF is
DSQSCMDn, where n is
the qualifier for the presiding language ('E' for
English).
- installation-defined command
- A command created by an installation. QMF will
process it as one of its own commands or as a combination of its
commands.
- installation-defined format
- Date and time formats, also referred to as LOCAL formats, that
are defined (or built) by the installation.
- interactive execution
- Execution of a QMF command
in which any dialog that should take place between the user and QMF during
the command's execution actually does take place.
- interactive session
- Any QMF session
in which the user and QMF can
interact. Could be started by another interactive session by using
the QMF INTERACT
command.
- interactive switch
- A conceptual switch which, when on, enables an application
program to run QMF commands
interactively.
- invocation CLIST or EXEC
- A program that invokes (starts) QMF.
- ISO (International Standards Organization) format
- A format that represents date and time values as follows:
- Date: yyyy-mm-dd
- Time: hh.mm.ss
- ISPF
- Interactive System Productivity Facility.
- IXF
- Integration Exchange Format: A protocol for transferring
tabular data among various software products.
- JCL
- Job control language for OS/390(R).
- job control
- In VSE, a program called into storage to prepare each job
or job step to be run. Some of its functions are to assign I/O devices
to symbolic names, set switches for program use, log (or print)
job control statements, and fetch the first phase of each job step.
- JIS (Japanese Industrial Standard) format
- A format that represents date and time values as follows:
- Date: yyyy-mm-dd
- Time: hh:mm:ss
- join
- A relational operation that allows retrieval of data from
two or more tables based on matching columns that contain values
of the same data type.
- keyword parameter
- An element of a QMF command
consisting of a keyword and an assigned value.
- like
- Pertaining to two or more similar or identical IBM operating
environments. For example, like distribution is distribution between
two DB2 UDB for OS/390's
with compatible server attribute levels. Contrast with "unlike".
- literal
- In programming languages, a lexical unit that directly represents
a value. A character string whose value is given by the characters
themselves.
- linear procedure
- Any procedure not beginning with a
REXX comment. A linear procedure can contain QMF commands,
comments, blank lines, RUN commands, and substitution variables.
See also "procedure with logic."
- linear syntax
- QMF command
syntax that is entered in one statement of a program or procedure,
or that can be entered on the QMF command
line.
- line wrapping
- Formatting table rows in a report so they occupy several lines.
The row of column names and each row of column values are split
into as many lines as are required by the line length of the report.
- local
- Pertaining to the relational database, data, or file that
resides in the user's processor. See also "local DB2 UDB for OS/390",
and contrast with remote.
- local area network (LAN)
- (1) Two or more processors connected for local resource sharing
(2) A network within a limited geographic area, such as a single
office building, warehouse, or campus.
- local data
- Data that is maintained by the subsystem that is attempting
to access the data. Contrast with remote data.
- local DB2 UDB for OS/390
- With DB2 UDB for OS/390,
the application requester is part of a DB2 UDB for OS/390 subsystem
that is running in the same MVS(TM) system
as QMF. Therefore,
an entire DB2 UDB for OS/390 subsystem
(including data) is associated with the application requester, but
the SQL statements are processed at the current location. This subsystem
is where the QMF plan
is bound.
When QMF runs
in TSO, this subsystem is specified using DSQSSUBS startup program parameter.
When QMF runs
in CICS,
this subsystem is identified in the Resource Control Table (RCT).
The local DB2 UDB for OS/390 is
the subsystem ID of the DB2 UDB for OS/390 that
was started in the CICS region.
- location
- A specific relational database management system in a distributed
relational database system. Each DB2 UDB for OS/390 subsystem
is considered to be a location.
- logical unit (LU)
- A port through which an end user accesses the SNA network
to communicate with another end user and through which the end user
accesses the functions provided by system services control points.
- Logical Unit type 6.2 (LU 6.2)
- The SNA logical unit type that supports general communication
between programs in a distributed processing environment.
- LU
- Logical unit.
- LU 6.2
- Logical Unit type 6.2.
- LOOP
- The keyword for an endless-loop problem.
- MSGx
- The keyword for a message problem.
- Multiple Virtual Storage
- Implies the MVS/ESA(TM) product
- MVS/ESA
- Multiple Virtual Storage/Enterprise System Architecture (IBM operating system).
- NCP
- Network Control Program.
- Network Control Program (NCP)
- An IBM licensed
program that provides communication controller support for single-domain,
multiple-domain, and interconnected network capability.
- NLF
- National Language Feature. Any of several optional features
available with QMF that
lets the user select a language other than US English.
- NLS
- National Language Support.
- node
- In SNA, an end point of a link or a junction common to two
or more links in a network. Nodes can be distributed to host processors,
communication controllers, cluster controllers, or terminals. Nodes
can vary in routing and other functional capabilities.
- null
- A special value used when there is no value for a given column
in a row. Null is not the same as zero.
- null value
- See null.
- object
- A QMF query,
form, procedure, profile, report, chart, data, or table. The report, chart,
and data objects exist only in temporary storage; they cannot be
saved in a database. The table object exists only in a database.
- object name
- A character string that identifies an object owned by a QMF user.
The character string can be a maximum of 18 bytes long and must
begin with an alphabetic character. The term "object name" does
not include the "owner name" prefix. Users can access other
user's objects only if authorized.
- object panel
- A QMF panel
that can appear online after the execution of one QMF command
and before the execution of another. Such panels include the home,
report, and chart panels, and all the panels that display a QMF object.
They do not include the list, help, prompt, and status panels.
- online execution
- The execution of a command from an object panel or by pressing
a function key.
- owner name
- The authorization id of the user who creates a given object.
- package
- The control structure produced when the SQL statements in
an application program are bound to a relational database management
system. The database management system uses the control structure
to process SQL statements encountered during statement execution.
- panel
- A particular arrangement of information, grouped together
for presentation in a window. A panel can contain informational
text, entry fields, options the user can choose from, or a mixture
of these.
- parameter
- An element of a QMF command.
This term is used generically in QMF documentation
to reference a keyword parameter or a positional parameter.
- partner logical unit
- In SNA, the remote system in a session.
- PERFM
- The keyword for a performance problem.
- permanent storage
- The database where all tables and QMF objects
are stored.
- plan
- A form of package where the SQL statements of several programs
are collected together during bind to create a plan.
- positional parameter
- An element of a QMF command
that must be placed in a certain position within the command.
- primary panel
- The main Prompted Query panel containing your query.
- primary QMF session
- An interactive session begun from outside QMF Within
this session, other sessions can be started by using the INTERACT
command.
- procedure
- An object that contains QMF commands.
It can be run with a single RUN command. A procedure in temporary
storage has the name of PROC. See also "linear procedure" and "procedure
with logic."
- procedure termination switch
- A conceptual switch that a QMF MESSAGE
command can turn on. While on, every QMF procedure
to which control returns terminates immediately.
- procedure with logic
- Any QMF procedure
beginning with a REXX comment. In a procedure with logic, you can
perform conditional logic, make calculations, build strings, and
pass commands back to the host environment. See also "linear procedure."
- profile
- An object that contains information about the characteristics
of the user's session. A stored profile is a profile that has been
saved in permanent storage. A profile in temporary storage has the
name PROFILE. There can be only one profile for each user.
- prompt panel
- A panel that is displayed after an incomplete or incorrect QMF command has
been issued.
- Prompted Query
- A query built in accordance with the user's responses to a
set of dialog panels.
- protocol
- The rules governing the functions of a communication system
that must be followed if communication is to be achieved.
- PSW
- Program status word.
- PTF
- Program temporary fix.
- QBE (Query-By-Example)
- A language used to write queries graphically. For more information
see Using QMF
- QMF administrative
authority
- At minimum, insert or delete priviledge for the Q.PROFILES
control table.
- QMF administrator
- A QMF user
with QMF administrative
authority.
- QMF command
- Refers to any command that is part of the QMF language.
Does not include installation-defined commands.
- QMF session
- All interactions between the user and QMF from
the time the user invokes QMF until
the EXIT command is issued.
- qualifier
- When referring to a QMF object,
the part of the name that identifies the owner. When referring to
a TSO data set, any part of the name that is separated from the
rest of the name by periods. For example, 'TCK', 'XYZ',
and 'QUERY' are all qualifiers in the data set
name 'TCK.XYZ.QUERY'.
- query
- An SQL or QBE statement, or a statement built from prompting,
that performs data inquiries or manipulations. A saved query is
an SQL query, QBE query, or Prompted Query that has been saved in
a database. A query in temporary storage, has the name QUERY.
- RDBMS
- Relational database management system
- relational database
- A database perceived by its users as a collection of tables.
- relational database management system (RDBMS)
- A computer-based system for defining, creating, manipulating,
controlling, managing, and using relational databases.
- remote
- Pertaining to a relational DBMS other than the local relational
DBMS.
- remote data
- Data that is maintained by a subsystem other than the subsystem
that is attempting to access the data. Contrast with local data.
- remote data access
- Methods of retrieving data from remote locations. The two
remote data access functions used by QMF are remote unit of work and DB2 UDB for OS/390-only distributed
unit of work, which is called system-directed access.
- remote unit of work
- (1) The form of SQL distributed processing where the application
is on a system different from the relational database and a single
application server services all remote unit of work requests within
a single logical unit of work. (2) A unit of work that allows for
the remote preparation and execution of SQL statements.
- report
- The formatted data produced when a query is issued to retrieve
data or a DISPLAY command is entered for a table or view.
- REXX
- Restructured extended executor.
- rollback
- The process that removes uncommitted database changes made
by one application or user. When a rollback occurs, locks are freed
and the state of the resource being changed is returned to its state
at the last commit, rollback, or initiation. See also commit.
- row
- A horizontal set of tabular data.
- row operator area
- The leftmost column of a QBE target or example table.
- run-time variable
- A variable in a procedure or query whose value is specified
by the user when the procedure or query is run. The value of a run-time
variable is only available in the current procedure or query. Contrast
with global variable.
- sample tables
- The tables that are shipped with QMF.
Data in the sample tables is used to help new QMF users
learn the product.
- saved object
- An object that has been saved in the database. Contrast with
current object.
- SBCS
- Single-byte character set.
- scalar
- A value in a column or the value of a literal or an expression
involving other scalars.
- scalar function
- An operation that produces a single value from another value
and is expressed in the form of a function name followed by a list
of arguments enclosed in parentheses.
- screen
- The physical surface of a display device upon which information
is presented to the user.
- scrollable area
- The view of a displayed object that can be moved up, down,
left, and right.
- server
- A functional unit that provides shared services to workstations
over a network.
- session
- All interactions between the user and QMF from
the time the user logs on until the user logs off.
- single-byte character
- A character whose internal representation consists of one
byte. The letters of the Latin alphabet are examples of single-byte
characters.
- SNA
- Systems Network Architecture.
- SNAP dump
- A dynamic dump of the contents of one or more storage areas
that QMF generates
during an abend.
- sort priority
- A specification in a retrieval query that causes the sorted
values in one retrieved column to determine the sorting of values
in another retrieved column.
- SQL
- Structured Query Language.
- SQLCA
- Structured Query Language Communication Area.
- SSF
- Software Support Facility. An IBM online
database that allows for storage and retrieval of information about
all current APARs and PTFs.
- stored object
- An object that has been saved in permanent storage. Contrast
with current object.
- string
- A set of consecutive items of a similar type; for example,
a character string.
- Structured Query Language
- A language used to communicate with DB2 UDB for OS/390 and DB2 for VSE or VM.
Used to write queries in descriptive phrases.
- subquery
- A complete SQL query that appears in a WHERE or HAVING clause
of another query (the main query or a higher-level subquery).
- substitution variable
- (1) A variable in a procedure or query whose value is specified either
by a global variable or by a run-time variable. (2) A variable in
a form whose value is specified by a global variable.
- substring
- The part of a string whose beginning and length are specified
in the SUBSTR function.
- System Log (SYSLOG)
- A data set or file in which job-related information, operational data,
descriptions of unusual occurrences, commands, and messages to and
from the operator may be stored.
- Systems Network Architecture
- The description of the logical structure, formats, protocols,
and operational sequences for transmitting information units through
and controlling the configuration and operation of networks.
- table
- A named collection of data under the control of the relational
database manager. A table consists of a fixed number of rows and
columns.
- Table Editor
- The QMF interactive
editor that lets authorized users make changes to a database without
having to write a query.
- table name area
- The leftmost column of a QBE example table.
- tabular data
- The data in columns. The content and the form of the data
is specified on FORM.MAIN and FORM.COLUMNS.
- target table
- An empty table in which example elements are used to combine
columns, combine rows, or include constant values in a report.
- temporary storage
- An area where the query, form, procedure, profile, report,
chart, and data objects in current use are stored. All but the
data object can be displayed.
- temporary storage queue
- In CICS,
a temporary storage area used for transfer of objects between QMF and
an application or a system service.
- time
- Designates a time of day in hours and minutes and possibly
seconds (a two- or three-part value).
- thread
- The DB2 UDB for OS/390 structure
that describes an application's connection, traces its progress,
provides resource function processing capability, and delimits its accessibility
to DB2 UDB for OS/390 resources
and services. Most DB2 UDB for OS/390 functions
execute under a thread structure.
- three-part name
- A fully-qualified name of a table or view, consisting of a
location name, owner ID, and object name. When supported by the
application server (that is, DB2 UDB for OS/390),
a three-part name can be used in an SQL statement to retrieve or
update the specified table or view at the specified location.
- timestamp
- A date and a time, and possibly a number of microseconds (a
six- or seven-part value).
- TP
- Transaction Program
- TPN
- Transaction program name
- transaction
- The work that occurs between 'Begin Unit of Work' and 'Commit' or 'Rollback'.
- transaction program
- A program that processes transactions in an SNA network. There are
two kinds of transactions programs: application transaction programs
and service transaction programs.
- transaction program name
- The name by which each program participating in an LU 6.2 conversation
is known. Normally, the initiator of a connection identifies the
name of the program it wants to connect to at the other LU. When
used in conjunction with an LU name, it identifies a specific transaction
program in the network.
- transient data queue
- In CICS,
a storage area, whose name is defined in the Destination Control
Table (DCT), where objects are stored for subsequent internal or
external processing.
- TSO
- Time Sharing Option.
- two-phase commit
- A protocol used in distributed unit of work to ensure that participating
relational database management systems commit or roll back a unit
of work consistently.
- unit of work
- (1) A recoverable sequence of operations within an application
process. At any time, an application process is a single unit of
work, but the life of an application process may involve many units
of work as a result of commit or rollback operations. (2) In DRDA,
a sequence of SQL commands that the database manager treats as a
single entity. The database manager ensures the consistency of data
by verifying that either all the data changes made during a unit
of work are performed or none of them are performed.
- unlike
- Refers to two or more different IBM operating
environments. For example, unlike distribution is distribution between DB2 for
VM and VSE and DB2 UDB for OS/390. Contrast
with like.
- unnamed column
- An empty column added to an example table. Like a target table,
it is used to combine columns, combine rows, or include constant
values in a report.
- USA (United States of America) format
- A format that represents date and time values as follows:
- Date: mm/dd/yyyy
- Time: hh:mm xM
- value
- A data element with an assigned row and column in a table.
- variation
- A data formatting definition specified on a FORM.DETAIL panel
that conditionally can be used to format a report or part of a report.
- view
- An alternative representation of data from one or more tables.
It can include all or some of the columns contained in the table
or tables on which it is defined. (2) The entity or entities that
define the scope of the data to be searched for a query.
- Virtual Storage Extended
- An operating system that is an extension of Disk Operating System/
Virtual Storage. A VSE consists of (1) VSE/Advanced Functions support
and (2) any IBM-supplied
and user-written programs that are required to meet the data processing
needs of a user. VSE and the hardware it controls form a complete
computing system.
- VM
- Virtual Machine (IBM operating
system). The generic term for the VM/ESA(R) environment.
- VSE
- Virtual Storage Extended (IBM operating
system). The generic term for the VSE/ESA(TM) environment.
- WAIT
- The keyword for an endless-wait-state problem.
- window
- A rectangular portion of the screen in which all or a portion
of a panel is displayed. A window can be smaller than or equal to
the size of the screen.
- Workstation Database Server
- The IBM family
of DRDA database
products on the UNIX(R) and
Intel platforms (such as DB2 Universal Database (UDB), DB2 Common
Server, DB2 Parallel
Edition, and DataJoiner(R).)
- wrapping
- See "column wrapping" and "line wrapping".