(David S. Linthicum) Although a number of standards exist for information interchange and process definition, industry standards have yet to emerge for defining common integration server and B2B integration server services such as routing, rules processing, and transformation. In the absence of such
Other News
YukonJack – Try-Catch test script :: (Script Library)
Category: Reporting and Analytics for SQL Server Tags: sql reports, sql reporting, sq Compatibility: SQL Server 2000 and later Description:
Advanced SQL Server Locking
(Andrés Taylor) I thought I knew SQL Server pretty well. I’ve been using the product for more than 6 years now, and I like to know my tools from the inside out. While teaching a SQL Server programming course, I noticed that the Microsoft material presented a lock compatibility table. The same tab
Datetime values in DB2 for iSeries
(Craig Mullins) I have a numeric field stored in an AS400 field RDDT00 as yyyymmdd, but it is stored as numeric not date. What I’m trying to do is pull the value then convert it to a date datatype, but I keep getting an error: Token is invalid. Here’s how to address some common mistakes.
DB2 SQL Procedural Language: Using Flow of Control Statements
(Drew Bradstock, Hana Curtis, Michael Gao, Zamil Janmohamed, Clara Liu, Fraser McArthur and Paul Yip) Loops allow you to execute a set of statements repeatedly until a certain condition is reached. The loop terminating condition may be defined at the beginning, in the middle, or at the end of the lo
Database Maintenance Plans
(Robin Schumacher) “You can pay me now or pay me later” is a familiar phrase spoken by auto mechanics. Because of time and money (and sometimes just laziness) a lot of folks put off taking their car in for proactive maintenance work. The thing is, a little work performed over defined intervals in a
Oracle/PLSQL: To_Date Function
The to_date function converts a string to a date. Here’s an example of how it works.
Understanding and Using SELECT … FOR XML
The SELECT statement is the most fundamental data access query in SQL Server. It allows you to retrieve and aggregate information from tables in a database and return the results as a rowset. In SQL Server 2000, the FOR XML clause was added as an extension to SELECT, which transforms the rowset outp
HOW TO: Add a Column to an XSLT Data View That Counts the Lines in That Data View
This article describes how to insert a column in an XSLT Data View that counts the number of records in that Data View.
The Key to Success with Web Services
(Jeff Browning) Web services provide a way to allow efficient communication between disparate services. For years, enterprises have struggled to find reliable, cost-effective ways to integrate and automate critical processes between different application packages. Web services technology has the pot