(Supal Chowdhury) The following code performs powerful Date type validation in XSD. It validates date fields with timestamp (optional) in yyyyMMdd hh:MM:ss.ffffff format.
Other News
Know Who Know How
(Michael Miley) Tony Macedo has a cure for what ails you—if what ails you is the corporate equivalent of multiple personality disorder. He’s built an Oracle-based “identity management” server that he hopes to deliver to each of the 12 directorates at Lawrence Livermore National Laboratory (LLNL).
DB2 Migration to Version 8 – Part 2
(Marin Komadina) As it was demonstrated in my last article, an error free DB2 V7 to V8 migration procedure is compromised of database software and catalog tables migration. The user data was not migrated, leaving the user tables and indexes intact. The series of post migration tests have been done p
DB2/400 DB2 UDB Fact or Fiction?
DB2 expert Kent Milligan provides advice to Search400.com’s members on a regular basis. Do you feel you’re also a DB2 guru? Test your knowledge against some of Kent’s recent Q&As below. Mark each question with either a True or False. Jot down your answer on a piece of paper, and then click over to t
Tie in data with Web services and XSL Transformations
(Nicholas Chase) In Part 5 of this tutorial series on analyzing data with XSLT, the MindMap Research Team decides to tie their data in with other services, pulling information from Amazon Web Services in response to information unearthed in the analysis. Web services provide information in XML,
Create a view and triggers with IBM DB2 Development Add-In for .NET
This tutorial, a follow-on to a previous tutorial, explores the features of the IBM DB2 Development Add-In for Microsoft Visual Studio .NET. More specifically, we create a view with two base tables. In addition, we create three INSTEAD OF triggers that will insert, update, and delete rows in the vie
The Daily Database Build
(graz) Continuous integration is a popular concept in software development right now. One of the key components of this is making sure you always have a clean build of your program. This can also be applied to database development. This article shows how to build a cheap, simple series of scripts th
File Inserter Transformation
(Allan Mitchell) SQL Server 2005 has made it a lot easier for us to loop over a collection and with each iteration do something with the item retrieved. In this article we are going to show you how to iterate over a folder looking at the files within and doing something with those files. In this ins
Bulk-Insert Options for ADO.NET
(Michael Otey) Clients commonly ask me how to bulk insert data into SQL Server from ADO.NET applications. There’s no easy answer to this question because ADO.NET doesn’t have any built-in bulk-insert objects. The most straightforward method for performing bulk-insert operations from ADO.NET is lo
Designing and Managing an XML Warehouse
(Xavier Baril and Zohra Bellahsène) Data present on the Web is unstructured, or has incomplete, irregular, or frequently changed structure. XML is becoming the universal data exchange model on the Web. It has been shown that XML is well suited for representing semi-structured data. Compared to HTML,