(Arup Nanda) Over the last 27 years, Oracle has made tremendous improvements in its core database product. Now, that product is not only the world’s most reliable and performant database, but also part of a complete software infrastructure for enterprise computing. With each new release comes a some
Other News
Generate SOAP Faults in JAX-RPC Handlers
(Kevin Jones) he Java API for XML-based Remote Procedure Calls (JAX-RPC) specification allows you to map Web service operations onto Java method calls through handlers, and you can use handlers to process SOAP headers for Web services applications. I discussed writing and configuring handlers for ge
Binary Waltz, Play On
(Robin Berjon) Over two months have now passed since the W3C workshop on Binary Interchange. While the binary XML debate rages on in the XML community, the cautious observer will note that the discussion is shifting from a polarised and rather sterile fight to a slightly quieter conversation in whic
Publish your DB2 data to PDF using XSL
(João Alberto de Oliveira Lima) This article describes a simple method for publishing DB2 data in PDF format using XSL (eXtensible Stylesheet Language). The process requires three steps: first, you create an XML file using DB2’s new built-in XML functions; second, you transform that file using XSL-F
Exploring Yukon T-SQL – Top Option
(Vinod Kumar) There are tons of new features that are getting introduced in the next version of SQL Server codenamed Yukon. And this is the first in the series of articles, I would explore T-SQL enhancements we are presented with this new version. In this article we will explore how the TOP operator
Comparing Two Tables: Highlighting the Differences
(Sanjay Ray) This is an extension to the code tip that I supplied on 21 December 2003, “Comparing Contents of Two Tables with Identical Structure.” The following script highlights the columns that are different in the two tables, so there is no need to compare each column individually. The columns v
Understanding .NET Performance Counters
This is in continuation from the previous article on performance counters for SQL Server. In this article we will look at some of the useful .NET Performance counters we need to monitor. Use these as the baseline counters. This is NOT the exhaustive list. But surely a basic top 25 to keep a watch on
All for One and One for All – Introducing Unicode (Part 1)
(Sarah Ellis) Wherever you are in the world and whatever your own code page requirements, DB2 for z/OS Version 8 will bring Unicode into your world! There are fundamental changes on the horizon which build on Version 7’s ability to create Unicode tables, lifting the current restrictions and signific
Application Performance Tuning for DB2 UDB
(Joshua Steffan) Today, databases are at the foundation of a business computing architecture that often includes Web servers, application servers, client workstations, application logic, networks, and other components. Since the database acts as the data server, it can quickly turn into an applicati
DB2 Development Center – Tips to Get Up and Running
(Abdul H. Al-Azzawe) The DB2 Development Center is a great new tool specifically designed for developing server-side stored procedures, user-defined functions (UDFs), and EJB structured data types. This article contains information to help make your Development Center experience a pleasant one. It r