C

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]

C programming language
     stored procedures
C/C++
    receiving mulitple result sets
         in applications 2nd 3rd 4th 5th 6th
    receiving result sets
         in applications 2nd 3rd 4th 5th 6th 7th
C/C++ compilers
     deploying SQL procedures 2nd
c_managers cursors 2nd 3rd 4th
CACHE option 2nd
Call Level Interface (CLI)
     receiving rusult sets 2nd 3rd 4th 5th 6th 7th
         multiple sets 2nd 3rd 4th 5th 6th
CALL statement
     dynamic SQL 2nd 3rd
     inline SQL PL
CALL statements
     dynamic SQL
     passing parameters between nested SQL procedures 2nd
     recursive SQL procedures
     RETURN statements 2nd 3rd 4th
     returning result sets
     returnvalues
CALLED ON NULL INPUT clause
     CREATE FUNCTION statements
called procedures 2nd 3rd
     passing parameters with caller procedures 2nd
     return values 2nd 3rd
caller procedure
     return values 2nd 3rd
caller procedures 2nd
     passing parameters with called procedures 2nd
CARDINALITY clause
CASE statement
     generated columns 2nd
CASE statements 2nd 3rd 4th 5th
     versus IF, ELSE statements 2nd 3rd
catalog tables
     system-wide and schema-wide 2nd 3rd 4th
catalogs
     tables
     views 2nd
CBT (computer-based training) courses 2nd 3rd
CCSID (Coded Character Set ID) 2nd
CCSID clause
CCSID subtype
certifications
     resources 2nd
         guides 2nd
         tutorials
CHAR
     subtypes
CHAR data type
Character Large Objects
    Double-Byte. [See DBCLOBs]
    Single-byte. [See CLOBs]
Character Large Objects (CLOB)
CHECK constraint
CHGCLS command
     DFTWAIT parameter
CHGJOB command
     DFTWAIT parameter
CHGLF command
     WAITRCD parameter
CHGPF command
     WAITRCD parameter
clauses
    statements
         CREATE PROCEDURE
CLI (Call Level Interface)
     receiving rusult sets 2nd 3rd 4th 5th 6th 7th
         multiple sets 2nd 3rd 4th 5th 6th
CLIENT ACCTNG special register
CLIENT APPLNAME special register
Client for Windows
CLIENT USERID special register
CLIENT WRKSTNNAME SCHEME special register
CLOB (Character Large Objects)
CLOB data type
     temporary tables
CLOBs (Single-byte Character Large Objects) 2nd
     WITH COMPARISONS clause
CLP (Command Line Process)
CLP (Command Line Processor)
     launching 2nd 3rd 4th
CLP (Command-Line Processor)
     LUW and zSeries
COALESCE function
     strings
code
    best practices
         exception handling 2nd 3rd
         grouping SQL procedures by schema
         naming conventions 2nd
         readability 2nd
         return values versus out parameters
         size
         transaction controls
code pages
     deploying SQL procedures 2nd
Coded Character Set ID. [See CCSID]
columns
     minimizing in result sets
columns.
     identity columns [See also generated columns]
Command Center 2nd
command line (DB2)
    processor scripts
         DB2 LUW 2nd 3rd 4th 5th
COMMAND LINE commands
Command Line Process (CLP)
Command Line Processor 2nd 3rd 4th
Command Line Processor (CLP)
     launching 2nd 3rd 4th
Command window
     executing SQL statements 2nd 3rd 4th
         interactive mode 2nd 3rd 4th 5th
     launching 2nd 3rd 4th 5th
Command-Line Processor. [See CLP]
COMMENT ON statement
comments 2nd 3rd
    CONNECT statements
         deleting
COMMIT ON RETURN clause 2nd 3rd
     CREATE PROCEDURE statements
     values 2nd
COMMIT ON RETURN YES clause
     CREATE PROCEDURE statements
COMMIT statement
     not supported in inline SQL PL
COMMIT statements 2nd 3rd 4th 5th 6th
    compound statements
         ATOMIC 2nd
         NOT ATOMIC 2nd
     FETCH/UPDATE blocks 2nd 3rd 4th
     No Commit isolation level
     procedures invoked by UDFs or triggers 2nd 3rd 4th 5th 6th 7th 8th 9th
     save points
    transaction controls
         best practices
     WITH HOLD clauses 2nd 3rd 4th 5th
compound SQL save points
compound statements 2nd 3rd 4th 5th 6th
     ATOMIC 2nd 3rd 4th 5th 6th
         COMMIT statements 2nd 3rd
         ROLLBACK statements 2nd 3rd
         ROLLBACK TO SAVEPOINT statements
         SAVEPOINT statements 2nd
         UNDO handlers
     BEGIN and END keywords 2nd 3rd 4th
     function body 2nd
     inner and outer statements 2nd
     labels 2nd 3rd 4th
     nested 2nd
     NOT ATOMIC 2nd 3rd 4th 5th 6th
     order for declarations 2nd
     usage
     variable scoping 2nd 3rd 4th
