(Chris Eaton) In my last posting I described the new Insert/Update/Delete from Select statement in DB2 v8.1.4. But as mentioned, even more powerful is the ability to Select directly from an Insert, update or delete statement.
Other News
How to Build Grammars for Speech-enabled Applications
(Sara Morgan Rea) Most companies you call have automated voice attendants that walk you through a series of menu choices until you are finally directed to a live person. As the automated portions of these systems gain use and popularity, they’re becoming increasingly sophisticated—even helpful.
Build temporary tables to optimize SQL queries
(Arthur Fuller) Learn how to build a table from a list of values and join the table to the target table. You’ll also discover how to build the temporary table to hold the values.
Integrating PeopleSoft CRM with Oracle E-Business Suite Using BPEL
(Lawrence Pravin) Many organizations have heterogeneous application portfolios that cross different departments, geographic locations, or subsidiaries. While multiple ERP systems may be necessary to meet the requirements of the business unit, they essentially result in data fragmentation. Integratio
Validation Ccontrols in ASP.NET
(Ramaswamy R.S) In this short tutorial, we will consider the following controls in ASP.Net: · RequiredFieldValidator; · CompareValidator; · RangeValidator; and · Validation summary
Reincarnation of DataTable in ADO.NET 2.0
(Mahesh Chand) In previous versions of ADO.NET, if you used a DataSet (Who haven’t), you most likely are familiar with slow performance of the DataSet when loading and serializing a large amount of data. Now ADO.NET team has done a fantastic job by taking care of these problems in ADO.NET 2.0 by ext
Comparing Microsoft SQL Server Replication and DataXtend RE Replication for Mobile and Distributed Applications
If you are considering Microsoft replication capabilities you need to understand how these capabilities compare to DataXtend RE. This white paper discusses the differences in SQL Server and DataXtend RE replication capabilities across several areas and also reviews the challenges of supporting multi
FIX: Error message when you modify the security of a custom dimension in SQL Server 2000 Analysis Services: ‘Dimension Security Syntax Error: Set name 48818.79 is not valid’
When you modify the security of a custom dimension in Microsoft SQL Server 2000 Analysis Services, you may intermittently receive an error message that is similar to the following: Dimension Security Syntax Error: Set name 48818.79 is not valid. Do you still want to use this expression for di
Optimizing BI Performance with Business Objects and IBM
Business Objects and IBM have long been the business intelligence standard for thousands of customers. With IBM DB2 v8.1 and BusinessObjects Enterprise 6, the next generation of our market leading business intelligence solutions come together to enable organizations to take advantage of new query op
Users Unmoved by Oracle Pricing Changes
Users interviewed after Oracle Corp. revamped its multicore-processor pricing model last month seemed largely unimpressed with the move.