(C. M. Saracco, Jacques Labrie and Julien Muller) Using Enterprise Information Integration (EII) technology to develop portal application components that integrate data from disparate sources can simplify design issues and cut coding requirements by 50 percent or more. In this article, we’ll explain
Other News
Oracle on Windows – Part 2
(Steve Callan) In this second article about Oracle on Windows, we will cover several more areas of interest shared by Oracle and Windows. Using Oracle on Windows is, in many ways, much simpler than using a UNIX variant as the underlying operating system.
Using NAS for database storage
(Rick Cook) Typically the world of databases is divided into transactional databases, which are characterized by many access and relatively simple record structures, and analytical databases with much more complex record structures and relatively fewer accesses. Obviously the kind of database has im
Import multiple Files to SQL Server using T-SQL
(Muthusamy Anantha Kumar) In a typical IT environment, it is often necessary to import flat files to SQL Server tables. Sometimes it is necessary to import many files at the same time, from the same or different folders. In this article, I am going to discuss how to import all of the files from a pa
Cleaning Up XML
(Adam Kolawa) Garbage in, garbage out – it’s an axiom that applies to many aspects of enterprise development, but none more so than building reliable and robust Web applications and integration projects with XML. Since its inception, XML has been seen as the cure-all for every problem related to Web
Worst Practice – Not Qualifying Objects With The Owner
(Christoffer Hedgate) When Andy recently added his latest piece in the Worst Practices series, about adding a column without thinking, it made me think about a worst practice I have been trying to combat for a long time. Maybe not as specific as most other worst practices, but one of the worst pract
Large Data Operations in SQL Server
(Joe Chang) The articles in the Quantitative Performance Analysis series examined the internal cost formulas used by the SQL Server query optimizer in determining the execution plan and the actual query costs for in-memory configurations. The previous articles restricted the actual query cost analys
Say What? Part 2
(Bonnie Baker) In the last issue of DB2 Magazine I began writing about the program preparation process for DB2 Universal Database (UDB) for OS/390 and z/OS. If you haven’t read Part 1, please do so now. Part 2 will make much more sense if you do. If you’re still confused after reading Parts 1 and 2,
How to read XML data from a URL by using Visual C++ .NET
This article describes how to use the XmlTextReader class to read XML from a URL. The streamed information can come from a variety of sources, such as a byte stream from a server, from a file, or from a TextReader class.
DB2 z/OS SQL procedures in VS.NET – build options
This tutorial demonstrates the use of the advanced features of the IBM DB2 Development Add-In for Visual Studio .NET to create and deploy SQL stored procedures from a development environment to a production DB2 for z/OS database environment. (R)