(Bonnie Baker) One of the questions folks ask me is, “How can I get just one row out of DB2 when I know that many rows will qualify for my SQL statement?” In this column I will discuss the different ways you can make this happen in DB2 for OS/390 and, more importantly, the performance differences an
Other News
Aggregate Functions
Aggregate functions perform a calculation on a set of values and return a single value. With the exception of COUNT, aggregate functions ignore null values. Aggregate functions are often used with the GROUP BY clause of the SELECT statement.
Hands On: Inside the Tricky PHP-to-XML Project
(Ian Palmer) PHP-to-XML projects can be either relatively straightforward or somewhat complex, depending on whom you ask. And now, as PHP becomes a familiar scripting environment for programmers working with and supporting XML, questions about the interoperability of both languages abound. This week
IDUG 2004 – North America
IDUG 2004 – North America features one of the most comprehensive technical programs dedicated to the DB2 professional. The conference focuses on continual learning, where you can gain insightful, relevant information concerning DB2 and topics such as Autonomic Computing and SMARTer databases, how yo
Managing Exceptional Behavior, Part 2
(Steven Feuerstein) In part 1, I offered suggestions for both an overall exception handling strategy and best practices for raising exceptions in your programs. In this article, I complete my treatment of error handling in PL/SQL, with a look at how best to handle exceptions once they have been rais
What is the difference between SET and SELECT when assigning values to variables, in T-SQL?
Traditionally, SQL Server database developers are accustomed to using SELECT for assigning values to variables. This was fine and a perfectly valid practice right until SQL Server 6.5. Microsoft released SQL Server 7.0 in 1999. SQL Server 7.0 introduced the new SET statement for initializing and ass
admin db – baseline and trends using sysperfinfo :: (Script Library)
Category: Backup Software Tags: Backup software, Restore softw Compatibility: SQL Server 2000 and later Description:
admin db – db file performance baseline and trends using ::fn_virtualfilestats :: (Script Library)
Category: Backup Software Tags: Backup software, Restore softw Compatibility: SQL Server 2000 and later Description:
Thinking XML: The open office file format
(Uche Ogbuji) OpenOffice.org is a mature, open source, front office applications suite with the advantage of a saved file format based on an open XML DTD. This gives users and developers an extraordinary amount of flexibility and power in dealing with work produced in OpenOffice.org. This article in
Beginning XML – Chapter 2: Well-Formed XML
(Kurt Cagle, Dave Gibbons, David Hunter, Nikola Ozu, Jonathan Pinnock and Paul Spencer) We’ve discussed some of the reasons why XML makes sense for communicating data, so now let’s get our hands dirty and learn how to create our own XML documents. This chapter will cover all you need to know to crea