(Brad Cowdrey) Part 6 of this series takes an in depth look at analytical windowing and aggregation comparison through examples including syntax and behavior. In addition, this article will build on the information and examples from the previous articles in the series. All of the examples run off of
Other News
Data Orchestration
(Robert Andrews) Do you want to encrypt DB2 Universal Database (UDB) data on your iSeries server? Have you ever wished data could be auto-incremented in a table? Have you ever wanted to reorganize a table while your production applications are still active? Do you desire easier integration of ILE RP
Take Advantage of Isolated Storage with .NET
(Mike Amundsen) Many applications commonly handle user preferences. Application developers often need to store items such as the arrangement of windows on the screen, default color selections, and other values somewhere so that the application can call them up the next time the user loads it. In add
XML: How Do I Hate Thee?
(Edd Dumbill) For a group of people who spend so much time working with and talking about XML, it’s not surprising that the members of the XML-DEV mailing list know exactly what it is that they dislike about XML. Over the last week, we’ve had a festival of complaint about and hate of XML’s misfe
The Brave (And Secure) New World Of Web Access
(Tom Glaser) If you’re like me, you’ve spent your whole career on the mainframe. Your knowledge of the PC world has grown – not because you wanted it to, but because you had to learn it to survive. You’ve had to figure out how to access your email and the Internet or intranets. Over the years, y
Database Resource Manager
(Kimberly Floss) A big challenge DBAs face is aligning database resources with the real-world demands of daily business and realigning those resources as demands change—especially in terms of meeting SLAs (service-level agreements) with internal and external customers. Oracle Database Resource M
Stored Procedure vs Triggers
(G Vijayakumar) Last time, I wrote an article and focussed on Using SELECT, Views and Stored Procedures in SQL Server. I was quite glad to differentiate the three and its Pros & Cons. I was not even given much importance of Trigger not because of NO TIME. To be honest, I was just a beginner i
Managing DB2 objects within TSM Command
This allows users to query, extract, verify, and delete backup images, logs, and load copy images saved using Tivoli Storage Manager. It also allows users to grant and revoke access to objects on a TSM server.
Cutting and Sewing with XML
(Peter Coffee) It’s rarely a term of praise to compare an IT system to a quilt. In an IT context, I usually see the “q” word with a prefix like “patchwork” or even “crazy”—labeling a system as combining all sorts of independently developed elements with no coherent overall design.
HOW TO: Paging result set returned via XML
The best way to deal with result set page would be to use an XPath query and the position() function. However, XML for SQL doesn’t currently support this function so we can not use it. There are two other methods which can be used. Which one you use depends on your result set. Both of these examples