(Alejandro Gervasio) Putting all of your content for a particular file on one page can be very user unfriendly to website visitors. Nobody likes to be confronted by a tiny vertical scroll bar! In this article, the first in a series, you will learn a simple way to paginate records from a text file us
Other News
Data Sharing in a Heterogeneous Database Environment
(Glenn VanBenschoten) Studies show that data volumes are doubling every 6-18 months. Some analysts acknowledge, however, that as those volumes grow, the pace of information consumption accelerates – the moment when changed data must be useful and usable for the business. These converging forces put
OpenSQLTrace: Automated Trace Processing and Analysis System
(Andrew Zanevsky, Chad Littlewood, Michael Hayes, Raied Idan, and Bill Nicholson) The value of data captured by traces increases significantly if you run traces on a regular basis and preserve all results for historical trend analysis. But storage space quickly becomes a constraint. Our main pro
You cannot access OLE DB Provider for DB2 and ODBC Drivers for DB2 from an active server page in Microsoft Host Integration Server 2004
You may receive error messages when you try to access the following from an active server page (ASP): • Microsoft OLE DB Provider for DB2, also known as Db2oledb.dll • Microsoft OLE DB Provider for DB2 for AS/400 and for Virtual Storage Access Method (VSAM), also known as Snaoledb.dll • Micro
Which Document Management Solution is Right for You?
(Ian Altman) With the release of IBM Lotus Workplace Documents 2.0, and its recent acquisition of Aptrix and Green Pasture, IBM now has five distinct offerings for document and content management. So, how do you decide which product(s) is/are right for you? If you have four discussions, you’ll proba
Database File Archive And Restoration Management
The Database File Archive and Restoration Management application can be used for archiving and restoring hard disk files whose file references are stored in a database. This application can be used on Windows as well as on different UNIX versions. It supports both Oracle and DB2 databases.
XML viruses threaten Web services security
(Nitin Bharti) Gone are the days when it was enough to scan your computer and e-mail attachments for malicious files. As XML traffic over the Internet increases, the threat of viruses, worms and malware is crossing over into the world of Web services. (R)
Workflow and Service Oriented Architecture (SOA)
Information Technology is becoming more than ever a science in its own right, new architecture for designing information systems uses real mathematical formulae which are difficult for neophytes to understand: SOA = (EDI + EAI + XML + BPM) x WEB (R)
Solution for Migrating from Oracle on UNIX to SQL Server on Windows
This solution provides process and technical guidance that shows how Oracle databases and related applications on a UNIX platform can be migrated to a Windows-based and SQL Server 2000-based platform. The guidance is prescriptive in nature and captures best practices and learnings acquired by subjec
BUG: The return data type depends on the location of a UNION operation where char and varchar data types are combined in SQL Server 2000
Consider the following scenario. In Microsoft SQL Server 2000, char and varchar data types are combined in a UNION operation. If the UNION operation is included in a view or in a subquery, the return data type of the combined column is char. If the UNION operation is a stand-alone query, the return