stored procedures
RSS stored proceduresStored Procedures, UDFs and Triggers - Common Logic or Common Problem?
DB2 Stored Procedures, user-defined functions, and triggers are becoming more prevalent on the mainframe, and can be part of a valuable implementation strategy. This webcast provides you with an understanding of UDFs and triggers and how to... [24 May 2005]
Stored Procedures, UDFs and Triggers - Common Logic or Common Problem?
White Paper DB2 Stored Procedures, user-defined functions, and triggers are becoming more prevalent on the mainframe, and can be part of a valuable implementation strategy. This webcast provides you with an understanding of UDFs and triggers and how to... [24 May 2005]
DB2 V8: Stored Procedures and WLM - Get Ready Now
White Paper As the demand to meet user and customer information requests continues to grow for today's businesses, the use of DB2 Stored Procedures is on the rise. Listen to this informative discussion on DB2 V8 and Stored Procedures, featuring internationally... [13 May 2004]
Stored Procedures and UDFs with Borland JDataStore
White Paper The JDataStore database supports the use of stored procedures to encapsulate business logic in the schema of a database and UDF (User Defined Function) to allow developers to extend the built-in SQL support. [24 Feb 2004]
Use XML in DB2 SQL Stored Procedures: Access XML Data With Procedural Logic in DB2 9 for Linux, UNIX, and Windows
White Paper This paper discusses the use of XML in SQL stored procedures. Now, one can build indexes over XML data, and perform shredding using a call to a stored procedure. IBM DB2 9 for Linux, UNIX, and Windows adds major new XML functionality over and above... [09 Apr 2008]
Using .NET Stored Procedures in Oracle
White Paper For a .NET developer, one of the most exciting features of Oracle Database 10g Release 2 for Windows is the ability to implement stored procedures using the .NET language of his or her own choice, via Oracle Database Extensions for NET. [11 Oct 2006]
Overcoming High-Latency Database Access With Java Stored Procedures
White Paper Java Stored Procedures: a way to put slow Java code in the otherwise fast database or a quick solution for certain database performance problems? The author explains a situation in which the adoption of Java Stored Procedures quickly and... [31 Oct 2006]
Setup of the DB2 Application Development Environment for Stored Procedures
The objective of this paper is to provide the steps to install, configure and test the setup of the DB2 application development environment for stored procedures. At the conclusion of this document, you will be able to execute a Java program on a... [28 Sep 2004]
An Evaluation of Stored Procedures for the .NET Developer
White Paper The aim of this paper is to give you the key pros and cons of using stored procedures to encapsulate the Transact-SQL (T-SQL) needed by your applications, so you can make an informed decision about using them in your environment. [09 Nov 2004]
Auto-Generating Wrapper Classes for Stored Procedures, Part 2: The Internals of the AutoSproc Tool
White Paper The AutoSproc tool uses reflection to auto-generate wrapper classes for calling stored procedures. These days, folks who are building scalable distributed applications tend to partition application code into discrete tiers conforming to the classic... [09 Nov 2004]
Auto-Generating Wrapper Classes for Stored Procedures, Part 1: Using the AutoSproc Tool
White Paper The AutoSproc tool uses reflection to auto-generate wrapper classes for calling stored procedures. These days, folks who are building scalable distributed applications tend to partition application code into discrete tiers conforming to the classic... [09 Nov 2004]
Setup of the DB2 Application Development Environment for Stored Procedures
White Paper The objective of this paper is to provide the steps to install, configure and test the setup of the DB2 application development environment for stored procedures. At the conclusion of this document, you will be able to execute a Java program on a... [28 Sep 2004]
Accessing Oracle 9i Stored Procedures Using ADO.NET
White Paper The Oracle .NET data provider makes it easy to execute stored procedures and access the return values, whether they are one or more scalar values or result sets. This paper is a discussion of how to access Oracle stored procedures (named SQL... [05 Jan 2005]
MySQL 5.0 Stored Procedures: MySQL 5.0 New Features Series - Part 1
White Paper Correctly speaking, MySQL supports "Routines" and there are two kinds of routines: stored procedures which a person calls, or functions whose return values are used in other SQL statements the same way that is used pre-installed MySQL functions... [26 Aug 2006]
Towards Object Orientation Using Stored Procedures and Functions
White Paper Moving our SQL code from Oracle Forms to database packages has proved very successful. We have realised significant performance gains both by reducing network traffic and by executing database transactions wholly on the database server. [24 Feb 2004]
