A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z
alias. An alternate name that can be used in SQL statements to identify a table, view, or database in the same or a remote DB2® subsystem.
alphanumeric. Pertaining to character data that consists of alphabetic and numeric characters.
annotated XML schema. An XML schema composed of XML schema documents that use annotation elements and attributes that are specific to XML document decomposition. An annotated XML schema is used by decomposition procedures to specify the mapping of XML data to database tables and columns.
authorization ID. A character string that designates a set of privileges. It is used by the database manager for authorization checking and as an implicit qualifier for the names of objects such as tables, views, and indexes.
bit data subtype. Data subtype for all character strings. The bytes of a character string with bit data subtype do not represent characters; therefore, no character conversion is performed on character strings.
build utility. Custom build routines identified with unique names. These routines can be configured to use different resources when building SQL procedures on z/OS.
built-in data types. Data types that are supported by DB2 are binary string, character string, double-byte character string, datetime, numeric, and datalink.
case expression. Allows an expression to be selected based on the evaluation of one or more conditions. In general, the value of the case-expression is the value of the result-expression following the first (left-most) case that evaluates to true.
case setting. Whether you choose to view SQL data type synonyms by using uppercase, mixed case, or lowercase.
class definition. In object-oriented programming, allows programmers to bundle not only data components, but also the code that operates on them.
class library. In object-oriented programming, collections of related classes that solve specific programming problems.
comparison operators. An infix operator used in comparison expressions such as the and and or in "a and b" and "a or b."
constraint checking. Validation of data to be inserted, deleted, or updated in a table. Fields enabled with constraint checking diagnose problems with information that you enter.
debug table. A pseudo-catalog table (DB2DBG.ROUTINE_DEBUG) that contains records for each procedure indicating which users have authorization to debug selected procedures from particular workstations and ports.
decomposition. The process of breaking up an XML document for storage in database tables.
driver. (1) A program (and possibly data files) that contain information needed to run a particular unit. (2) A system or device that enables a functional unit to operate.
drop. Deleting an object. Any objects that are directly or indirectly dependent on that object are either deleted or made inoperative. Whenever an object is deleted, its description is deleted from the catalog and any packages that reference the object are invalidated.
dynamic SQL. SQL statements that are prepared and run within a running program. In dynamic SQL, the SQL source is contained in host language variables rather than being coded into the program. The SQL statement might change several times while the program is running.
embedded SQL. SQL statements coded within an application program. See also dynamic SQL.
Extensible Markup Language (XML). A standard metalanguage for defining markup languages that is based on Standard Generalized Markup Language (SGML).
Extensible Stylesheet Language (XSL). A language for specifying style sheets for XML documents. Extensible Stylesheet Language Transformation (XSLT) is used with XSL to describe how an XML document is transformed into another document.
Extensible Stylesheet Language Transformation (XSLT). An XML processing language that is used to convert an XML document into another document in XML, PDF, HTML, or other format.
external function.
An external routine that returns a single
value.
external procedure.
An external routine that does not return
a value.
external routine.
A user-defined routine that is written in an
external language that the database supports. These external
languages include the C and Java languages. The routine names,
parameters, and other information are registered in the system
catalog tables of a database. However, the executable code of
an external routine is stored outside the database. An external
routine can be an external function or an
external procedure.
For bit data. See bit data subtype.
identity column. A column that provides a way for DB2 to automatically generate a unique numeric value for each row in a table. A table can have a single column that is defined with the identity attribute. Examples of an identity column include order number, employee number, stock number, and incident number.
index over XML data.
An index that provides efficient access to nodes within an XML
document by providing index keys that are based on XML patterns.
InOut parameter. A parameter that both passes values to a procedure from a client application and returns values from the procedure to the client application.
input parameter. A parameter that is passed to a procedure. The procedure cannot modify input parameter values. When the procedure returns control to the client application, an input parameter value is unchanged from when the procedure was called.
length. The number of digits that the following SQL data types can contain: BLOB, CHAR, CLOB, DBCLOB, GRAPHIC, and VARCHAR.
link-edit. To create a loadable computer program by using a linkage editor.
nested statement. A statement that is incorporated within a structure of the same kind; for example, to nest one loop within another loop.
output parameter. A parameter that is returned to a client application from a procedure.
package. In DB2, a control structure produced during program preparation that is used to run SQL statements.
port. An access point for data entry or exit. A port is identified by a port number.
precision. A number (between 1 and 31) for the total number of digits that a value can contain. The SQL types decimal and float can have a precision. The precision of binary integers and decimal numbers is the total number of binary or decimal digits excluding the sign. The precision of floating-point numbers is either single or double, referring to the number of digits in the fraction.
precompilation. The processing of application programs containing SQL statements that takes place before compilation. SQL statements are replaced with statements that are recognized by the host language compiler. Output from this precompilation includes source code that can be submitted to the compiler and the database request module (DBRM) that is input to the bind process.
privilege. The right to access a specific database object in a specific way. These rights are controlled by users with SYSADM (system administrator) authority or DBADM (database administrator) authority or by creators of objects. Privileges include rights such as creating, deleting, and selecting data from tables.
query. A request from a database based on specific conditions; for example, a request for a list from a customer table of all customers who have a balance greater than $1000.
record. Storage representation of a single row of a database table.
registering. Inserting the row for a procedure into the DB2 table for procedures. Unlike other objects such as tables, indexes, functions, and triggers, there is no table or view in the catalog for procedures. However, a special table, SYSIBM.SYSPROCEDURES (a pseudo-catalog table), has been defined by DB2 that lists and describes available procedures, along with the associated parameters of those procedures.
result set. The set of rows produced by the evaluation of a SELECT statement.
return code. (1) A value returned to a program to indicate the results of an operation requested by that program. (2) A code used to influence the execution of succeeding instructions.
rolled back. The process of restoring data changed by SQL statements to the state at its last commit point.
routine.
A group of program statements that perform a particular task. A routine
can be a function or a procedure. All routines can accept arguments.
See also user-defined routine.
scale. The number of digits to the right of the decimal point. Available only for the SQL types decimal and float. The scale cannot be negative or greater than the precision. The maximum precision is 31 digits. If you specify a scale, you must specify a precision.
schema. A collection of database objects such as tables, views, indexes, or triggers. Provides a logical classification of database objects.
source code. A set of host language statements and SQL statements that is processed by an SQL precompiler. However, when the host language is Java, you don't need to precompile or link-edit the source code for the procedure.
specific name. Provides a unique name for the instance of the procedure that is being defined. This specific name can be used when dropping or commenting on the procedure. The specific name can never be used to invoke the procedure. The specific name can be the same as an existing procedure name.
SPL.
See Stored Procedure Language (SPL).
SPL function.
An SPL routine that returns one or more
values.
SPL procedure.
An SPL routine that does not return
a value.
SPL routine.
A user-defined routine that is written in
Stored Procedure Language (SPL). Its name,
parameters, executable format, and other information are stored
in the system catalog tables of a database. An SPL routine can
be an SPL procedure or an
SPL function.
SQL statements. Queries created with a standardized language for defining and manipulating data in a relational database.
static SQL. SQL statements that are embedded within a program, and are prepared before the program is run. After being prepared, a static SQL statement does not change, although values of host variables specified by the statement can change.
Stored Procedure Language (SPL).
An Informix extension to SQL that provides flow-control features
such as sequencing, branching, and looping. See also
SPL routine.
synonym. See type synonym.
SYSADM. System administrator for an IBM DB2 database. The SYSADM has the highest level of administrative authority. Users with SYSADM authority can run utilities, issue database and database manager commands, and access the data in any table in any database within the database manager instance. The SYSADM has the ability to control all database objects in the instance, including databases, tables, views, indexes, packages, schemas, aliases, data types, functions, procedures, triggers, table spaces, nodegroups, buffer pools, and event monitors.
SYSIBM.SYSPROCEDURES table. Contains a row for each procedure.
SYSIBM.SYSPROCPARMS table. Contains a row for each parameter of a procedure.
type synonym. The name by which you view an SQL data type; for example, you might choose to view the data type DEC as DECIMAL, NUM, or NUMERIC.
unit. A unit of size (bytes, kilobytes, megabytes, or gigabytes) for the selected SQL type.
user-defined function.
A user-defined routine that returns at least one
value. You can write a user-defined function in SPL
(SPL function) or in an external language
that the database server supports (external
function).
user-defined procedure.
A user-defined routine that does not return a value.
You can write a user-defined procedure in SPL (SPL
procedure) or in an external language that the database server
supports (external procedure).
user-defined routine.
A routine that you write and register in the system
catalog tables of a database, and that an SQL statement or
another routine can invoke. You can write a user-defined
routine in SPL (SPL routine)
or in an external language (external routine)
that the database server supports.
value. (1) Smallest unit of data manipulated in SQL. (2) A specific data item at the intersection of a column and a row. The sources of values are: constants, columns, host variables, functions, expressions, and special registers.
variable. A data element that specifies a value that can be changed.
XML. See Extensible Markup Language.
XML attribute. A name-value pair within a tagged XML element that modifies certain features of the element.
XML column. A column of a table that stores XML values and is defined using the data type XML. The XML values are well-formed XML documents.
XML data. Data of type XML, including serialized XML or XML values. See also XML value.
XML document. A well-formed XML artifact that conforms to the Extensible Markup Language (XML) specification and contains markup tags along with the content, with exactly one root element.
XML element. A logical structure in XML that is delimited by a start tag and an end tag.
XML index.
See index over XML data.
XML Path Language (XPath). A language that is designed to uniquely identify or address parts of source XML data, for use with XML-related technologies, such as XSLT, XQuery, and XML parsers. XPath is a World Wide Web Consortium standard.
XML pattern. A slash-separated list of element names that describes a path through an XML document and through specific node characteristics. The pattern selects elements that match the specifications. XML patterns are specified to create indexes on XML columns in a database.
XML schema. A mechanism for describing and constraining the content of XML files by indicating which elements are allowed and in which combinations. XML schemas are an alternative to document type definitions (DTDs) and can be used to extend functionality in the areas of data typing, inheritance, and presentation.
XML schema document. An XML document with <schema> as the root element that defines the components in one namespace of an XML schema. An XML schema with components in more than one namespace consists of multiple XML schema documents.
XML schema repository (XSR).
A repository that allows the DB2 database system to manage
dependencies on externally referenced XML artifacts in XML
instance documents within a database. Supported XSR objects
include XML schemas and annotated XML schemas. When
registered with the XSR, these objects have a unique identifier
and can be used to validate XML instance documents. See also
XSR object.
XML value. A single instance of XML data. See also XML data.
XPath. See XML Path Language.
XSL. See Extensible Stylesheet Language.
XSL style sheet. Code that describes how an XML document should be rendered (displayed or printed).
XSLT. See Extensible Stylesheet Language Transformation.
XSR.
See XML schema repository.
XSR object.
An XML artifact that is registered in the XML schema repository
(XSR) and is used to validate XML instance documents. Supported
XSR objects include XML schemas and annotated XML schemas.
See also XML schema repository.
.NET Development Forum DB2 FAQs IDS FAQs
© Copyright IBM Corporation 2002, 2019. All Rights Reserved.