(Roger Sanders) This tutorial introduces you to embedded SQL programming and walks you through the basic steps of constructing an embedded SQL application. The tutorial also introduces you to the process used to convert one or more high-level programming language source code files containing embedde

Often overlooked, space management can have just as great an impact on users as a poorly tuned SQL statement or improperly configured database. DB2 ultimately relies on disk to record data stored within the database, so it is important to understand and take care of the space structures in DB2.

IBM is pleased to announce that the appended certification tests, valued at $75 to $175, will be available at no cost to registered attendees at the IBM Content Management and WebSphere Portal Technical conference held May 2-6, 2004 in Chicago.

(Dirk deRoos) In this tutorial, you’ll learn about writing Java code that interfaces with DB2 Universal Database. This is the fifth in a series of seven tutorials that you can use to help prepare for the DB2 UDB V8.1 Family Application Development certification exam (Exam 703). (R)

(Craig Mullins) You’ll have to rip it apart using functions and then put it back together again as a character. (R)

(Drew Bradstock, Hana Curtis, Michael Gao, Zamil Janmohamed, Clara Liu, Fraser McArthur and Paul Yip) In this chapter, you will learn: –how to use the compound statement; –how to use labels in both compound statements and loops; –how to use the two conditional statements (IF and CASE); –h

(Victor Yang) DB2 Universal Database (UDB) JDBC driver has been a solid and proven technology supported by IBM. Jython is the 100% pure Java implementation of Python programming language. First we will tell you why Jython is powerful, handy and fun in writing DB2 JDBC tools. Then we will show yo

(Scott Hayes and Philip Gunning) At conferences and other speaking engagements, we often say we’ve never met a database whose performance we couldn’t improve. We’re willing to put that claim in print and share tips and tricks gleaned from our combined 22 years’ experience with DB2 Universal Database

(Tim Albrecht) With a more complete implementation of stored procedures in DB2 Versions 5 and 6, many new distributed access opportunities have been given to the DB2 developer. Many shops, ours included, severely limited or completely denied Dynamic SQL access to operational Online Transaction proce

(Enrico Joedecke, Steve Raspudic and Andy Beaton) In this paper, we describe the implementation and design of highly available IBM DB2 Universal Database (DB2) environments in conjunction with the IBM Tivoli System Automation for Linux platform (TSA). Also included is a detailed description of the D