includes index

"Chapter 1 : Introduction -- notational conventions, syntax diagram, examples, tips -- Product overview -- UDB clients and servers, related products, instances and databases, interactive tools, application programs, dynamic applications, stored procedures, user roles -- a brief history of SQL -- systems -- products and standards -- some controversial decisions -- Chapter 2 basics -- tables -- example database -- name and schemas -- basic SQL data types -- queries -- expressions -- datetime arithmetic -- casting -- search conditions -- joins -- column functions -- grouping -- query blocks -- queries and literal tables -- select statement -- values statement -- SQLCODE and SQLSTATE -- Data modification -- insert statement -- update statement -- delete statement -- Data definition --- creating a table -- altering a table -- renaming a table -- creating an alias -- creating a view -- creatingan index -- creating a schema -- dropping an object -- commenting on an object -- normalization -- Protecting data consistency -- transaction -- database connections -- authorization -- instance-level authorities -- database-level authorities -- table and view privileges -- index privileges -- schema privileges -- package privileges -- GRANT and REVOKE statements -- authorization checking -- Chapter 3 interactive SQL -- DB2 tools -- the command center -- the script center -- the journal -- the information center -- the command line processor -- command options -- interactive commands -- controlling isolation level -- controlling connection type -- getting help -- comments -- Chapter 4 STATIC SQL -- using static SQL in C programs -- host variables -- the SQL declare section -- exchanging double-byte strings -- return codes and messages -- whenever statement -- cursor declarations -- ope n statement -- fetch statement -- close statement -- single-row select and values statements -- positioned update and delete statements -- using cursors with interactive SQL -- compound SQL -- example program parts 1 : ordering parts -- Using static SQL in C++ programs -- building an application program -- precompiling a program -- rebinding a package -- Chapter 5 QUERY POWER -- case expressions -- simple form -- general form -- RAISE_ERROR function -- NULLIF and COALESCE functions -- subqueries -- scalar subqueries -- table expressions -- table functions -- explicit joins -- extended from clause -- super groups -- rollup -- cube -- grouping sets -- multiple grouping specifications"