(Mike Faust) Stored procedures and built-in functions can greatly expand the power and usefulness of SQL, but surprisingly these highly useful tools remain untapped by many programmers. For programmers who are new to the subject or those who want to expand on what they already know, this book provid

(Joe Pluta) My recent articles have leaned toward the overview side of the spectrum, being as they’ve been “first look” articles and coverage of topics from a managerial viewpoint. Not this one, dear reader. Despite the “Round 1” appellation, this article is going to quickly dive right into the nuts

(Craig S. Mullins) In today’s modern enterprise, information is power; and database systems are the predominant technology for storing, managing, and accessing the data that enterprises use to turn into information. And DB2 is one of the leading database systems on the market. (pdf)

(Justin Whitney) With the release of DB2 Express-C, IBM offers its first absolutely free version of DB2. That’s right, free. So what’s the catch? What’s gimped in Express-C and how does it differ from the “bigger” versions? Well, you’ll be surprised to discover that, aside from a few features, it’s

(Nelson King) IBM DB2 Alphablox 8.3 is an incremental advancement of a product that lives between the possibility of enabling nonprogrammers to build online analytical processing applications and the vastly more difficult developer’s slog of building such programs from scratch. The key word is build

(Anju Sudhakar) WebSphere Application Server (Application Server) is a high-performance transaction server that features an extremely scalable transaction engine capable of handling high-volume secure transactions and Web services. Application servers are middleware that handle application functions

(Vincent McBurney) People who have been using a tool for a long time learn some shortcuts. I’ve done a brain dump of any DataStage short cuts I can remember.

(Eric Herber) Relational database servers build the information backbone for many companies today. These companies rely on the smooth operation of their database servers and any outages could have an great impact on their business. Keeping that in mind, backup is one of the most critical aspects for

(Ramesh Krishna Reddy) SQL (structured query language) is used to acccess, manipulate or control the access of rantional database. Databases like DB2, ORACLE, SQL SERVER 2000 support the SQL (Structured query language).

(Ueli Wahli, Larissa Leybovich, Neil MacKinnon, Eric Prevost, Russell Scher, Andre Venancio and Sascha Wiederkom) This redbook presents a business process management (BPM) “round trip” scenario, showing how a business can use a full business integration solution to complete the following tasks: –