(Teemu Keiski) XQuery is a W3C initiative, emerging standard, at the time of writing in draft stage. XQuery is targeted to be a universal query language for XML, without making any distinction where the data has come from. XQuery should bring the features that have existed in relational data access
Other News
User-defined Aggregate Functions in DB2 Universal Database
(Knut Stolze) DB2 Universal Database supports offers several built-in aggregate (or column) functions including AVG, COUNT, MIN, MAX, SUM, and others. However, there is currently no direct way to implement your own user-defined aggregate function. This article presents an approach for achieving spec
Automate the Switch to DB2 Using the IBM DB2 UDB Migration Toolkit
(Alex Jarzebowicz) The no-charge IBM DB2 UDB Migration Toolkit can simplify and improve your migration to DB2 Universal Database (DB2 UDB). This migration utility provides a wizard and an easy-to-use interface with only five steps to help you quickly convert existing Sybase, Microsoft SQL Server, Or
Getting Started with DB2 V8 and ADO using Visual Basic 6
(Essma Hasin) IBM DB2 V8.1 is a great new release with numerous new enhancements in terms of engine capabilities, such as MDC (multi-dimensional clustering) and online reorg to name a few, as well as great new tools such as the Health Center, the Development Center, and the Development Add-Ins for M
Layering XSLT stylesheets
(Chuck White) In this third tutorial in a multi-part series on the benefits of using XSLT, the MindMap Team discovers the need to perform some analyses that require procedural techniques. Because XSLT is not a procedural language, this tutorial explains how to layer and use chain transformations to
Application Development: Consuming Web services in PHP
(Sanders Kauffman, Jr.) There are currently three major ways to build a Web service with PHP. I say, “major” because there’s really almost an infinite number of ways to do it–but most are based on one of three methods: SOAP, XML-RPC and REST. (R)
How to manually reinstall the Microsoft Search service for an instance of SQL Server 2000
In Microsoft SQL Server 2000, you may not be able to create full-text catalogs. Additionally, when you try to start the Microsoft Search service (Full-Text Service), you may receive an error message. If these problems occur, you must manually reinstall the Microsoft Search service. This article desc
SQL Server Yukon: Advantages of the new PIVOT operators
(Sanders Kaufman, Jr.) Database developers who use Microsoft products have often experienced frustration at the disparity of functions between Access and SQL Server. SQL Server, which uses Transact-SQL (T-SQL), is a step behind Access in its range of features, although it is several steps ahead in t
Creating Web Services, Part 2
(Mike Lehmann) The first article of this series looked at the APIs necessary to wrap a Java class so that it could send and receive SOAP messages, by taking a Java class, EmpImpl.java, containing a JDBC database query of an employee table, and publishing and consuming it, using JAX-RPC. Now we focus
Invoking Web services from SQL: Integrating relational data with Web services using DB2 UDB 8.1
Developing applications that access both Web services and database management systems can be an overwhelming task. It doesn’t need to be. This tutorial demonstrates how to generate DB2 user-defined functions (UDFs) that provide access to Web services. The generated UDFs can be used in SQL statements