Condition handlers determine the behavior of your SQL procedure when a condition occurs. You can declare one or more condition handlers in your SQL procedure for general conditions, named conditions, or specific SQLSTATE values.

(Clint Boulton) Security experts at U.K.-based Next Generation Security Software brought tidings of security vulnerabilities in Oracle and IBM software in time for the Christmas holiday.

(Linda Rosencrance) J.C. Whitney Inc., one of the nation’s largest direct marketers of automotive accessories and parts, has chosen a retail system created jointly by IBM and CommercialWare Inc. to replace a 35-year-old homegrown system that could no longer effectively connect customer orders with i

Text User Interface for DB2 UDB Administration is a lightweight, text-based DBA solution for fast, efficient, and effortless database maintenance, convenient access to critical system information, and simplified use of DB2 support tools. This technology can be used remotely through any terminal emul

This new enterprise search engine–released on November 30–is ideal for intranets, extranets and public corporate Web sites that integrate with WebSphere Portal Server or any other portal or content management system. We will overview the product from the business and technical perspectives, de

(Ephraim Schwartz) Leveraging its acquisition of Trego, an ISV with a product information management system, IBM unveiled additional middleware components to work with the Trego technology to ensure product data synchronization between retailers and suppliers.

(Barbara Darrow) A new IBM hybrid database geared for handling structured and unstructured data is in the hands of about 30 alpha testers, an IBM executive said.

DB2 SQL Procedural Language (SQL PL) is a subset of the SQL Persistent Stored Modules (SQL/PSM) language standard. This standard is the basis for the structured programming languages used with SQL to write stored procedures, functions, triggers, and standalone code. Encapsulating complex business lo

(Eric Auchard) The U.S. Army has enlisted IBM and a handful of other companies to create an automated record-keeping system that ends the need for electronic forms to be printed out, signed and delivered up the military service’s chain of command.

(James M. Snell) The open source Derby database engine provides developers with a powerful new tool for lightweight database development. Derby databases are file system based and portable across different types of systems. Because of this, a common strategy is to create databases at development