(Tim Albrecht) With a more complete implementation of stored procedures in DB2 Versions 5 and 6, many new distributed access opportunities have been given to the DB2 developer. Many shops, ours included, severely limited or completely denied Dynamic SQL access to operational Online Transaction p
Other News
Oracle Tip: Serialize data with ANYDATA columns
(Scott Stephens) Oracle version 9 introduced interesting new data types, which allow developers to declare a variable that can contain any type of data. The data types are ANYDATA for a single item, ANYDATASET for a TABLE or VARRAY of data, and ANYTYPE, which describes the type of data stored in ANY
Tip: Create an XForms form that submits a second instance
(Nicholas Chase) Because they can easily send and receive XML, XForms forms make great Web services clients, but using them in this way limits your control over the structure of your instance. This tip explains how to manage your data within one instance while submitting a second.
DB2 Content Manager Web applications
(Chitrang Shah) Interested in learning more about performance tuning techniques and debugging methodologies for J2EE applications? This article focuses on the high-level architecture of a J2EE application developed on IBM DB2 Content Manager V8.x, while introducing the concept of queuing a network,
Convert a Universal Time Coordinated timestamp in DB2 Universal Database
(John Munteanu) This article presents the design of a Java implementation for a user-defined function for IBM DB2 Universal Database (UDB) that takes a UTC timestamp and a locale name as input parameters, and returns the timestamp equivalent in the new locale. This is an especially useful function i
Use an Oracle API to Extract and Store Database Objects’ DDL
(Boris Milrud) There are times when database data manipulation requires extracting DDL (Data Definition Language) commands for various objects, such as database tables, indexes, constraints, triggers, etc. Recently I was charged with the task of writing a set of database packages to perform a hi
Oracle’s Wrap Utility
(Steve Callan) One thing that Oracle and UPS have in common is that they both deal with wrapped packages. Why bother with wrapping packages? One obvious reason is to hide the contents from prying eyes. You can wrap a real package with nondescript wrapping paper or use transparent cellophane. Thi
Introducing o:XML
(Martin Klang) Most of us tend to think of XML as a useful, general-purpose data format. New vocabularies are springing up all the time, as do tools for XML processing. Still we haven’t yet realized the potential of XML as a facilitator in the software development process itself.
Where to store Images?
(Vinod Kumar) The fundamental Pros of storing the images in SQL Server are pretty simple: You gain all the “ACID” properties of a database system. This is something we donot intent to capitalize fundamentally. But the application demands have made us think so and we have unknowingly have used the da
How To Add SQL Server 2000 Stored Procedures to Visual SourceSafe by Using Visual Studio .NET
This step-by-step article discusses how to add Microsoft SQL Server 2000 Stored Procedures to Visual SourceSafe (VSS) by using the Source Control feature in Microsoft Visual Studio .NET. There are two types of configuration for adding Stored Procedures by using Source Control: –The VSS database i