Skip to main content

IBM DB2 for i V7.1: HLL Programs Can Now Easily Process Result Sets From Stored Procedures

Web Doc

Note: This is publication is now archived. For reference only.

thumbnail 

Published on 30 November 2010

  1. View in HTML

Share this page:   

IBM Form #: TIPS0801


Authors: Sandra Cabral and Hernando Bedoya

    menu icon

    Abstract

    Stored Procedures are used across different platforms, operating systems, and diversified computing environments. Stored Procedures are great programming resources that can be used to distribute the logic of your application and, in a client server environment, they can improve performance tremendously by reducing the information traffic across a network.

    In IBM i V5.4 and V6.1, traditional programming languages, such as RPG and COBOL, did not have the ability to retrieve result sets returned by a Stored Procedure unless they used the SQL Call Level Interface for the Stored Procedure call. With the release of IBM i V7.1 in April 2010, several enhancements were added to IBM. DB2 i for V7.1. One of these enhancements is that the SQL for DB2 for i V7.1 now supports two new SQL statements: ASSOCIATE LOCATOR and ALLOCATE CURSOR These two SQL statements allow RPG and COBOL programs to easily consume result sets coming from Stored Procedures.

    Contents

     

    Special Notices

    The material included in this document is in DRAFT form and is provided 'as is' without warranty of any kind. IBM is not responsible for the accuracy or completeness of the material, and may update the document at any time. The final, published document may not include any, or all, of the material included herein. Client assumes all risks associated with Client's use of this document.