(Jonathan Gennick) Regular expressions represent a powerful tool for describing and manipulating text data. Indeed, from humble roots in early UNIX utilities such as qed and ed, regular expressions have gone on to become almost ubiquitous, supported by a wide variety of programming and scripting lan
Other News
Back Up the Control File Image
(Faina Goldenberg) This UNIX shell script will back up a control file as the current image of controlfile for each active instance (automatically started on the server). (script)
SQL Server Parallel Execution Plans
(Joe Chang) Microsoft SQL Server introduced parallel query processing capability in version 7.0. The purpose of parallel query execution is to complete a query involving a large amount of data more quickly than possible with a single thread on computers with more than one processor. Books Online and
Serialize Arrays and ArrayLists to XML
(Dan Wahlin) The XmlSerializer class provides a great way to convert (serialize) objects to XML and back (deserialize). However, it can be difficult to serialize collections such as Arrays and ArrayLists properly unless you know a few tricks.
Leveraging your Oracle 9i skills to learn DB2 UDB for Linux, UNIX and Windows V8
(Suita Gupta, Allan Tham and Raul Chong) If you’re a database specialist interested in growing your DB2 Universal Database skills, there’s a good chance that you’ve already developed database skills with another relational database product somewhere along the way. In an earlier developerWorks articl
An XML schema pattern to help distinguish between a null and an empty array
(Russell Butek and Richard Scheuerle) Some programs depend on a distinction between a null array and an empty array. What is often used to represent arrays in XML schemas does not have any such distinction. Is there anything you can do to get around this feature of XML? This article will show you.
Introduction to Microsoft Office InfoPath 2003
(Ellen Whitney and Simon Ferguson) It’s Monday. After arriving at the office, you fill out last week’s timesheet (Microsoft Excel), your expense report (a handwritten form), and your project status report (Microsoft Word). When you print these forms, you notice that soon you’ll need a new printer ca
Converting Non-Partitioned Tablespaces to Partitoned Tablespaces without Down Time
(Robert Catterall) This tip shows how to convert non-partitioned tablespaces without down time.
IBM Improves Integration Between DB2 and Microsoft Visual Studio
IBM is updating its DB2 database software to offer tighter integration and better performance for developers who use Microsoft Visual Studio .NET 2003. Enhancements should simplify and automate application development based on the Microsoft .NET Framework. IBM says it’s adding a string of new fe
Understanding the SQL Server Transaction Log
(Kevin Cox and William Jones) SQL Server’s transaction log plays a critical role in replication and in the automatic roll-forward and rollback recovery process. This chapter explains how to use the operation codes to decipher a log and how to get detailed information about transactions in a log usin