(Pat Moffatt, Bruce Creighton and Jessica Cao) This tutorial, Part 6 of the SQL & XQuery tutorial for IBM DB2 series, expands on Data Manipulation Language (DML) and introduces Data Definition Language (DDL) and Data Control Language (DCL). It also discusses SQL statements other than SELECT. (R)

(Robert Catterall) Q: When a program contains a static SQL statement that references an unqualified table name, how can you know which table will be accessed when your database includes several different tables (same structure, different data) that have the same unqualified name but different high-l

(Whei-Jen Chen, John Chun, Naomi Ngan, Rakesh Ranjan and Manoj K Sardana) DB2 Express Edition for Community (DB2 Express-C) is a no charge data server for use in development and deployment. DB2 Express-C supports a full range of APIs, drivers, and interfaces for application development including PHP

(Paul Zikopoulos) In a previous series of articles I showed you all the great integration features between the IBM DB2 Universal Database for Linux, UNIX, and Windows Version 8.x (DB2 UDB) product and the Microsoft Visual Studio.NET 2003 integrated development environment (IDE).

(Craig Mullins) A couple of days ago I posted a blurb giving advice on using variable character columns in DB2. After thinking about the topic a little bit more, I decided to post a follow-on topic: namely, comparing the use of VARCHAR to DB2 compression.

(Victor J. Soderberg) At the time of this writing, the Java Database Connectivity (JDBC) 4.0 specification is expected to be released from beta testing. It offers developers several enhancements to speed development and create a more object-oriented paradigm with regard to accessing and manipulating

(Willie Favero) “Oh what a tangled web we weave…”* And DB2 does, if you are not careful. There are so many things that affect other things in DB2 that we sometimes take for granted.

DB2 9’s “pureXML” technology introduces powerful XML management capabilities. Here’s how to use the skills you already have to put that power to work. (R)

(Willie Favero) This is one of those features added in Version 8 that is just plain cool and could give you a bit of a performance boost. It lets you SELECT what has just been INSERTed in the same SQL statement. Think about all the neat places you could use something like this. For example, say you

There are many challenges in responding to the needs of improving Global Software Delivery. IBM supports and enables these requirements by: Closed Loop Software Delivery Management: Faster, higher quality build and production cycle time Developing Flexibility: that incorporates proven best practices