by Bob DuCharme – Has transclusion been implemented in any widely-used web technology? Transclusion-like capabilities are specified in the XInclude Candidate Recommendation, but this spec tells us that “Simple information item inclusion as described in this specification differs from transclusion, w
Other News
Setting Up a User Exit on DB2 UDB V8 to Archive Database Logs
By David Kline – This article explains how to use a user exit program to manage the archiving and retrieving of database log files for DB2 UDB.
Creating an XML-based customer repository using DB2 XML Extender
By Naveen Balani – XML has emerged as the accepted standard for data interchange over the past few years. DB2 XML Extender integrates the power of IBM’s DB2 Universal Database (DB2 UDB) with the flexibility of XML. This tutorial introduces DB2 XML Extender and shows you how to set up DB2 to support
Marking Milestones
By Michael Otey – SQL Server reached significant milestones in performance and overall market share this past year. But Microsoft faces the challenge of keeping SQL Server affordable and easy to use while adding advanced features aimed at the enterprise.
Watch your timeouts – DBA’s quick guide to timeouts, by Chris Kempster
In this article, Chris discusses in detail, the various types of timeout problems, and show you how to alter various settings to address timeout errors. He also provides VB code samples along with this article.
DB2 Gets Cube Smart
by Mark Leon – IBM claims to have taken some of the pain out of online analytic processing (OLAP) with a new piece of software called Cube Views that adds OLAP administrative and performance-enhancing functions to DB2, IBM’s relational database.
TOP N Clause vs. SET ROWCOUNT N
Q. Is using the TOP N clause faster than using SET ROWCOUNT N to return a specific number of rows from a query? A. With proper indexes, the TOP N clause and SET ROWCOUNT N statement are equally fast, but with unsorted input from a heap, TOP N is faster.
Trigger to Prevent Dropping Objects
by Rajasekhar Aluru – This trigger secures objects, preventing a user from dropping them by mistake. To begin, create a table for the example below called secured_objects with a column objectname, with datatype varchar2(20). Insert a record into this table with a value, the name of the object, which
Oracle Plots Acquisition Course
By Renee Boucher Ferguson – At its annual financial analysts meeting at its headquarters in Redwood Shores, Calif., Wednesday, Oracle Corp. said it’s in a position of strength and plans to use that to acquire other companies in its quest to give software giants SAP AG and Microsoft Corp. a run for t
Coordinate system, can’t live without it
Excerpt from the book: Learn SVG. The SVG document provides us with a default coordinate system – the initial User Coordinate System. With this user coordinate system comes along a plane 2D-space. This canvas is theoretically infinite in both dimensions. To specify a point on the canvas, we also nee