S

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]

SAMPLE database 2nd
     iSeries 2nd 3rd 4th
     LUW 2nd 3rd 4th 5th 6th 7th 8th
     zSeries 2nd 3rd 4th 5th 6th 7th 8th
save point levels 2nd
save points 2nd 3rd 4th 5th 6th 7th 8th 9th
     basics 2nd 3rd 4th
     definition
     procedures invoked by UDFs or triggers 2nd 3rd 4th 5th 6th 7th 8th
     SQL procedures 2nd 3rd 4th 5th
SAVEPOINT LEVEL clause
SAVEPOINT statements 2nd
    compound statements
         ATOMIC 2nd
     ROLLBACK TO SAVEPOINT statements 2nd 3rd
SAVOBJ/SAVLIB commands
SBCs (Solution Partnership Centers), IBM
scalar fullselects
schema
    grouping procedures
         best practices
schema names
     SYS
schema-wide catalogs 2nd 3rd 4th
schemas
     function signatures
     qualified functions 2nd
    SESSION
         temporary tables
     SYSCAT
         vieews 2nd
     SYSIBM 2nd 3rd
     tables 2nd 3rd 4th 5th 6th 7th 8th
     trigger names
scope
     condition handlers 2nd 3rd 4th 5th
     GOTO statements 2nd
scripts
    deploying
         functions 2nd
SCROLL parameter
search conditions, CASE statements 2nd 3rd 4th 5th
searched deletes
searched updates and deletes
sections, package cache
security
     dynamic SQL
    iSeries
         developer privileges 2nd 3rd
         privileges required in production environment
         user privileges 2nd
    LUW
         user privileges 2nd 3rd
     nested SQL procedures 2nd
    package objects
         privileges
    zSeries
         authorization 2nd
         developer privileges 2nd
         DYNAMICRULES option on BIND or REBIND statements 2nd 3rd 4th
         package's runtime environment 2nd
         privileges required in production environment
         user privileges
SECURITY clause
     values 2nd
securityLUW
     privileges required in production environment
segmented table spaces
SELECT INTO statement
     inline SQL PL
     SQL PL and inline SQL PL
SELECT INTO statements
     versus SET statements
SELECT statement
     inline SQL PL 2nd 3rd
     NEXT VALUE and PREVIOUS VALUE expressions
     setting variables
     SQL PL and inline SQL PL
SELECT statements
    IUD statements
         NEW_TABLE function 2nd 3rd
     MERGE SQL statements 2nd
     NEW TABLE and OLD TABLE statements 2nd 3rd 4th
     performance improvements 2nd 3rd 4th
     temporary tables 2nd
     UDFs
SENSITIVE parameter
sequence objects 2nd
     ALTER SEQUENCE statement 2nd 3rd
     behaviors 2nd
     CREATE SEQUENCE statement 2nd 3rd 4th 5th
     DROP SEQUENCE statement
     privileges 2nd
     syntax 2nd 3rd 4th
     wrapping in SQL procedures 2nd 3rd 4th
Server view (Development Center) 2nd 3rd 4th 5th 6th 7th 8th 9th 10th
SESSION schema
     temporary tables
SESSION_USER special register
SET CONNECTION statements
     procedures invoked by UDFs or triggers
SET CURRENT LOCK TIMEOUT statements 2nd
SET CURRENT SQLID statements
SET LOCK TIMEOUT statements
SET OPTION clause 2nd
SET OPTION clause, CREATE PROCEDURE statement 2nd 3rd
SET OPTION clause, triggered actions
SET OPTION statement 2nd
SET statement
     inline SQL PL 2nd
     SQL PL and inline SQL PL
SET statements
     value assignment 2nd
SET SYSPARM command
SET TRANSACTION statements
     procedures invoked by UDFs or triggers
SET_ROUTINE_OPTS procedure
     configuring build environment 2nd 3rd
Share lock mode
SIGNAL statements
     forcing handler invocation 2nd 3rd 4th 5th 6th 7th 8th
         iSeries 2nd 3rd 4th
simple table spaces
single INSERT statements
     replacing multiple inserts 2nd
single quotes 2nd
Single-byte Character Large Objects. [See CLOBs]
SMALLINT data type
     identity columns
     sequence objects 2nd
SMS (System Managed Space) 2nd 3rd 4th
Solution Partnership Centers (SPCs), IBM
source data-types 2nd
sourced functions
special registers 2nd 3rd 4th
     CURRENT DATE
     CURRENT SCHEMA 2nd 3rd 4th
     CURRENT TIME
     CURRENT TIMESTAMP
     INHERIT SPECIAL REGISTERS clause
     updateable and non-updateable 2nd 3rd
