Part of an accounting record which enables administrators to charge back individual user for mainframe resources consumed.
Advance Program-to-Program Communications. A network protocol that contains SNA, but is often informally used as a synonym for SNA.
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.
An ODBC function that returns information from the data source's system tables or catalog.
Same as catalog schema.
Location of the DB2 system tables or catalog. Previously called the Catalog Qualifier.
Coded Character Set Identifer. Represents a character set, code page, encoding scheme and additional coding related information. Used to support international code sets.
A location on the host for database objects, such as user tables and catalog tables, which are collected together under a single qualifying name.
A SQL object that points to a row in a result set.
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.
Information needed to access data on a host database. Typically, database and the network information needed to connect to the database.
Host platform specific. On DB2/MVS, the database server name is the location name in the Distributed Data Facility (DDF).On DB2/400, the database server name is the RDB or relational database name. On DB2/UDB, the database server name is the realtional database name.
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.
Data Source Name. An ODBC definition that refers to a particular database.
SQL statements that are prepared and executed within an application program while the program is executing.
A cursor that is not automatically closed when its transaction commits.
In a TCP/IP configuration, the name or IP address of the TCP/IP server. Can be the host system or a StarPipes server.
A feature of Microsoft SNA Server, whereby security is delegated exclusively to the Microsoft Windows client and the user does not have to give a user ID and password to connect to the host.
The name of the host system. Required for configuring a Netsoft NS/Router connection.
An image of a StarSQL installation that can be installed on multiple desktops over the network.
The degree of concurrency allowed when multiple transactions try to access the same data.
Logical Unit. A component of an SNA connection. Each end of the connection requires an LU name.
Contains SNA session-specific information, such as the packet size (RU Size), which must be synchronized before an SNA session can be initiated.
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.
An object on the host containing a set of SQL statements that have been bound statically and are available for processing.
A file on the desktop that contains Static SQL. Used to bind Static SQL packages on the DB2 host.
The part of a table reference in a SQL statement that indicates the schema in which the table is located.
A unique identifier for an RDBMS within a network.
Registry editor supplied by the Windows NT operating system for manually editing the NT Registry.
The set of data rows returned by a query.
Component of an CPI-C connection that includes session-specific information, such as remote LU, session mode name, and TP name.
Systems Network Architecture IBM’s flagship network protocol. See also APPC.
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.
A set of one or more host commands that have been parsed and partially pre-processed on the host.
A field in the Side Information Record. Required for configuring a CPI-C connection.
A string appended to a SQL CREATE TABLE statement that indicates the schema or database in which the table is to be created.
Transmission Control Protocol / Internet Protocol. A commonly used network protocol.
APPC Transaction Program Name. Defines the name of the remote transaction program that the database client must use when it issues an allocate request to the database server using the APPC communication protocol.
A file that records a history of events that occurred in the system.
One or more SQL commands that are committed as a unit. Either the entire transaction or none of it is committed to the database.
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.
Unique identifier that enables a user to logon to a host.
Virtual Telecommunications Access Method provides network communications on IBM mainframes and AS/400 systems.