(Roman B. Melnyk) Constraints are used by DB2 UDB to enforce business rules for data and to help preserve database integrity. This article describes the various types of constraints supported by DB2 UDB and provides examples of each constraint type. In addition, the author explains the fundamentals
Other News
Manipulating Oracle Files with UTL_FILE
(James Koopmann) Maintenance of the Oracle alert log file has and continually will be a pain to work with until the day that Oracle realizes they need to hook in a few more operating system utilities to manage their own trashcans. About this time last year I wrote an article called ‘That Darn Alert
Database Wars: Oracle vs. Microsoft
(Vincent Ryan) The clash between Oracle and Microsoft in the database-management system market is a case of the grass always seeming greener in the other guy’s yard. While Microsoft owns the small and mid-size market, it wants to move up to large enterprises with mission-critical database applicatio
Synchronizing Production Data with a Test Database on SQL Server
(Muthusamy Anantha Kumar) Every corporation has a unique infrastructure environment. Let us consider a simple production, testing, and a development environment. The SQL scripts application, developed in a development environment will be tested in a QA environment and then moved to production on a p
Processing XML with C# and .NET – A solution that’s simpler than you might expect
(Andreas Solymosi) Microsoft’s counterpiece to Java, the new C# programming language with its rich .NET library, uses XML as a core technology. This article presents some basic ideas, for example creating and manipulating a DOM tree, and reading and writing XML streams. I also compare .NET’s sol
XML-based Factories and Reusable Components
(Gualtiero Chiaia) In the real world, a factory is a physical entity specializing in the automated production of goods, all having well specified features. Most often, the production process consists of the assembling of third-party sub-components, also having well specified features. Typically, a p
SQL Server and .NET: A Dynamic Duo
(Rick Dobson) By now, most developers know that SQL Server and Microsoft .NET are a dynamic duo. The Microsoft .NET Framework is on its way to becoming an integral part of several important Microsoft server products, including SQL Server. Even now, developers can create SQL Server solutions through
SOAP Tutorial — Free
SOAP is a simple XML based protocol to let applications exchange information over HTTP. In our SOAP tutorial, you will learn what SOAP is, and how it uses XML to exchange information between applications.
DB2 Universal Database Security
(Roger Sanders) So far, we have identified the authorities and privileges that are available, and we have examined how these authorities and privileges are granted and revoked. But to use authorities and privileges effectively, you must be able to determine which authorities and privileges are appro
Optimizing Performance / Indexes on Temp Tables
(Bill Richmond) The general rule is to avoid using temp tables, usually in favor of derived tables or table variables, but there are times when it seems that nothing else will do the job. Or, maybe we just inherit complex code that already makes extensive use of temp tables. Frequently, query perfor