(Robert Catterall) DB2 shops are finally diving in with this underused feature. When support for stored procedures first appeared on the mainframe scene with DB2 for OS/390 version 4, it wasn’t an instant hit. For one thing, the feature was aimed at users of the DB2 for OS/390 distributed data fa
Other News
How To: Configuring SQLXML IIS
(Dan Doris) As a note, most problems I’ve seen with people setting up a virtual directory in SQLXML, tends to be from either using the normal IIS snap-in instead of the SQLXML IIS Configuration utility or the standard IIS setup has been changed. Prior to setting up SQLXML you should verify your IIS
Follow these steps to secure your data layer
(Robert W. McLaws) For many developers, building applications is a lot like building a family. The Business tier is like the oldest child: mature and responsible, it knows how to handle everything, and is good at telling people what to do. The Presentation tier is like the youngest child. The baby o
Avoiding the ORA-12154: TNS: could not resolve service name error
(Steve Callan) Where were you when Oracle9i was released? Okay, so it wasn’t that memorable of an event for most users, DBA’s, and the rest of the world. However, given that Oracle9i was released over two years ago, it is interesting to note that its new features are still being announced, highlight
Tip: Parsing XML documents partially with StAX
(Berthold Daum) The Streaming API for XML (StAX), introduced in the previous tip, provides not only an XML parser that is fast, easy to use, and has a low memory footprint, but one that also provides a filter interface that allows programmers to hide unnecessary document detail from the application’
Understanding Oracle XML DB
This series of tutorials uses the Simple XML Based Content Management Application to demonstrate programming techniques that take advantage of the features of Oracle XML DB, a feature of Oracle 9i Database Release 2. The Oracle XML DB is fully compliant with the W3C XML data model thereby provid
Storing XML in Relational Databases
(Igor Dayen) There are various ways to solve the problem of effective, automatic conversion of XML data into and out of relational databases. Database vendors such as IBM, Microsoft, Oracle, and Sybase have developed tools to assist in converting XML documents into relational tables.
Reorganizing DB2 databases: why, how and when?
Databases have become the universal means of storing information that is accessed in real time. In a perfect world, databases should function all the time without needing any major maintenance such as a reorganization. However maintenance remains necessary in order to eliminate performance degra
Can One Size Fit All?
(Dare Obasanjo) Traditionally, APIs for processing XML have been categorized according to whether they’re designed for processing entire XML documents loaded in memory, such as the W3C DOM, or for processing XML in a streaming, forward-only fashion, such as SAX. However, these divisions do not fully
HOW TO: Use XML templates to edit/view data using HTML forms
This example will demonstrate how to use XML for SQL to view and edit data in a browser. The example makes use of an XML template and an XSL stylesheet. It can be run using the sample Northwind database.