(kgayda) Function to allow for checking if an IP address is a private IP address. Will convert the IP to a bigint equivalent if within the private range, otherwise it will return null if IP is a public address. (R)(script)
Community
XML Namespaces FAQ
(Ronald Bourret) The XML namespaces recommendation defines a way to distinguish between duplicate element type and attribute names. Such duplication might occur, for example, in an XSLT stylesheet or in a document that contains element types and attributes from two different DTDs. An XML namespac
Store large XML documents in relational databases
(Brian Schaffner) When storing XML documents in relational databases, you may experience difficulties depending on your approach and, in particular, the size of the documents. This column will examine some specific problems related to large XML documents and the techniques to overcome them. (R)
DB2 UDB V8 and WebSphere V5 Performance Tuning and Operations Guide
(Whei-Jen Chen, Peter Z. He, Andreas Paulsen, Sunminder S Saini and Kang Young Ying) This Redbook discusses the integrated environment of DB2 UDB and WebSphere Application Server (WAS) including design considerations, best practices, operation, monitoring and performance tuning. We provide an ove
Oracle Database 10g: The Top 20 Features for DBAs
(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
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