U

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [Z]

UDFs
     timeouts
     wait times
UDFs (User-Defined Functions)
     CREATE FUNCTION statements 2nd 3rd
         CALLED ON NULL INPUT clause
         CONTAINS SQL clause 2nd 3rd
         DETERMINISTIC clause
         DISALLOW PARALLEL clause
         expressions
         EXTERNAL ACTION clause
         function body 2nd
         function names and parameters 2nd 3rd 4th
         INHERIT SPECIAL REGISTERS clause
         iSeries 2nd 3rd
         LANGUAGE SQL clause
         MODIFIES SQL DATA clause 2nd 3rd 4th 5th 6th
         NO EXTERNAL ACTION clause
         NOT DETERMINISTIC clause
         PREDICATES clause
         READS SQL DATA clause 2nd 3rd 4th 5th
         RETURN NULL ON NULL INPUT clause
         RETURNS clause 2nd 3rd
         scalar example 2nd 3rd 4th 5th 6th 7th 8th 9th 10th
         specific names
         STATIC DISPATCH clause
         table example 2nd 3rd 4th 5th 6th
         zSeries 2nd
     external functions
     index extensions
     invoking from triggers 2nd 3rd 4th 5th 6th 7th 8th
         zSeries 2nd
     invoking SQL procedures 2nd 3rd 4th 5th 6th 7th 8th
         data access restrictions 2nd
         data integrity 2nd 3rd 4th 5th
         transaction controls 2nd 3rd 4th 5th 6th 7th
     nesting SQL statements 2nd
     overloading
     sourced functions
     SQL functions 2nd
UDFs (User-Defined Functions). [See also functions]
UDTs (user-defined data types)
     distinct types
     syntax
     using 2nd 3rd
Uncommitted Read isolation level, cursors 2nd 3rd 4th 5th 6th 7th
UNDO handlers
UNICODE value, PARAMETER CCSID clause
unit of work (UOW)
     definition
     ROLLBACK statements
Universal Database Add-in for Microsoft Visual Studio.NET (DB2)
Universal Database development (DB2) plug-in for Eclipse
Universal Database development plug-in for IBM WebSphere Studio Application Developer (WSAD)
UNIX
    installing DB2 LUW
         Development Center 2nd
unqualified procedure names 2nd
unqualified trigger names
UOW (unit of work)
     definition
     ROLLBACK statements
UPDATE DATABASE/DATABASE MANGER CONFIGURATION command
UPDATE statememts
     positioned updates 2nd 3rd 4th 5th
UPDATE statement
     NEXT VALUE and PREVIOUS VALUE expressions
UPDATE statements
     error checking
     FINAL TABLE statements 2nd 3rd
     INCLUDE columns 2nd
     MERGE SQL statements 2nd 3rd 4th
     NEW TABLE and OLD TABLE statements 2nd 3rd 4th
     performance improvements 2nd 3rd 4th
     RUNSTATS command
     SQL statement phases
     transactions 2nd 3rd 4th
UPDATE statements. [See also IUD statements]
UPDATE triggering statements 2nd 3rd 4th
     AFTER trigger
     AFTER UPDATE example 2nd 3rd 4th 5th 6th 7th 8th
     INSTEAD OF example 2nd 3rd 4th 5th 6th
     nesting SQL statements
     ON UPDATE SET DEFAULT/NULL clauses
     REFERENCING NEW/OLD clauses
updateable special registers 2nd
UPPER function
     string comparisons
USAGE privilege
     sequence objects 2nd
USE REGISTERS keyword
     PUT ROUTINE command
user groups as resources 2nd
user IDs
     DC projects 2nd
USER special register
user-defined data types. [See UDTs]
user-defined distinct types. [See UDTs]
User-Defined Functions. [See UDFs]
users/user groups
    privileges
         required by iSeries stored procedure users 2nd
         required by LUW stored procedure users 2nd 3rd
         required by stored procedure users in production environment
         required by zSeries stored procedure users
USERSPACE1 table space 2nd 3rd
USERSPACE1 tables space
     versus DSNDB04 database
usertempspace table space 2nd 3rd 4th
USING clause
     EXECUTE statements 2nd