By Antone Gonsalves – IBM plans to release next year a software tool that will improve DB2 Content Manager’s ability to manage the many different XML documents used by enterprises.Code-named “Cinnamon,” the utility will be integrated with the administrative tools for Content Manager’s reposi
Author: SSWUG Research
Recovering Accidentally Lost Data Using Oracle’s Flashback Query
by Sreeram Surapaneni – Oracle database uses a version based read consistency mechanism by saving an image of the data prior to making any modifications. These changes are stored in the undo tablespace. If the users decide not to commit the transaction, Oracle uses the data saved in the undo tablesp
SQL Server anti blocking strategies
In this article Sancho Fock discusses various strategies for reducing blocking in SQL Server databases.
Truncating Data When Exporting to Excel
I built a Data Transformation Services (DTS) package that exports data from a table in SQL Server 7.0 to a spreadsheet in Microsoft Excel. The package’s first run works fine, but subsequent runs just append the data to the spreadsheet instead of replacing it in the spreadsheet. How can I avoid this
IBM Lowballs DB2
By Charles Babcock – IBM is challenging Microsoft for midsize- and small-business database users by pricing the Express version of its DB2 database at $598 for a single user running it on a single processor.
CSS 3 Selectors
by Russell Dyer – Although the promise of Cascading Style Sheets (CSS) has been wondrous, the progress has been wanting. As with all W3C standards, there is the lengthy discussion process conducted by the related working group, then the problem of implementation by web browser vendors, and finally t
Relaxer 1.0 Release Candidate 2 available
Relaxer is a Java class generator that operates on a XML document defined by a RELAX grammer.By using Relaxer, no tedious DOM programming is required to make a XML aware program. Relaxer creates a set of Java classes that form an object hierarchy that is logically equivalent to a DOM
Well-structured XML Goes Cosmopolitan
Everyone knows that among its many uses, XML can store the same data in multiple languages and dish it out like a U.N. translator when the computers of the world come calling. What everyone doesn’t know is how best to structure that polyglot of data. There’s more than one way.
DB2 user certification prep, Part 1: DB2 Tools, data warehousing and OLAP
This tutorial introduces the basics of the DB2 Tools, and the concepts of data warehousing and OLAP. It is designed to help you prepare for the DB2 Fundamentals Certification (Exam 512). The material in this tutorial primarily covers the objectives in the first section of the exam, Section 1. Instal
Shortening XSLT Stylesheets
by Manfred Knobloch – XSLT is often considered to be too verbose. As stylesheet code grows, it tends to be unreadable. This is not a fate stylesheet authors have to accept. There are some strategies to keep your XSLT code short. This article proposes some ways of shorten stylesheets without loss of