SPECIFIC clause
SPECIFIC keyword
     GET ROUTINE command
specific names 2nd 3rd
SPECIFIC optional clause 2nd 3rd
SQL
     versus DSS
SQL debugger
    SQL stored procedures
         zSeries
SQL functions
SQL Persistent Stored Modules. [See SQL/PSM]
SQL PL
     dynamic compound statements 2nd 3rd 4th 5th
SQL PL scripting 2nd 3rd 4th
SQL Procedural Language. [See DB2 SQL PL]
SQL procedure
     compound statements
SQL procedure body structure
     comments 2nd 3rd
     compound statements 2nd 3rd 4th 5th 6th
     special registers 2nd 3rd 4th 5th
         updateable and non-updateable
     variables
         defining 2nd
         setting 2nd 3rd
SQL procedures
    best practices
         DETERMINISTIC versus NOT DETERMINISTIC keywords 2nd 3rd 4th
         grouping procedures by schema
         naming conventions 2nd
         repeated statements
    build environment configuration
         DB2_SQLROUTINE_PREPOPTS DB2 registry variable 2nd 3rd
         SET_ROUTINE_OPTS procedure 2nd 3rd
    building
         iSeries, DB2 2nd 3rd 4th 5th
         zSeries, DB2 2nd 3rd 4th 5th
    DB2 command-line processor scripts
         DB2 LUW 2nd 3rd 4th 5th
     deploying
         backup/restore considerations 2nd
         C/C++ compiler considerations 2nd
         code pages 2nd
         from one database to another 2nd 3rd 4th 5th 6th 7th
         with CREATE PROCEDURE statements 2nd
         with DDL 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
         with Development Center 2nd
         with GET ROUTINE and PUT ROUTINE commands 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
         with Navigator 2nd 3rd 4th 5th 6th
         with older releases of DB2 2nd 3rd
     Development Center 2nd 3rd
         debugging
     invoking from triggers 2nd 3rd 4th 5th 6th 7th 8th
         zSeries 2nd
    invoking from triggers and UDFs
         data access restrictions 2nd
         data integrity 2nd 3rd 4th 5th
         transaction controls 2nd 3rd 4th 5th 6th 7th
     invoking in UDFs 2nd 3rd 4th 5th 6th 7th 8th
     overloaded procedures versus overloaded functions
     versus dynamic compound statements 2nd
SQL procedures.
     stored procedures [See also nested SQL procedures]
SQL statements
     EXECUTE phase 2nd
         dynamic and static SQL
     executing 2nd 3rd 4th
         Command window 2nd 3rd 4th
         interactive mode 2nd 3rd 4th 5th
     nesting 2nd
     PREPARE phase 2nd
         dynamic and static SQL 2nd
     single quotes 2nd
     supported in trigger body on zSeries 2nd 3rd
SQL/PSM (SQL Persistent Stored Modules) language standard
     SQL PL subset 2nd
SQLCODE variables 2nd 3rd 4th 5th 6th
     condition handlers 2nd 3rd
         DB2_TOKEN_STRING keyword 2nd
         MESSAGE_TEXT keyword 2nd 3rd 4th 5th
         multiple
         RESIGNAL statements 2nd
         SIGNAL statements
SQLEXCEPTION handlers 2nd 3rd 4th 5th
SQLSTATE 42703 error 2nd
SQLSTATE 70000 error
SQLSTATE ???
     exception handling 2nd
SQLSTATE class code
SQLSTATE variables 2nd 3rd 4th 5th 6th
     condition handlers 2nd 3rd 4th 5th
         DB2_TOKEN_STRING keyword 2nd
         MESSAGE_TEXT keyword 2nd 3rd 4th
         multiple 2nd
         RAISE_ERROR functions
         RESIGNAL statements 2nd 3rd 4th 5th 6th 7th
         SIGNAL statements 2nd 3rd 4th 5th 6th 7th
SQLWARNING handlers 2nd 3rd
STACKED keyword
STAFFRESUME procedure
stand-alone code 2nd 3rd 4th
START WITH option
Statement Event Monitor 2nd 3rd 4th 5th 6th
statement save points
statement terminators 2nd
STATIC DISPATCH clause
     CREATE FUNCTION statements
static SQL
     Statement Event Monitor 2nd 3rd 4th 5th
     versus dynamic SQL 2nd 3rd
Statistics Manager 2nd 3rd
STAY RESIDENT clause
stored procedure languages
     converting other stored procedures to DB2 SQL PL
     Informix SPL
     PL/SQL
     T-SQL
