DB2 graphic QMF Version 8

Glossary

A

ad hoc query
A query that has not been named or saved; it has been submitted and executed "on the fly."
activity log
A repository for QMF session activity and object usage information, and writes to the HPO Activity Log data sets.
application plan
The output produced by the BIND process. It contains information about resources (tables, indexes) required and the access path used by DB2 to satisfy an SQL request.

B

bind
A process that compiles one or more DBRMs into an application plan.
buffering
A portion of storage used to hold input or output data temporarily, which can affect system overhead and can be limited by the amount of memory available to the executing program.

C

collection
A set of packages which are bound together with a collection ID. If you use several versions of QMF for Windows, you can use different collection names for different versions to avoid naming conflicts.
column
Contains values that have the same data type in the database. A value is similar to a field in a record. A value is the smallest unit of data that you can manipulate with SQL. The two basic components of the column definition are the name and the data type.
common controls
Controls that are common to a resource group.

D

data layer program
A general utility program providing access to DB2 in order to retrieve or manipulate data, and are generated from QMF queries.
display programs
Programs that allow you to browse a report by panel, typically before all data is read (fetched).
edit codes
Codes that determine how a column is formatted in a report. You use different edit codes depending on the type of data you want to format. Some edit codes include: character, date, graphic, numeric, time, timestamp, and user-defined.

E

enrollment
A method of granting a user profile certain authorities to start a QMF session.
error log
A time- and date-stamped log that identifies the user and message number for system or resource errors.
end user facility
Registers reports that have been generated and prepared for execution, then is used by end users to run compiled report programs.

F

filtering
A means to qualify object selection lists. An object must pass all of the enabled filters to be included in the selection list.

G

generation option
Options that allow you to control the characteristics of the program that will be generated, which are set on the Generation Options panel and the pop-up options, which can affect the speed and performance of the generated program.
governing
Establishes certain limits and controls for database and communication resources.
governor
Controls QMF session activity by obtaining thresholds and taking control of resource groups.

H

host variable
Enable you to use the same static query to retrieve different data. To retrieve different data, you do not need to rebind a package for the static query; instead, you supply different values for the host variables in the query.

Database servers specify rules for where host variables can appear in a query. Refer to documentation for your database server for these rules.

Host variables must have a specific data type. A value that you provide for a host variable must conform to that variable's data type.

L

linear procedure
Any procedure that does not begin with an IBM Object REXX comment. A linear procedure can run QMF commands, comments, blank lines, RUN commands, and substitution variables.
list
To display data in an ordered format. For example, the LIST command in BASIC displays lines of a program. A list is any ordered set of data.

M

monitor
Supplies a real-time interface to QMF session activity information, accepting administrator commands and passing them on to the HPO/Governor module.

O

object
A query, form, procedure, or table.
object list
Tree-structured representations of the database objects available on the server. Which objects can be viewed depends upon your resource limits. Objects can be added and removed from the object list; also, the objects can be saved and shared with other users.
online facilities
Facilities that help organize and simplify the administration and management of QMF, including: Object Manager, Governor, Monitor, Query Analyzer, User Profile, Error Log, Spill File, HPO Activity Log JCL, and QMF start-up parameters.
open enrollment
A type of enrollment that is assigned to a user profile which searches for a creator equal to SYSTEM so the user can start a QMF session.

P

package
An object containing a set of SQL statements that have been statically bound (access paths to the data are selected and some authorization checking is performed) and are available for processing.
prepare program
An interface that prepares DB2 programs, online or in batch, and involves running a precompile, bind, CICS command translation (for CICS programs), compile, and link.
procedure
An object that contains QMF commands. A procedure can be run with a single RUN command.

A procedure is a set of commands that enable you to run queries, print reports, import and export data, and perform other functions with a single command.

proc program
A program that acts as a driver to run each of the procedure's report programs in sequence, and it requires that each report program has been generated and the report programs must have the same characteristics such as being all batch programs.
print program
A specialized program that produces a printed version of a report being displayed by a display program, and is invoked by issuing the PRINT command.
program generator
A facility used by programmers to convert QMF reports (queries, forms, and procedures) into compiled programs, or to generate general purpose programs for accessing DB2.

