LEADER 05278nam 2200697Ia 450 001 9910826322403321 005 20200520144314.0 010 $a1-280-12733-3 010 $a9786613531216 010 $a1-84968-397-2 035 $a(CKB)2670000000161636 035 $a(EBL)934495 035 $a(OCoLC)781776610 035 $a(SSID)ssj0000830600 035 $a(PQKBManifestationID)11529755 035 $a(PQKBTitleCode)TC0000830600 035 $a(PQKBWorkID)10820165 035 $a(PQKB)11390083 035 $a(Au-PeEL)EBL934495 035 $a(CaPaEBR)ebr10547163 035 $a(CaONFJC)MIL353121 035 $a(PPN)228043115 035 $a(OCoLC)801811786 035 $a(OCoLC)ocn801811786 035 $a(FR-PaCSA)88850688 035 $a(CaSebORM)9781849683968 035 $a(MiAaPQ)EBC934495 035 $a(EXLCZ)992670000000161636 100 $a20120423d2012 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aIBM DB2 9.7 advanced application developer cookbook /$fSanjay Kumar, Mohankumar Saraswatipura 205 $a1st edition 210 $aBirmingham, U.K. $cPackt Pub.$d2012 215 $a1 online resource (442 p.) 300 $aIncludes index. 311 $a1-84968-396-4 327 $aCover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Application Development Enhancements in DB2 9.7; Introduction; Changing column names online using the ALTER TABLE operation; Using the CREATE OR REPLACE clause while creating objects; Using the ALTER TABLE operation in a single transaction; Using the CREATE WITH ERROR support; Using the soft invalidation and automatic revalidation support; Using the ALTER COLUMN SET DATA TYPE extended support; Using the new TRUNCATE statement; Using AUTONOMOUS transactions 327 $aUsing implicit casting during application enablementUsing the DEFAULT values and NAMED arguments in procedures; Chapter 2: DB2 Application Techniques; Introduction; Granting and revoking instance-level authorities; Granting and revoking database-level authorities; Granting and revoking object privileges; Implementing static SQL in DB2; Implementing dynamic SQL in DB2; Creating Declared Global Temporary Tables (DGTTs); Using XML in a declared temporary table; Improving performance by creating indexes on a DGTT; Creating created global temporary tables (CGTT); Using generated columns in tables 327 $aCreating a savepointRolling back to a savepoint; Using savepoints in JDBC; Using savepoints in SQLJ; Creating a sequence object; Modifying a sequence object; Referencing a sequence object; Chapter 3: General Application Design; Introduction; Improving concurrency by using a connection concentrator; Using trusted contexts for improved security; Using trusted connections in JDBC; Using trusted connections in PHP; Securing data by using DB2 encryption; Improving concurrency by using enhanced optimistic locking; Working with user-defined types (UDT); Working with structured types 327 $aChapter 4: Procedures, Functions, Triggers, and ModulesIntroduction; Creating a simple stored procedure; Using dynamic SQL in stored procedures; Working with result sets in stored procedures; Using ARRAY objects in stored procedures; Handling errors in stored procedures; Designing external stored procedures; Using PL/SQL exception handling in a procedure; Working with the message buffer in stored procedures; Planning and designing triggers; Using scalar user-defined functions; Writing external user-defined functions; Designing external table functions; Working with modules in DB2 327 $aChapter 5: Designing Java ApplicationsIntroduction; Creating connection objects in JDBC applications; Creating connection objects in SQLJ applications; Manipulating XML Data in Java applications; Batch processing in JDBC applications; Batch processing in SQLJ applications; Working with scrollable result sets; Handling errors and warnings in JDBC applications; Developing Java applications for high availability; Using SSL in Java applications; Chapter 6: DB2 9.7 Application Enablement; Introduction; First step towards enabling Oracle application to DB2 9.7; Using ROWNUM and DUAL in DB2 9.7 327 $aUsing CUR_COMMIT concurrency control isolation level 330 $aThis cookbook has recipes written in a simple, easy to understand format with lots of screenshots and insightful tips and hints. If you are an IBM DB2 application developer who would like to exploit advanced features provided by DB2 to design and implement high quality applications, then this book is for you. This book assumes you have a basic understanding of the DB2 application development. 606 $aRelational databases 606 $aDatabase management 615 0$aRelational databases. 615 0$aDatabase management. 676 $a005.7565 700 $aKumar$b Sanjay$0846732 701 $aSaraswatipura$b Mohankumar$01618807 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910826322403321 996 $aIBM DB2 9.7 advanced application developer cookbook$94104510 997 $aUNINA