New SelectViews Show Posted The Weekly SQL Server show about all sorts of different things from how-to to commentary has been updated. This weeks show: Replication Troubleshooting, Managing SQL Server as a Part-Time DBA, Web 2.0 Book(s) Reviewed, Noise and News in the DB world. Also, the 60-Second SQL Server Tip of the Day, Upcoming Events and Information About the […]
Other News
Merging partial result sets from multiple sources of DB2 for Linux, UNIX, and Windows and WebSphere Process Server Business Process Choreographer
(Christian Richter) This article describes how to combine multiple result sets from different data sources of DB2 for Linux, UNIX, and Windows and WebSphere Process Server. You will learn how to use the user interface to display the final result set in smaller segments that are directly retrieved fr
XML data interchange in Java ME applications
(Mario La Menza) This article introduces the use of XML-based objects for data transport in multi-tier Java ME applications. I first explain how the DTO design pattern is commonly implemented in multi-tier Java ME architectures. I then explain the shortcomings of using Java beans as DTOs and propose
Import and Export
(Erik Wetterberg) Recently we have been doing some work with export and import of data from and to MySql databases. Our customer wants to be able to export configuration data from one MySql instance and import it into another.
SQL embedded into PL/SQL
(Patrick Wolf) A few days ago I spoke with another developer about SQL embedded into PL/SQL code and how function calls are handled in the WHERE clause of SQL statements. There is sometimes confusion who (PL/SQL engine or SQL engine) is executing it, I thought it’s a good idea to write a posting abo
Navigating XML Files in .NET
(Jeff Cogswell) Over the past decade or so, XML has proved an incredibly powerful means for storing data. If you’re writing a .NET application, you can make use of XML in your own applications using a set of classes specifically for processing and navigating XML.
Thoughts on DB2 Data Clustering
(Robert Catterall) Although this post is written specifically in the context of a DB2 for z/OS environment, most of what I have to say on the topic applies to DB2 for Linux, UNIX, and Windows, as well.
Troubleshooting DB2 on Rails
(Antonio Cangiano) DB2 on Rails provides the developer with many ways to retrieve information about errors which have occurred. Rails developers can take a look at the logs within the log folder in order to read the SQL errors returned by the datasever.
SELECT as many rows as indicated by column value
(Mike) This select statement will return as many rows as are indicated by the value of a column. For example, if the column value is 7, then 7 copies of that row will be returned.
Ajax and XML: Ajax for media
(Jack D Herrington) With the advent of widely available broadband, media, movies, images, and sound drive the Web 2.0 revolution. Learn to combine media with technologies such as PHP and Asynchronous JavaScript + XML (Ajax) to create a compelling experience for your customers.