(Davide Mauri) If you ever worked with tables using the text datatype, you have found that you cannot use the REPLACE TSQL function on it. Ok, that’s fine we know that the text datatype has some drawbacks, but we still need to use it (for example I cannot work without it, since a great part of my wo
Other News
Create Index for Foreign Keys
(Shahid Hafeez) This script will generate INDEX CREATION script for all table foreign keys when they are part of primary keys. This is usefull when you need to generate index for reference columns especially for DW applications. (script)
Grouping and Summing the Values in XML Using XSLT
(Siddhartha Singh) In this column, I have grouped the XML based on the GroupID element by using the generate-id() function. This generates unique keys used for indexing the key value. The key value is GroupID.
Enterprise Application Integration with a Native XML Database, Java, and Cocoon – Powerful flexibility with a simple API
(Dan Hatfield) A client recently asked EDS to design and support an EAI implementation based on XML messaging. The implementation of this solution created a need for an internal application that would allow multiple developers and analysts to create and manage a variety of XML documents. The solutio
XML Spy – Development Environment for XML
XML Spy is an IDE (Integrated Development Environment) for XML. XML Spy is centered around a validating XML editor that provides five views on your documents: a Grid View for structured editing, a Database/Table view that shows repeated elements in a table, a Text View with syntax-coloring for lo
IBM hopes to Sting the competition
(Robert Westervelt) IBM is looking to improve its ranking among .NET developers and open source fans with “Stinger,” the next generation of the company’s DB2 Universal Database. According to the latest study by International Data Corp., Oracle currently holds 39% of the database market, followed
Character Repertoire Validation for XML
(Erik Wilde) In this article I present a small schema language for XML — which can be used to restrict the use of character repertoires in XML documents — called a href=”#res-crvx”>Character Repertoire Validation for XML (CRVX). CRVX restrictions can be based on structural components of an XML doc
Support for Isolation Levels Using the ODBC Driver for DB2
The Microsoft ODBC Driver for DB2 provides flexibility in dealing with issues of isolation levels and transaction state. The ODBC SQLSetConnectAttr function is used to set the isolation level that is to be used for a connection. This function would be called with the attribute parameter set to SQL_A
Tree Structured Data and XML – Visualizing and transforming data with SVG and XSLT
(Philip Burton and Russel Bruhn) XML is the appropriate format for semistructured data, that is, data with a natural tree structure. Trees are a special form of graphs, and a dialect of XML called GraphML now exists that provides a standard set of tags for describing them. To visualize or draw the g
SQL Reporting Services: A radically new approach
We have been used to traditional report writers for many years now. In this era of thin client, multi-tier, object oriented, service based architecture, the good old report writers have remained more or less similar. For example, most of these provide header, footer, detail, and group based bands wh