stored procedures
    clauses
         CALLED ON NULL INPUT
         CONTAINS SQL DATA
         DETERMINISTIC
         DYNAMIC RESULT SETS
         EXTERNAL ACTION
         INHERIT SPECIAL REGISTERS 2nd
         LANGUAGE SQL 2nd
         MODIFIES SQL DATA
         NEW SAVEPOINT LEVEL 2nd
         NO EXTERNAL ACTION
         NOT DETERMINISTIC
         OLD SAVEPOINT LEVEL 2nd
         PARAMETER CCSID 2nd
         READS SQL DATA
     CREATE PROCEDURE 2nd 3rd 4th 5th 6th
         parameters 2nd 3rd 4th 5th
    creating
         BIND behavior 2nd
         DEFINE behavior 2nd 3rd 4th
         INVOKE behavior 2nd 3rd 4th
     database application objects
     Development Center
     Development Center projects 2nd 3rd 4th 5th
         breakpoints 2nd 3rd 4th
         debugging procedures 2nd 3rd
         running 2nd 3rd
         running procedures 2nd 3rd
         running procedures, settings 2nd 3rd
         stepping through procedure code 2nd 3rd
     history 2nd
     importing 2nd 3rd 4th 5th 6th 7th
    Java
         multiple result sets 2nd 3rd 4th 5th 6th 7th 8th
         receiving result sets 2nd 3rd 4th 5th 6th
    names
         qualified versus unqualified 2nd
     overloaded
    privileges required
         by iSeries developers 2nd 3rd
         by iSeries users 2nd
         by LUW users 2nd
         by zSeries developers 2nd
         by zSeries users
         in production environment
    resources
         IBM Redbooks 2nd 3rd 4th 5th 6th 7th 8th 9th
     specific names 2nd 3rd
     STAFFRESUME
    transactions
         save points
     uses
stored procedures. [See also nested procedures]
     SQL procedures [See also nested SQL procedures]
STRDBMON command 2nd
     Navigator
string built-in data type
     using 2nd
string built-in data types
     maximum length 2nd
     subtypes
string data type
     selection checklist 2nd
Structured Query Language. [See SQL]
style meanings 2nd
subtypes
     string data types
syntax
     ALLOCATE CURSOR
     ASSOCIATE LOCATORS statement 2nd
     COMMIT statements 2nd
     compound statements
         ATOMIC 2nd
         NOT ATOMIC 2nd
     condition handlers 2nd 3rd 4th
     CREATE DATABASE command
     CREATE FUNCTION statements 2nd
         iSeries 2nd
         zSeries 2nd
    CREATE PROCEDURE statement
         iSeries 2nd 3rd 4th 5th 6th
         zSeries 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th
     CREATE TRIGGER statements
     DECLARE CURSOR statement
     DECLARE CURSOR statements 2nd
    DECLARE GLOBAL TEMPORARY TABLE
         DB2 LUW
         iSeries
         zSeries
     dynamic CALL statements
     dynamic compound statements
     EXECUTE IMMEDIATE statement
     FETCH statement
     FOR loop statement 2nd
     generated columns
     GET DIAGNOSTICS statements
         iSeries 2nd
         zSeries 2nd
     GET ROUTINE command 2nd
     GOTO statements 2nd
     identity columns 2nd
     IF statements 2nd
     ITERATE statements 2nd
     LEAVE statements 2nd
     LOOP statements 2nd
     positioned deletes 2nd
     PUT ROUTINE command
     RAISE_ERROR functions 2nd
     REPEAT loop statement 2nd
     RESIGNAL statement 2nd 3rd
    RESIGNAL statements
         iSeries 2nd
     RETURN statements 2nd 3rd 4th
         within procedures 2nd
     roll backs 2nd 3rd
     ROLLBACK statements 2nd
     ROLLBACK TO SAVEPOINT
     SAVEPOINT statements 2nd
     sequence objects 2nd 3rd 4th
     SIGNAL statements 2nd
         iSeries 2nd
    statements
         CREATE PROCEDURE 2nd 3rd 4th 5th 6th
     UDTs
     UPDATE statememts
     WHILE loop statements 2nd
syntax diagrams 2nd 3rd
SYS
     schema names
SYSADM (system administrator) authority
     GET ROUTINE and PUT ROUTINE commands
SYSCAT schema
     vieews 2nd
SYSCAT.PACKAGES system catalog view
SYSCATSPACE system catalog tables
SYSDEFLT default storage group
SYSFUN system schema
SYSIBM schema 2nd 3rd
SYSIBM system schema
SYSPROC system schema
system administrator (SYSADM) authority
     GET ROUTINE and PUT ROUTINE commands
system catalog tables
     SYSCATSPACE
System Managed Space (SMS) 2nd 3rd 4th
system-wide catalogs 2nd 3rd 4th
SYSTEM_USER special register