Oracle requires using cursors with SELECT statements, regardless of the number of rows requested from the database. In Microsoft® SQL Server™, a SELECT statement that is not disclosed on a cursor returns rows to the client as a default result set. This is an efficient way to return data to a client
Other News
Installing and configuring DB2 UDB V8
(Susan Visser and Bill Wong) Although the DB2 documentation covers the installation and configuration of DB2 servers and clients, this chapter provides more detailed instructions on installing the server. (Day 6, “Installing and Configuring DB2 Clients,” shows how to install the DB2 clients.) I also
XML Namespaces
XML Namespaces provide a method to avoid element name conflicts.
Reading XML file with ASP
(Faisal Khan) XML stands for Extensible Markup Language. XML can be used in many ways and one of which is ‘data storage’. This is the one we will be exploring in this article. XML along with XSL ( Extensible Stylesheet Language ) can by used to present data on the web pages. XML provides the data an
An introduction to DB2 UDB Backup Solution with Veritas NetBackup
(Sylvia Qi and Raul F. Chong) This article provides step by step instructions on how to setup Veritas NetBackup to work with DB2 Universal Database (UDB). It also provides examples of how DB2 UDB backups and restores work.
Worst Practice – Triggering External Events
(Steve Jones) Andy Warren started his worst practice series some time ago with the intention of looking at the worst things you can do. Given that we may not always be able to implement the best practices, at least we can try to avoid doing things harm the system or decrease performance. This art
DB2 Java Stored Procedures Learning by Example
(Maria Almeida) Stored procedures can provide major benefits in the areas of application performance, code re-use, security, and integrity. The DB2 Family of products has offered support for stored procedures for some time, with each release offering significant enhancements over the last. In the
Bring the Right JAX to Play
(Kelli Wiseth) XML has become a key technology throughout the enterprise in Web services, business-process management (BPM), enterprise-application integration (EAI), and numerous other initiatives. As a result, Java developers can expect XML to play an increasingly important role in development pro
Monitor Event Viewer on Multiple SQL Servers
(Muthusamy Anantha Kumar) In the typical IT department, an un-avoidable task is to monitor the Event Log on all of the servers. It is tedious to go through all the logs one by one, on a daily basis. In this article, the methods presented will help in monitoring the Event Viewer on many servers from
XSLT Support in the .NET Framework
(Jayram Tallamraju) XSLT is an excellent technology that adds more power to XML. XSLT is a language by itself like most other programming languages. It is the language to transform source data structure to destination data structure and may not be suitable to implement business logic. This means tha