(Paul Yip) This article is a sequel to an earlier article, Advanced SQL Procedural Scripting in DB2® v7.2. This article provides you with new insights, tips, and tricks. Because this article was written in reaction to feedback from those who read the first article and as the result of additional que
Other News
Cost-Effective Website Acceleration Part 1 – Client Side Optimization
(Thomas Powell & Joe Lima) This three-part series outlines a common sense, cost-effective approach to Website acceleration according to the two simple laws of Web performance: –Send as little data as possible –Send it as infrequently as possible
How To Use JSTL SQL in JDeveloper 10g Preview
(Chris Schalk) You may be surprised to find out that JDeveloper 10g actually contains the widely popular JavaServer Pages Standard Tag Library (JSTL). This means that it is possible to use JSTL directly out of the box within JDeveloper without requiring you to download JSTL separately and install in
Review of Transact SQL Desk Reference
(Bruce Szabo) Can you have books online (BOL) on your bookshelf? Well not quite but if you put The Transact –SQL Desk Reference by Daec Lancaster on your shelf it may be pretty close. This book is a reference book for the DBA who wants to have a lot of information at his or her fingertips without ha
Storing scanned web-pages and files to SQL Server
(Muthusamy Anantha Kumar) This article provides a guide on how to explore any Internet web page and store partial or complete information to either an HTML file or Microsoft SQL server table. In addition, the method presented here will aid you to scan a webpage for a particular string and then send
Planning for Installation
Before you install DB2, you should make sure that your system meets DB2’s hardware and software requirements. If you are migrating from a previous version of DB2, there are also pre-installation migration tasks you should perform to prepare your databases.
Webcast: Breaking the DB2 Platform Barrier: An Examination of the Architectural Differences of DB2 on OS/390 vs. UNIX/Windows
The luxury of being a single platform DBA is becoming a thing of the past. Many DB2 mainframe DBAs find themselves supporting DB2 on these distributed platforms, resulting in a huge learning curve. It is essential for the DB2 DBA of the new millennium to be well versed on running DB2 on multiple pla
DataSets in Microsoft .NET – 1
(Raghav H. Nayak) ADO.NET was designed to meet the needs of this new programming model: disconnected data architecture, tight integration with XML, common data representation with the ability to combine data from multiple and varied data sources, and optimized facilities for interacting with a datab
Oracle Awaiting Feedback to Continue iSeries Support
(Cheryl Ross) After years of balking about porting its database to the AS/400, Oracle has finally made it to the platform. The company has launched a developer’s release of Oracle 9.2.04 for IBM’s PowerPC chip that runs on SuSE Linux on the iSeries or pSeries. For years, OS/400 has been overlooked b
Getting Started with DB2 Stored Procedures: Give Them a Call through the Network
(Silvio Podcameni) This redbook is the result of a residency project conducted at the IBM International Technical Support Organization (ITSO) San Jose Center. The project tested and implemented stored procedures executing in DB2 for MVS/ESA, DB2 for OS/390, DB2 for AIX, DB2 for OS/2, and DB2 for Win