trigger body
The set of SQL statements that is executed
when a trigger is activated and its
triggered action condition evaluates to
true. A trigger body is also called
triggered SQL statements.
trigger cascading
The process that occurs when the
triggered action of a trigger causes the
activation of another trigger.
triggered action
The SQL logic that is performed when a
trigger is activated. The triggered action
consists of an optional triggered action
condition and a set of triggered SQL
statements that are executed only if the
condition evaluates to true.
triggered action condition
An optional part of the triggered action.
This Boolean condition appears as a
WHEN clause and specifies a condition
that DB2 evaluates to determine if the
triggered SQL statements should be
executed.
triggered SQL statements
The set of SQL statements that is executed
when a trigger is activated and its
triggered action condition evaluates to
true. Triggered SQL statements are also
called the trigger body.
trigger granularity
In SQL, a characteristic of a trigger, which
determines whether the trigger is
activated:
v Only once for the triggering SQL
statement
v Once for each row that the SQL
statement modifies
triggering event
The specified operation in a trigger
definition that causes the activation of
that trigger. The triggering event is
comprised of a triggering operation
(insert, update, or delete) and a subject
table or view on which the operation is
performed.
triggering SQL operation
The SQL operation that causes a trigger to
be activated when performed on the
subject table or view.
trigger package
A package that is created when a
CREATE TRIGGER statement is executed.
The package is executed when the trigger
is activated.
trust attribute
An attribute on which to establish trust. A
trusted relationship is established based
on one or more trust attributes.
trusted connection
A database connection whose attributes
match the attributes of a unique trusted
context defined at the DB2 database
server.
trusted connection reuse
The ability to switch the current user ID
on a trusted connection to a different user
ID.
trusted context
A database security object that enables the
establishment of a trusted relationship
between a DB2 database management
system and an external entity.
trusted context default role
A role associated with a trusted context.
The privileges granted to the trusted
context default role can be acquired only
when a trusted connection based on the
trusted context is established or reused.
trusted context user
A user ID to which switching the current
user ID on a trusted connection is
permitted.
trusted context user-specific role
A role that is associated with a specific
trusted context user. It overrides the
trusted context default role if the current
user ID on the trusted connection matches
the ID of the specific trusted context user.
trusted relationship
A privileged relationship between two
entities such as a middleware server and
a database server. This relationship allows
for a unique set of interactions between
the two entities that would be impossible
otherwise.
TSO See Time-Sharing Option.
TSO attachment facility
A DB2 facility consisting of the DSN
command processor and DB2I.
Applications that are not written for the
554 Application Programming Guide and Reference for Java
™
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
To Next Page
Loading...
Need help?
General