A coded character set of 256 8-bit characters that represents textual data. It is typically used on zSeries and iSeries servers.
SQL statements coded within an application program.
A set of rules to represent character data.
A monitoring tool that provides information about the database events that have taken place. An Event Analyzer is used with the Event Monitor file to assess and record performance information.
A database object that monitors and collects data on database activities over a period of time. For example, starting the database might be an event that causes an Event Monitor to track the number of users on the system by taking an hourly snapshot of authorization IDs using the database.
(1) A user-created table that reflects the definition of the table being loaded.
(2) A table that holds rows that violate referential constraints or checks constraints that the CHECK DATA utility finds.
A lock that prevents running executing application processes from accessing data.
An SQL statement that can be embedded in an application program, dynamically prepared and executed, or issued interactively.
The elapsed runtime of a query. This is the time between the start and the end of the query execution.
A program that receives control from another program to perform specific functions.
To capture detailed information about the access plan that was chosen by the SQL compiler to resolve an SQL statement. The information describes the decision criteria used to choose the access plan.
(1) A collection of information that is compressed when an SQL statement is explained.
(2) A capture of the current internal representation of an SQL query and related information. This information is required by the Visual Explain tool.
An SQL statement for which the explain operation can be performed. Explainable statements are SELECT, UPDATE, INSERT, DELETE, and VALUES.
An SQL statement for which an explain operation was performed.
Statistics for a database object that was referred to in an SQL statement when the statement was explained.
A privilege that has a name and is held as the result of SQL GRANT and REVOKE statements, for example, the SELECT privilege.
(1) To copy data from database tables to a file using formats such as PC/IXF, DEL, WSF, or ASC.
(2) In the Information Catalog Center, to populate a tag language file with information catalog contents for use with another program.
An SQL operand or a collection of operators and operands that yields a single value.
A text-based tag language that is used for document processing and for publishing information on the Web.
A language for specifying stylesheets for XML documents. XSL consists of two parts: a language for transforming XML documents and an XML vocabulary for specifying formatting semantics.
An XML processing language that converts an XML document into another document in XML, PDF, HTML, or other format.
An allocation of space within a container of a table space to a single database object. Data for any table will be stored on all containers in a table space in a round-robin fashion. This balances the data across the containers that belong to a given table space. The number of pages that the database manager writes to one container before using a different one is called an extent.
A metadata structure stored within a table space that records the allocation of extents to each object in the table space.
A function for which the body is written in a programming language that takes scalar argument values and produces a scalar result for each invocation.
The name of an executable file for a stored procedure or user-defined function that is written in a host programming language.
An application program written in a host language, possibly containing SQL statements, that can be started with the SQL CALL statement.
A function, method, or procedure written in a host language and that possibly contains SQL statements.