(Mike Faust) In my past two TechTips, I reviewed 11 of the new built-in SQL functions added to the iSeries implementation of DB2 UDB in V5R3. Now, let’s take a look at the 14 remaining new functions. I’ll break the functions down into groupings based on the type of values handled by the function.
Other News
Should you use a DataReader or DataSet?
(Douglas Reilly) In the beginning, there was the recordset, a central feature of classic ADO. Like a Swiss army knife, it wasn’t the perfect tool for every job, but given the correct configuration, it could do whatever you needed it to do.
Schema evolution in an Enterprise Replication environment
(Nagaraju Inturi) This article describes schema evolution (the support of alter table operations for replicated tables) in the Enterprise Replication environment. Schema evolution support in Enterprise Replication is a new feature for IBM Informix Dynamic Server Version 10.00. This feature lets you
Inside MySQL 5.0
Do you want to know all about the new features of MySQL 5.0? Do you want to develop new database applications that use MySQL Stored Procedures, Triggers, Views, and Information Schema? Do you want to upgrade existing applications to MySQL 5.0? If you answered “yes” to any of these questi
Pocket This Decoder for WS-Alphabet Soup
(Laurence Moroney) The Web Services Interoperability organization (WSI) has developed a whole stable of standards upon which Web services commerce and communication can be executed securely. These standards are in great demand and many developers have already gotten their feet wet with a few of them
Disk Space Alert Script
(Harry Parkinson) Monitor the free disk space on your SQL Server and send an alert via email or net send if the available space on any of the drives SQL Server resides on is lower than the specified limit. The script could also be scheduled as a job to provide 24/7 monitoring. Supports SQL Server 7
Architectures for Intrusion Tolerant Database Systems
(Peng Liu) In this paper, we propose four architectures for intrusion-tolerant database systems. While traditional secure database systems rely on prevention controls, an intrusion-tolerant database system can operate through attacks in such a way that the system can continue delivering essential se
Testing the DBAs
(Howard Fosdick) The DBA certifications are the most popular DB2 credentials. They’re not earned lightly, but with a little preparation, you can pass the test. IBM splits the certified DBA credential by platform: Exam #701 covers Linux, Unix, and Windows, and Exam #702 covers the mainframe. I’ll cov
Basic SELECT Statements
(John Godel) You can create queries to retrieve information from your database by using the SQL Query Tool in the Enterprise Manager, ISQL/w, ISQL, MSQuery, other tools, and third-party utilities. In this section, you will look at using the SELECT statement to retrieve rows and columns from tables i
Walkthrough: Working with Offline SQL Server Data in Excel
(Brian A. Randell) Microsoft Office Excel makes it easy to work with rectangular data, such as data from an external database. In this walkthrough, you’ll load data from Microsoft SQL Server into an ADO.NET dataset. You’ll then use the Excel object model to support synchronizing changes made to the