computer-based training (CBT) courses 2nd 3rd
CONCAT function
     string concatenation
condition handlers 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th
     GET DIAGNOSTICS statements 2nd 3rd 4th 5th 6th 7th 8th 9th
         iSeries 2nd 3rd 4th 5th 6th 7th 8th
         zSeries 2nd 3rd 4th 5th 6th 7th 8th 9th
    IF statements
         iSeries 2nd 3rd 4th 5th
     multiple 2nd 3rd
     RAISE_ERROR functions 2nd 3rd 4th
         iSeries
     RESIGNAL statements 2nd 3rd 4th 5th 6th 7th 8th
         iSeries 2nd
     RETURN statements 2nd 3rd 4th 5th 6th 7th
         zSeries 2nd 3rd 4th 5th
     scope 2nd 3rd 4th 5th
     SIGNAL statements 2nd 3rd 4th 5th 6th 7th 8th
         iSeries 2nd 3rd 4th
CONDITION keyword
conditional statements
     CASE 2nd 3rd 4th 5th
     definition
     IF, ELSEIF, and IF, ELSE 2nd 3rd 4th
conditions
    declaring
         order in compound statements 2nd
conferences as resources 2nd
Configuration Advisor 2nd 3rd 4th 5th
Connect
CONNECT statements
    comments
         deleting
     procedures invoked by UDFs or triggers
connections
     Development Center projects 2nd 3rd 4th 5th 6th
         DB2 Connect 2nd
CONTAINS SQL clause
     CREATE FUNCTION statements
    statements
         CREATE FUNCTION statements 2nd
CONTAINS SQL clauses 2nd
CONTAINS SQL DATA indication clause
CONTINUE handlers 2nd 3rd
Control Center 2nd 3rd 4th
     Automatic Maintenance
     Configuration Advisor 2nd
     Design Advisor
     Visual Explain tool 2nd
conventions
     style meanings 2nd
     syntax diagrams 2nd 3rd
CREATE BUFFERPOOL statement
CREATE DATABASE command 2nd 3rd 4th
CREATE DISTINCT TYPE procedure
CREATE FUNCTION statements 2nd 3rd
     C/C++ compilers
     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
     invoking SQL procedures 2nd 3rd 4th 5th 6th 7th 8th
     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
         expressions
     scalar UDF example 2nd 3rd 4th 5th 6th 7th 8th 9th 10th
     specific names
     STATIC DISPATCH clause
     table UDF example 2nd 3rd 4th 5th 6th
     zSeries 2nd
CREATE GLOBAL TEMPORARY TABLE statements 2nd 3rd 4th
CREATE PROCEDURE statement
     clauses 2nd 3rd 4th 5th 6th
    DB2 command-line processor scripts
         DB2 LUW 2nd 3rd 4th 5th
     DEFINE behavior 2nd
         attribute values 2nd
     iSeries, DB2 2nd 3rd 4th 5th
     parameters 2nd 3rd 4th 5th
     SET OPTION clause 2nd 3rd
     SQL procedure body structure 2nd 3rd 4th 5th 6th 7th
         comments 2nd 3rd
         special registers 2nd 3rd 4th 5th 6th
         variables 2nd 3rd 4th 5th 6th
     syntax 2nd 3rd 4th 5th 6th
     syntax diagrams
     syntax for iSeries 2nd
         COMMIT ON RETURN clause
         FENCED and NOT FENCED clauses
         SET OPTION statement 2nd
     syntax for zSeries 2nd 3rd
         ASUTIME clause
         COMMIT ON RETURN clause 2nd
         FENCED clause
         NO COLLID clause 2nd
         NO DBINFO clause
         PROGRAM TYPE clause
         RUN clause 2nd
         SECURITY clause 2nd
         STAY RESIDENT clause
     zSeries, DB2 2nd 3rd 4th
CREATE PROCEDURE statements
     C/C++ compilers 2nd
     COMMIT ON RETURN clause
     COMMIT ON RETURN YES clause
     deploying SQL procedure 2nd
     DYNAMIC RESULT SETS clauses
         returning multiple result sets
CREATE SCHEMA command
CREATE SCHEMA statement 2nd
     catalog views 2nd
CREATE SEQUENCE statement
     sequence objects 2nd 3rd 4th 5th
CREATE statements
     FREEPAGE clause
     Generate SQL output 2nd 3rd 4th
     PCTFREE clause
CREATE TABLE statement
     generated columns 2nd
     identity columns 2nd 3rd 4th 5th 6th 7th
     schemas
