(Ron Hardman and Michael McLaughlin) Extending stored programs with Java is a very popular solution. PL/SQL is essential to the process of stored Java class libraries. PL/SQL wraps access to the Java class libraries, which means PL/SQL becomes the gate through which data moves to and from Java store
Author: SSWUG Research
MySQL 5.1’s New XML Functions
(Alexander Barkov and Peter Gulutzan) MySQL version 5.1.5 has functions for searching and changing XML documents. This article has examples.
Choose a method for passing arrays to the Oracle Provider for OLEDB
(Scott Stephens) The Oracle Provider for OLEDB has some nice methods for retrieving an array from a PL/SQL procedure call and making it appear to be a Recordset object. It’s a bit trickier to go in the other direction. I’ve seen a lot of requests for help from developers looking for a way to pass an
Encapsulating ODBC in ASP .NET
(Jason G. Williscroft) In an earlier article (Implementing ODBC in ASP .NET), we described some issues with Microsoft’s ODBC server controls, and how to work through them. In a nutshell, although Microsoft provided the necessary data objects, they left out the logic required to wire these objects in
30 Reasons to Love the DB2 Add-in for VS.NET 2005
(Justin Whitney) It’s all about options. That seems to be IBM’s motto as they continue to expand DB2 functionality across all development platforms. What might once have been a strange bedfellow is fast becoming just another tool for DB2 programmers as IBM continues to put the “universal” in “Univer
Data encryption in UniData and UniVerse
(Bill Winter) Recent government regulations and market demand have increased requirements for protecting data resources. Data encryption is an important tool to help application developers meet the need for greater security. This article describes the encryption options available in IBM UniData and
WebSphere for z/OS to CICS and IMS Connectivity Performance
(Tamas Vilaghy, Rich Conway, Kim Patterson, Rajesh P Ramachandran, Robert W St John, Brent Watson and Frances Williams) The objective of this IBM Redpaper is to help you understand the performance implications of the different connectivity options from WebSphere Application Server for IBM z/OS to CI
Bind Flash Movie to an MS SQL Server Database and a Webservice
(fastpro) I was looking for a simple solution to bind a MS SQL Server database to an older Flash movie (Flash 5 without DataGrid). I found a few examples but nothing really satisfying. So I decided to combine two scripts to get a new useful application handling Flash movies and databinding. This
Build Providers for Windows Forms
(Dino Esposito) In ASP.NET and Windows Forms projects, some file types are treated differently than others. For example, ASPX and ASCX files are dynamically parsed and compiled to an assembly on the fly. The contents of an XML Schema Definition (XSD) file are used to create a new, strongly typed Dat
How To Receive Data from a Single Table, continued
(Bryan Sylverson) Figure 3-7 introduces you to functions and illustrates how you use them in column specifications. A function performs an operation and returns a value. For now, don’t worry about the details of how the functions shown here work. You’ll learn more about all of these functions in cha