Programming Languages White Papers
Exchange Data Using Arrays in SQL PL: New Capabilities for Exchanging Data Between Applications and Stored Procedures
Overview IBM DB2 9.5 for Linux, UNIX and Windows introduces support for array data types in SQL Procedural Language (SQL PL). In addition to being useful as a data structure to develop algorithms, arrays are particularly useful in SQL PL as a vehicle for exchanging collections of data between applications and stored procedures and between stored procedures and relational statements. This paper gives the user an overview of arrays in SQL PL and includes examples that illustrate the different operations on arrays, the different ways of creating array values, and the use of arrays on the client side. One will also see a brief comparison of DB2's arrays with the VARRAY data type supported in Oracle.
| Publisher | IBM | File Format | HTML |
|---|---|---|---|
| Date Published | October 2007 | Downloads | 4 |
| Format | White Papers | ||
| Topics | |||
-
Did you find this white paper useful? 12 out of 15 users found this white paper useful
White Paper RSSCitizants: Bringing IT In-House
DownloadCitizant enhances IT flexibility and scalability by creating a virtualized Dell infrastructure that will pay for itself in 18 months.
Designing High Availability for Internet Information Services
End downtime forever! - Organizations today are relying more and more on Web services for the implementation of mission-critical applications. With the advent of Service-Oriented Architectures (SOAs),which make extensive use...
Five JavaScript Frameworks: A Point-by-Point Comparison
There are a multitude of JavaScript frameworks available today for programming rich client-side interactions in web applications. With many such different options, it is important to choose a framework that...
Increase Reliability with IBM WebSphere File Transfer Edition (FTE)
"Does your organization still use FTP software? Did you know these links require 3 to 4 times more time and effort to build and maintain versus SOA-based Application Integration projects?...
Energy Monitoring Firm Saves Money, Scales Business With Hosted Computing Platform
Advanced Telemetry develops systems to help businesses monitor and control energy usage, onsite or via the Internet. The company employees 22 people. Advanced Telemetry needed a cost-effective way to scale...
