(Julian Stuhler) Welcome to Part 3 of our exploration of the new features in Version 8 of DB2 UDB for Linux, UNIX and Windows. This time round, we’re going to look at DB2’s brand new multi-dimensional clustering (MDC) capabilities – a feature that’s sure to be a big hit with many hard-pressed databa
Other News
Looping, Importing and Archiving
(Allan Mitchell) One of the most common things asked for by people using DTS is the ability to loop through a directory and process files along the way. This is how I do it. Although it may look a little complicated for what is quite an easy task it isn’t trust me.
Better SQL Server Security
(Michael Otey) Security continues to be one of the hottest topics in IT. The Internet and protocols such as Simple Object Access Protocol (SOAP) and XML have driven constant-connection computing to new levels. And as new technologies make your systems more accessible, the threat from viruses and int
Advanced ANSI SQL Native XML Integration-Part 2 – Supporting advanced XML capabilities
(Michael M. David) Part 1 of this article demonstrated how standard ANSI SQL can integrate fully, naturally, and seamlessly with XML. This was accomplished by naturally raising SQL processing to a hierarchical level, enabling relational data (including XML-shredded data) to integrate at a full hiera
Returning a JDBC result set from an Oracle stored procedure
(Bruce P. Blackshaw) You would think that returning a JDBC result set from an Oracle PL/SQL stored procedure would be quite straightforward. Unfortunately, it’s not as easy as it sounds. But reading this article should tell you all you need to know.
Combining Triggers and UDFs
(Kulvir Singh Bhogal and Kwang Sik Kang) Now DB2 can handle tasks once left to application developers. Ever notice how DBAs in large enterprises are frightened by the thought that their data is being manipulated by applications without their knowledge? They may not like it, but it’s an inescapabl
Trees, Temporarily
(Bob DuCharme) XPath 1.0 has a special data type called Result Tree Fragments. For example, an xsl:variable element can store a single string, but it can also store an XML element with all the descendants and attributes you like. This structure is a Result Tree Fragment. (I try to avoid using the ac
DTS Package for Reporting Low Disk Space
(Lennart Gerdvall) This VBscript code will check for low disk space on the local SQL Server. Schedule the package to run once a day, and let the job report to you by e-mail when a drive runs low on free space.
MDX Essentials: Basic Set Functions: The Intersect() Function
(William Pearson) In this lesson, we will focus our attention on a function that has some characteristics in common with the Union() function, yet produces a very different result. The rather simple purpose of the Intersect() function is to compare two sets, then to return a set that consists of mem
Choose the Proper Data Type
(Craig Mullins) The basic theme of this column has been to review DB2 issues that are confusing or misunderstood. This time, I’ll be tackling a topic that might surprise you-using the proper data types. Indeed, data type and length are the most fundamental integrity constraints applied to data i