-- Structured Query Language (SQL) is critical to DB2 -- SQL is a standardized query language for requesting information from a database. Although there are different dialects of SQL, it is nevertheless the closest thing to a standard query language that currently exists.
-- DB2 Market Share -- IBM's DB2 database took the lead in the database market in license revenue for 1998. Now controlling 32.3% of the market.
-- DB2 -- Or, Database 2, is a family of relational database products offered by IBM, and it runs on a wide variety of computing platforms, including Windows, UNIX, and OS/2. Using SQL, users can obtain data simultaneously from DB2 and other databases.
-- Hands-on information -- Shows readers how to develop DB2 applications using embedded SQL. Walks readers through the basic steps needed to build, test, and debug embedded SQL applications that communicate with DB2 databases.
-- Full explanation -- Each SQL statement available will be explained in detail and tested with C++ and JAVA programming examples that illustrate how to embed each SQL statement in an application source code. This will be available both in the book, and on the disc.
-- Valuable CD-ROM -- The disc contains the latest version of IBM DB2 Universal Server, plus all of the code from the book and extra development tools and utilities. Approximately 350 Java and C++ example programs are provided in this book.
Table of Contents:
Part 1 Basic DB2 for common servers database concepts: DB2 for common servers database architecture; DB2 for common servers database consistency mechanisms. Part 2 DB2 for common servers database application development fundamentals: understanding the DB2 for common servers application development process; writing DB2 for common servers embedded SQL applications; improving DB2 for common servers application performance. Part 3 DB2 for common servers SQL statements: application programming language construct statements; data control statements; data definition statements; data manipulation statements; event monitor, trigger and stored procedure processing statements; appendices - system catalog views, SQL data structures, SQL functions.