Glossary

Term

Definition

Accounting String

Part of an accounting record, which enables administrators to charge back individual users for use of mainframe resources.

Authorization Identifier

A string that can be verified for connection to DB2 and to which a set of privileges are allowed. It can represent an individual, an organizational group, or a function.

Catalog Function

An ODBC function that returns information from the data source's system tables or catalog.

Catalog Qualifier

Same as catalog schema.

Catalog Schema

Location of the DB2 system tables or catalog. Previously called the Catalog Qualifier.

CCSID

Coded Character Set Identifier. Represents a character set, code page, encoding scheme, and additional coding-related information. Used to support international code sets.

Collection

A location on the host for database objects, such as user tables and catalog tables, which are collected together under a single qualifying name.

Cursor

A SQL object that points to a row in a result set.

Data Source

Information needed to access data on a host database. Typically, database and the network information needed to connect to the database.

Database Server

Host platform specific. On DB2 for z/OS, the database server name is the location name in the Distributed Data Facility (DDF).On DB2 for i, the database server name is the RDB or relational database name. On DB2/UDB, the database server name is the relational database name.

 DDL

(Data Dictionary Language) describes the collection of SQL statements that affect the data dictionary, such as those that create or remove databases, tables, or indices.

DRDA

Distributed Relational Database Architecture. Supports access to distributed DB2 data by which an application can explicitly connect to another location, using an SQL statement, to execute packages that have been previously bound at that location.

DSN

Data Source Name. An ODBC definition that refers to a particular database.

Dynamic SQL

SQL statements that are prepared and executed within an application program while the program is executing.  A dynamic SQL statement can change during program execution.

Host Name

In a TCP/IP configuration, the name or IP address of the TCP/IP server.

Held Cursor

A cursor that is not automatically closed when its transaction commits.

Installable Image

An image of a StarSQL installation that can be installed on multiple desktops over the network.

Isolation Level

The degree of concurrency allowed when multiple transactions try to access the same data.

ODBC

Open Database Connectivity. A call-level interface developed by Microsoft Corporation that allows a single application to access DBMSs from different vendors using a single interface.

Package

An object on the host containing a set of SQL statements that have been bound statically and are available for processing.

Qualifier

The part of a table reference in a SQL statement that indicates the schema in which the table is located.

RDB Name

A unique identifier for an RDBMS within a network.

Regedit

Registry editor supplied by the Windows operating system for manually editing the Registry.

Result Set

The set of data rows returned by a query.

Static SQL

SQL statements in an application program that are created and bound to the host in a static package before the application executes. After being created, a static SQL statement does not change, although values of variables specified by the statement might change.

Stored Procedure

A set of one or more host commands that have been parsed and partially pre-processed on the host.

Table Creation Directive

A string appended to a SQL CREATE TABLE statement that indicates the schema or database in which the table is to be created.

TCP/IP

Transmission Control Protocol / Internet Protocol. A commonly used network protocol.

Trace File

A file that records a history of events that occurred in the system.

Transaction

One or more SQL commands that are committed as a unit. Either the entire transaction or none of it is committed to the database.

Two Phase Commit

Protocol that allows applications to coordinate units of work across multiple databases so that the units of work are committed as a single unit of work.

UID

Unique identifier that enables a user to logon to a host.

VTAM

Virtual Telecommunications Access Method provides network communications on IBM mainframes and AS/400 systems.