(Klaus Aschenbrenner) Much of the buzz surrounding the release of SQL Server Yukon seems to be about its new integration with the CLR. However, there are plenty of other worthwhile features in this lastest release—and at least one of them can make your database application programming whole a lot ea
Other News
Creating and Consuming Web Services With PHP
(Jean-Luc David) Web services are widely supported by all the major technology vendors and organizations including IBM, Microsoft, Sun Microsystems and the W3C. Millions of dollars have been invested in the development of this technology. Web services allow you to share data across many platforms an
The Mutation error in Oracle Database Triggers
(Amar Kumar Padhi) The Mutating table error is a well-known problem encountered in development; most developers have come across this error.
Install DB2 on Red Hat Enterprise Edition 3.0 or Red Hat 9.1
Red Hat Enterprise Edition 3.0 and Red Hat 9.1 are not DB2 UDB supported versions. Installing DB2 UDB on these two Red Hat version requires a work-around. This technote provides the work-around when db2setup is used.
Deleting Duplicate SYS Constraints
(Devanshi Parikh) System generated (redundant) check constraints can really drain the performance of a database. But sometimes, such as when using third party tools with Oracle, it becomes impossible to avoid them. I have developed a script, which is actually a UNIX Korn shell script, that retrives
DB2 programming strategies
(David Martineau, Steve Sanyal, Kevin Gashyna, and Mike Kyprianou) Database applications provide programmers with the challenge of utilizing DBMS resources efficiently. DB2 provides rich features such as UDFs, stored procedures, concurrency, and transaction management. Using these features properly
Exception Handling in SQL Server 2000 and Yukon
(Amol Kulkarni) Error handling plays a vital role when writing stored procedures or scripts. In this article I will discuss error handling in SQL Server 2000 and SQL Server Yukon. Before starting the discussion of the error handling part, I will take you through the different components of an error
SQL Server 2000 DTS Part 11 – DTS Designer Tasks – the Message Queue task
(Marcin Policht) It is finally time to complete our coverage of DTS tasks – the only remaining one that we have not presented yet is the Message Queue task. However, before we describe its features and provide an example demonstrating their use, let’s first spend some time discussing the concept of
Do the DB2 v.7 for z/OS ZPARMS SRTPOOL and MAXRBLK refer to the global respective sort spaces or to the SORT and RID SORT pools for each individual user?
I thought that the DB2 v.7 for z/OS ZPARMS SRTPOOL and MAXRBLK referred to the global respective sort spaces, but I recently read somewhere that they refer to SORT and RID SORT pools for each individual user. Mine are each set to 8,000 (4K, pages). If what I read is true, I’m worried that I’m crowdi
Use the power of conditional processing in XSLT
Most developers I know don’t regard XSLT as a programming language, but a quick perusal of its many features suggests otherwise. Although it is not as powerful as languages like Java and C#, XSLT does contain basic features for working with XML documents. (R)