CREATE TABLE statements
     ALLOCATE clause
CREATE TRIGGER statements 2nd
     AFTER 2nd
         FOR EACH ROW/STATEMENT clauses 2nd
    AFTER INSERT/UPDATE/DELETE
         example 2nd 3rd 4th 5th 6th 7th 8th
     BEFORE 2nd
         FOR EACH ROW/STATEMENT clauses 2nd 3rd
    BEFORE INSERT
         example 2nd 3rd 4th 5th 6th
         zSeries
     C/C++ compilers
     DB2ROW clause
     DB2SQL clause
     DELETE 2nd
         ON DELETE SET NULL clause
     INSERT 2nd
         REFERENCING NEW/OLD clauses 2nd
     INSTEAD OF 2nd 3rd 4th 5th 6th 7th
         example 2nd 3rd 4th 5th 6th
     qualified or unqualified names 2nd
     SET OPTION clause
     triggering statements
     UPDATE 2nd 3rd
         INSTEAD OF example 2nd 3rd 4th 5th 6th
         ON UPDATE SET DEFAULT/NULL clauses
         REFERENCING NEW/OLD clauses
     view triggers versus table triggers 2nd 3rd 4th
     WHEN clause 2nd
     zSeries 2nd 3rd
CREATE_NOT_FENCED_ROUTINE statements
    privileges
         developers
cross-platform DB2
    resources for stored procedures
         IBM Redbooks 2nd
CRTLF command
     WAITRCD parameter
CRTPF command
     WAITRCD parameter
CRTPGM command 2nd
CURRENT APPLICATION ENCODING SCHEME special register
CURRENT CLIENT_WRKSTNNAME special register
CURRENT DATE register 2nd
CURRENT DATE special register 2nd 3rd 4th 5th 6th
CURRENT DBPARTITIONNUM special register
CURRENT DEFAULT TRANSFORM GROUP special register
CURRENT DEGREE special register
CURRENT EXPLAIN MODE special register
CURRENT EXPLAIN SNAPSHOT special register
CURRENT ISOLATION special register 2nd
CURRENT keyword
CURRENT LOCALE LC_CTYPE special register
CURRENT LOCK TIMEOUT special register 2nd
CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION special register
CURRENT MEMBER special register
CURRENT OPTIMIZATION HINT special register
CURRENT PACKAGE PATH special register 2nd
CURRENT PATH special register 2nd 3rd 4th
CURRENT PRECISION special register
CURRENT QUERY OPTIMIZATION special register
CURRENT REFRESH AGE special register
CURRENT RULES special register
CURRENT SCHEMA special register 2nd 3rd 4th 5th 6th 7th 8th 9th
CURRENT SERVER special register
CURRENT TIME register 2nd
CURRENT TIME special register 2nd 3rd 4th 5th 6th
CURRENT TIMESTAMP register 2nd
CURRENT TIMESTAMP special register 2nd 3rd 4th 5th 6th 7th
CURRENT TIMEZONE register 2nd
CURRENT TIMEZONE special register
CURRENTDATA parameter
     lock controls
Cursor Stability isolation level, locks 2nd 3rd 4th 5th 6th
cursors
     ambiguous
     c_managers 2nd 3rd 4th
     COMMIT statements 2nd 3rd 4th
         FETCH/UPDATE blocks 2nd 3rd 4th
         WITH HOLD clauses 2nd 3rd 4th 5th
    DECLARE CURSOR statement
         iSeries 2nd 3rd
     DECLARE CURSOR statements 2nd 3rd 4th
    declaring
         order in compound statements 2nd
     definition
     dynamic SQL 2nd 3rd 4th
     FETCH FIRST 1 ROW ONLY clause
     FETCH FIRST 1 ROW ONLY clauses
     FETCH statements 2nd 3rd 4th 5th 6th
     IUD (INSERT, UPDATE, or DELETE) statements 2nd 3rd 4th 5th
     lock modes 2nd
    locks
         best practices 2nd 3rd 4th
         controlling in DB2 LUW 2nd 3rd 4th 5th 6th 7th 8th
         controlling in iSeries 2nd
         controlling in zSeries 2nd 3rd
         isolation levels 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th
     ON ROLLBACK RETAIN CURSORS clauses
     positioned deletes 2nd 3rd 4th 5th
     positioned updates 2nd 3rd 4th 5th
     result sets 2nd
     returning result sets 2nd 3rd 4th 5th
         DYNAMIC RESULT SETS clauses 2nd 3rd 4th
     ROLLBACK statements 2nd 3rd 4th
         FETCH/UPDATE blocks 2nd 3rd 4th
         WITH HOLD clauses 2nd 3rd
     unsupported statements in inline SQL PL
Custom DB2 Development Center installation 2nd
CYLINDER clause