FREE Registration is required
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.
(Is this item miscategorized? Does it need more tags? Let us know.)
| Format: | HTML |
| Date: | Oct 2007 |
| Pages: | 11 |
People who downloaded this item also downloaded
![]() |
Ruby Central Ruby 1.8.4 (Windows) |
![]() |
The Guru's Guide to SQL Server 2000 Memory Management Intervals - Level 300 |
White Papers, Webcasts, and Resources
- Spend 3 minutes with free EBS ROI Tool - and Save Thousands IBMSee exactly how an Oracle EBS upgrade can lower your cost of ownership, deliver greater business intelligence, and improve capabilities company-wide.
- Citizants: Bringing IT In-House Dell EqualLogicRead how one company enhanced IT flexibility and scalability by creating an in-house virtualized infrastructure that will pay for itself in 18 months.
- Cloud Computing - What is its Potential Value for Your Company? GoogleDoes cloud computing make good business sense for your company? See how the move can slash IT and support costs--and help you do more with...
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
Featured Training Courses
- Implementing and Administering Windows 7 in the Enterprise
- CCNA Boot Camp v2.0
- VMware vSphere: Install, Configure, Manage [V4]
- Certified Ethical Hacker
- Management and Leadership Skills
- Browse all Training Courses
Meet Doc
-
Here to help you with your Document Management Needs
- Check out Doc’s Blog on ZDNet
- Help your company, help the earth I want to share with you the Environmental Defense Fund Paper Calculator, which allows you to gauge your organization's environmental impact.
- Which is Greener: Paper or Digital? The Answer May Surprise You Anything we can do to reduce paper consumption is good. But what about the impact of digital waste?
-
Produced by
ZDNet and




