(Dmitri Khanine) Opening a database connection is a resource intensive and time consuming operation. Connection pooling increases the performance of Web applications by reusing active database connections instead of creating a new connection with every request. Connection pool manager maintains
Author: SSWUG Research
Oracle Response Files – Part 2
(Steve Callan) Part One of Oracle Response Files covered the basics of using a response file and provided an example of how to install Developer Suite on a Windows PC. In Part Two, we will go into more detail about the components of response files. This part will also discuss some related topics as
An Overview in Combining XML Data With XSL Within ASP
(Derrald Farnsworth-Livingston) XML (eXtensible Markup Language) and XSL (Extensible Stylesheet Language) have been created from the necessity of having a structured, defined method of exchanging data. By utilizing XML information that can be pulled from other sources is changing the way we exchange
How To Access an Oracle Database Using RDO
With Visual Basic 5.0 and higher Enterprise edition, you have the ability to connect to an Oracle database through a DSN-Less connection, execute a stored procedure using parameters, and get return values from that stored procedure. The example in this article illustrates all of this functionality.
Trigger basics in DB2 and OS/390
(Craig Mullins) TableA is a high transaction table. TableB is essentially a copy of TableA with indexes for reporting. I want to create an insert/update trigger on TableA to replicate the change to TableB. I’m worried about performance. Mainly, will TableA be locked up until the commit on TableB
Adoption Of .NET Continues, Study Says
(Alan Zeichick) It’s been two years since the introduction of .NET, and Microsoft Corp.’s new platform is well on the way toward dominating the Windows environment. Even so, there’s a tough road ahead of it—especially since Java usage also is expanding.
Integration Testing
(Dan Sawyer) Integration testing your T-SQL stored procedures saves debugging time and makes database programs more reliable and easier to reuse and maintain. In these respects, integration testing has many of the same benefits as unit testing individual procedures. The big difference between th
Informix Dynamic Server and DB2 Data Federation
This technote describes how to access and move tables in Informix Dynamic Server (IDS) by using the capabilities of DB2 Data Federation.
PRB: Unable to Display Visual Totals Using the PivotTable Component
When you use the PivotTable component and you choose the option to calculate totals based on visible items only, you may receive the following error message: The data source does not support totalling only visible items.
32-bit and 64-bit application development with DB2 UDB V8.2
(Gwyneth Evans) If you are migrating from a 32-bit DB2 instance to a 64-bit one, deploying 32-bit applications to 64-bit platforms, or simply want to ensure that you can do so easily later, then this article is for you. We outline DB2 Universal Database’s (DB2 UDB) 32-bit and 64-bit application