(for example, MAX or AVG). Contrast
with built-in function, external function,
and SQL function.
source program
A set of host language statements and
SQL statements that is processed by an
SQL precompiler.
source table
A table that can be a base table, a view, a
table expression, or a user-defined table
function.
source type
An existing type that DB2 uses to
represent a distinct type.
space A sequence of one or more blank
characters.
spatial column
A column in a table that is defined using
one of the spatial data types provided by
IBM Spatial Support for DB2 for z/OS.
spatial data
Data that is made up of coordinates that
identify a geographic location or
geographic region.
spatial function
A function provided by IBM Spatial
Support for DB2 for z/OS that performs
various operations on spatial data.
spatial reference system
A set of parameters that includes
coordinates that define the maximum
possible extent of space that is referenced
by a given range of coordinates, an
identifier of the coordinate system from
which the coordinates are derived, and
numbers that convert coordinates into
positive integers to improve performance
when the coordinates are processed.
special register
A storage area that DB2 defines for an
application process to use for storing
information that can be referenced in SQL
statements. Examples of special registers
are SESSION_USER and CURRENT
DATE.
specific function name
A particular user-defined function that is
known to the database manager by its
specific name. Many specific user-defined
functions can have the same function
name. When a user-defined function is
defined to the database, every function is
assigned a specific name that is unique
within its schema. Either the user can
provide this name, or a default name is
used.
SPUFI See SQL Processor Using File Input.
SQL See Structured Query Language.
SQL authorization ID (SQL ID)
The authorization ID that is used for
checking dynamic SQL statements in
some situations.
SQLCA
See SQL communication area.
SQL communication area (SQLCA)
A structure that is used to provide an
application program with information
about the execution of its SQL statements.
SQL connection
An association between an application
process and a local or remote application
server or database server.
SQLDA
See SQL descriptor area.
SQL descriptor area (SQLDA)
A structure that describes input variables,
output variables, or the columns of a
result table.
SQL escape character
The symbol that is used to enclose an
SQL delimited identifier. This symbol is
the double quotation mark (″). See also
escape character.
SQL function
A user-defined function in which the
CREATE FUNCTION statement contains
the source code. The source code is a
single SQL expression that evaluates to a
single value. The SQL user-defined
function can return the result of an
expression. See also built-in function,
external function, and sourced function.
SQL ID
See SQL authorization ID.
SQLJ Structured Query Language (SQL) that is
embedded in the Java programming
language.
SQL path
An ordered list of schema names that are
used in the resolution of unqualified
Glossary 549
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
To Next Page
Loading...
Need help?
General