DB2 SQL PL: Essential Guide for DB2 UDB on Linux, UNIX, Windows, I5/OS, and Z/OS
Prentice Hall PTR, 2005 - Computers - 550 pages
Annotation "DB2 SQL PL, Second Edition shows developers how to take advantage of every facet of the SQL PL language and development environment. The authors offer up-to-the-minute coverage, best practices, and tips for building basic SQL procedures, writing flow-of-control statements, creating cursors, handling conditions, and much more. Along the way, they illuminate advanced features ranging from stored procedures and triggers to user-defined functions."--BOOK JACKET.Title Summary field provided by Blackwell North America, Inc. All Rights Reserved.
What people are saying - Write a review
We haven't found any reviews in the usual places.
Basic SQL Procedure Structure
Overview of SQL PL Language Elements
Using Flow of Control Statements
19 other sections not shown
Other editions - View all
access plan applies to LUW applies to zSeries bonus buffer pool c_dept cache caller catalog chapter clause client compound statement condition handler create procedure statement CREATE TABLE cursor data types DB2 for zSeries DB2 LUW DB2 SQL DB2 UDB DB2ADMlN debug defined delete deploy empno error execute fetch handler declared hdbc identity column inline SQL PL INT DEFAULT INTEGER invoked isolation level LANGUAGE SQL SPECIFIC Linux lock loop LUW and iSeries NULL option output p_empno package parameter performance platforms primary key printf Procedure logic query result set return statement rollback salary SAMPLE database save point schema script server shown in Figure specified SQL procedure sqlcode sqlrc SQLSTATE statement on Line stored procedure syntax diagram SYSIBM table space temporary table TIMESTAMP trigger UDB for iSeries UDFs UNIX user-defined v_raise varchar Windows WLM ENVIRONMENT env z/OS