(Roman B. Melnyk and Paul C. Zikopoulos) This article outlines result set retrieval from SQL data-change operations support in the IBM DB2 Universal Database (DB2 UDB) products as of Version 8.1.4. Result set retrieval from data-change operations (INSERT, UPDATE, and DELETE) is supported in DB2 UDB

This two-part tutorial assists developers in developing DB2 Everyplace mobile applications using J2ME APIs and deploying the application in the J2ME Emulator using the J2ME toolkit. Part one deals with developing the mobile application. (R)

These downloadable files are screen captures of DB2 Content Manager version 8.2 installations presented as Viewlets. You may download the appropriate viewlet and graphically walk through each process step-by-step.

(Craig Mullins) I have a cursor that selects “n” rows from a table based on certain conditions. For each of the rows selected, certain functions have to be performed that updates a few tables. If there is any error while processing, the updates to the table are rolled back and continue processing wi

(Suita Gupta and Nanda Pilaka) This article shows you the basics of how to model a DB2 UDB database using IBM Rational XDE Developer for Java.

(Roger Sanders) Nine percent of the DB2 UDB V8.1 Family Fundamentals certification exam (Exam 700) is designed to test your knowledge about the mechanisms DB2 Universal Database uses to protect data and database objects against unauthorized access and modification. This chapter introduces you to the

A federated database system is a special type of database management system(DBMS). IBM’s DB2 Information Integrator offers powerful facilities for building a federated database by combining information from multiple data sources. Users of DB2 Information Integrator can submit SQL queries over views,

DB2 SQLJ support, provided by the DB2 Application Development Client, allows you to create, build, and run embedded SQL for Java applications, applets, stored procedures and user-defined functions. Because SQLJ uses static SQL, it carries the advantages of improved performance (because the SQL is bo

The DB2 DBMS offers a useful suite of methods to ensure data consistency. Primary key constraints forbid duplicate values in one or more columns of a table. Foreign key constraints ensure consistency of tuple (row) references across tables. Table check constraints are conditions that are defined

(Deepak Vohra) JBoss 4.0, developer edition, is an open source application server configured to use HypersonicDB by default. However, some Java 2 Platform Enterprise Edition (J2EE) developers would like to use databases other than HypersonicDB to develop and deploy applications. In this tutorial, we