Q

QMF report
The result of issuing the QMF commands RUN QUEY and PRINT REPORT, sometimes referred to as a query and often is the output of QMF procedures.
query
A request for a specific result set of information from a database. You can work with an SQL query, a prompted query or a natural query.
query analyzer
Provides preemptive governing capabilities by trapping queries before they are processed by DB2.

R

report
A compiled program, typically converted from a QMF query, query and form, or procedure; or a non-compiled QMF query, query and form, or procedure.
resource group
A set of related controls that restrict when a QMF session can begin, what type of session can be started, what types of QMF commands and SQL verbs can be processed, and the amount of system resources that can be consumed.
resource limits
Limits and controls that govern the use of database and communication resources. These include setting schedules, time-outs, limits, authorization to SQL verbs, binding and object tracking privileges, LOB options, Report Center, and other options.
resource limits group
Users belonging to a group for which certain restrictions and permissions have been defined for schedules, time-outs, limits, SQL verbs, options, save data, binding, object tracking, LOB options, and the Report Center.
resource limits group schedule
The days and times during which the schedule for a resource limits group is active or inactive. The schedule includes parameters for time-outs, limits, SQL verbs, miscellaneous options, binding, save data, object tracking, LOB options, and Report Center.
restricted enrollment
A type of enrollment assigned to a user profile which prohibits the user from starting a QMF session.
REXX
(Restructured Extended Executor): IBM Object REXX is an interpreted, structured, procedural script programming language that allows programs and algorithms to be written in a clear structured way.

It was designed so that it would be truly easy to use for both professionals and casual users and was designed to work in several diverse application areas -- such as personal programming, command processing, application macro processing and application prototyping -- where different languages are typically used. It is, however, designed to be platform-independent.

S

scheduled controls
Controls that pertain to a specific date, day of the week, and time of day during which a resource is allowed to or prohibited from performing an action or task.
spill file
A file that can buffer excess data when there is no room in virtual storage for the current data object.
SQL query
(Structured Query Language): A standardized language for defining and manipulating data in a relational database. SQL is used to write queries in descriptive phrases.
startup parameters
Parameters that control the characteristics of a QMF session, such as environment, plan, and performance-related parameters.
static query
An SQL query that has been previously passed to a database server and bound into a package.

When a static query is executed, the database server uses the SQL text bound into the package, rather than the SQL text currently appearing in the query window. Static queries are more resource efficient than dynamic queries, but static queries cannot be edited.

static SQL
SQL statements, embedded within a program, that are prepared during the program preparation process, before the program is executed. After being prepared, the SQL statement does not change (although variable values that are specified by the statement might change).
stored procedure
A group of SQL statements that form a logical unit and perform a particular task. Stored procedures are used to encapsulate a set of operations or queries to execute on a database server. For example, operations on an employee database (hire, fire, promote, lookup) could be coded as stored procedures executed by application code. Stored procedures can be compiled and executed with different parameters and results, and they may have any combination of input, output, and input/output parameters. Stored procedures are supported by most DBMSs, but there is a fair amount of variation in their syntax and capabilities.
string delimiter
A character or string used to separate or mark the start of and end of items of data in a database, text file, or in source code. A string delimiter uses an apostrophe or quote to delimit this data.
substitution variable
A variable in a procedure or query whose value is specified by a global variable or a run-time variable. Or, it is a variable in a form whose value is specified by a global variable.

Substitution variables must begin with an ampersand (&) and can contain up to 18 characters, which can be alphabetic, numeric or one of the following characters: [ ! $ ~ { } ? @ # % \ _.

T

table
A collection of stored data under the control of the relational database manager, consisting of a fixed number of rows and columns. You can interact with tables by running queries or by using the table editor.

U

usage code
Codes that control how data is summarized, such as at the end of a column or as a partial summary at the control breaks in a table. Which usage codes are available depend on the data in the column and the type of summary.
user profile facility
A profile created for each user that is identified by the creator, translation, and environment which is required to start a QMF session.

V

variable
A data element that specifies a value that can be changed. A variable is a symbol or name that stands for a value.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004