(Darren Green) You can use a parent or master package to control the execution of one or more child packages. This is often used in a looping scenario, or when there are a number of individual packages that make up a process. This can be achieved very simply in SQL Server 2000 by using the Execu
Other News
Consume XML In JSP
(Chanoch) XML will save the world! …At least, that’s what I was told. But somehow, several years later, most of us are not using eXtensible Markup Language (XML) in our every-day programming. All the same, from time to time, you may be asked to provide a service that will consume or output X
Integrating asynchronous information
DB2 Information Integrator enables real-time integrated access to heterogeneous data such as relational databases, XML documents, queues, and text files. It can all be transparently accessed from a common platform and combined using the power of SQL. In this tutorial you’ll use DB2 Information Integ
Monitoring Air Pollution in Real Time Using XML – A reliable and cost-effective open source solution
(Stanko Blatnik, Ruslan Kadyrov and Kelly Carey) A few years ago there was no indication that XML could play an important role in computer-based process control. However, fast development and the spread of XML to different fields, and emerging trends in the field of automation, have changed the situ
Take Control of Joins
(Itzik Ben-Gan) When you write a multitable join that uses inner joins exclusively (or for that matter, only cross joins or only full outer joins), the table order you specify in the FROM clause doesn’t affect the query result. However, when you’re using left or right outer joins, if you revise the
Designing Schemas
(Cameron O’Rourke) When you build an application, do you start with a database schema that has been solidly designed and tested? Or does your application begin its lifecycle on a wobbly foundation, perched atop a machine-generated schema? In this article, I hope to convince you to view database
WSDL Tutorial
WSDL (Web Services Description Language) is an XML-based language for describing Web services and how to access them.
Finding Memory Leaks Using JDeveloper’s Debugger
(Brian Duff) Memory leaks in Java applications can sometimes be tricky to detect and diagnose. Although garbage collection in Java eliminates much of the fuss of manual deallocation needed in languages like C, it’s sometimes a double-edged sword. Cleaning up is mandatory (if somewhat tedious) in lan
A Comparison of Oracle 9i with DB2 v8.1
(Alexander Chigrik) It is very difficult to make a performance comparison between Oracle 9i Database and DB2 Universal Database v8.1. The performance of your databases depend rather upon the experience of the database developers and database administrator than from the database’s provider. You can u
DB2 OLAP Server – Theory and Practices
(Corinne Baragoin) OLAP has evolved into a mainstream information technology and it is a major component of Business Intelligence solutions across all industries today. The increasing demands for analyzing large amounts of data and empowering a growing number of employees throughout the enterprise