(Tony Culshaw) Apache Cocoon has typically been categorized as a web publishing framework, but since the release of version 2.1 is has started to look more like an XML application server. A project with a travel company to build a web-based travel agency desktop which integrates several common ba
Author: SSWUG Research
Formatting the date with SQL
(Ravinder Bahadur) Here is a simple way to provide a format for date fields in DB2. More complicated formating will need to use the to_char() function available on IBM’s web site.
Scripted Configuration for SQL Server 2000
(Rob Hawthorne) SQL Server is a great RDMS application, but its installation and configuration options leave the seasoned SQL user crying out for more. Upon install, SQL Server 2000’s options are limited in a number of ways. For example, it provides no features for separating the transaction logs fr
Build cross-browser XML paging code
(Edmond Woychowsky) My manager doesn’t like scrolling through page after page of tabular information when using a browser-based application. And the delay he experiences while waiting for the next page to load provides him the opportunity to exercise his vast knowledge of the more interesting parts
Oracle’s waiting game
(Alorie Gilbert and Charles Cooper) Oracle believes that it can still carry the day, but its battle to acquire PeopleSoft is getting tougher as time goes on. With regulators taking longer than expected to make a decision, government trustbusters are reportedly building a case to challenge the de
Oracle9iR2 Segment Level Statistics
(James Koopmann) Detection of which tables or indexes are being accessed the most will allow you to fine tune memory structures and access methodologies. Let’s take a look at Oracle’s segment level statistics and determine which objects are being accessed the most by our applications. If you have
Configuring Microsoft ODBC Driver for DB2
Microsoft ODBC Driver for DB2 (Msdb2ole.dll) enables access over SNA LU 6.2 and TCP/IP networks to remote DB2 databases. This driver is implemented as an IBM Distributed Relational Database Architecture (DRDA) application requester that can connect to DRDA-compliant DB2 systems like MVS, OS/400, and
Once Upon a Time in DB2
(Bonnie Baker) Think you understand cursors and fetching in DB2? What you think you know may be nothing more than a fairy tale. Lately I’ve gotten many questions about inserts, and they all go something like this: “My program opens a CURSOR on a table and then does inserts into the same table. W
Pass Recordsets in N-Tier Applications
(Richard Campbell) There are three popular techniques for passing multiple records from the middle-tier to the client-tier. The most common approach is the one you mention – variant arrays. Typically the array has two dimensions: The first is the field name, and the second is the value. Because the
Oracle SQL tricks
This page is a great collection of tips and tricks for Oracle – from online links to the user manuals to query exeucution details to how to enable constraints with locking tables and much more. This is one article not to miss!