Publisher's Synopsis
This is a definitive DB2 UDB V8.1 Family Application Development (Exam 703) preparation guide - straight from IBM. It: covers database objects, SQL, embedded SQL, CLI/ODBC, JDBC, SQLJ, transactions, stored procedures, and user-defined datatypes and functions; reviews advanced programming concepts, such as compound SQL, two-phase commit, and locking; contains extensive sample questions based on the actual exam's format and approach; and includes authoritative coverage of the DB2 exam and certification process. The book is by Roger Sanders, best-selling DB2 certification author and active participant in IBM's exam development process. Recognition as an IBM DB2 Certified Application Developer demonstrates your exceptional expertise in developing for DB2 UDB 8.1, the world's No. 1 enterprise database platform. If you're an IBM Certified Database Associate, you can achieve certification by passing one exam: IBM DB2 UDB V8.1 Exam 703. Straight from IBM, this is the only official Exam 703 self-study guide. Roger E. Sanders, the world-renowned DB2 expert who helped develop Exam 703, covers every objective you must master in order to pass.;Sanders walks step-by-step through basic data manipulation; core DB2 programming methods; SQL and embedded SQL; ODBC/CLI; Java and SQLJ; stored procedures; transactions, user-defined routines; and much more. Every chapter contains an extensive set of practice questions closely modeled on the actual exam, along with carefully explained answers. The coverage includes: in-depth explanations of database objects, privileges, and constraints; SQL and DML statements for storing, manipulating, and retrieving data; embedding SQL in high-level programming language source code; CLI/ODBC development, including conversion into executables; JDBC objects and methods for developing Java database applications; using SQLJ to embed static SQL statements in Java applications; transactions, stored procedures, user-defined functions, and other advanced techniques; and complete information on certification prerequisites and requirements. Whether you're currently preparing for Exam 703, or you simply want to deepen your skills as a DB2 developer, you'll find this book indispensable.
