Enabling package-based continuous block fetch

Enabling package-based continuous block fetch for an application involves ensuring that the application contains only read-only cursors, and binding the application package with the appropriate bind options.

Before you begin

The requesting application must meet the following requirements:

  • The application must be a Db2 for z/OS® application.
  • The result sets that the application returns cannot contain LOB columns or XML columns.
  • Cursors that are used for package-based continuous block fetch cannot be scrollable cursors or rowset-positioned cursors.

Procedure

  1. Write the application to use only read-only cursors. One way to do that is to declare the cursors with the FOR FETCH ONLY or FOR READ ONLY clause. See the information on DECLARE CURSOR for requirements for read-only cursors.
  2. Start of changeBind the application package on the Db2 for z/OS requester with the DBPROTOCOL(DRDACBF) option.

    For a stored procedure, bind the package with the DBPROTOCL(DRDACBF) option at the location where the stored procedure resides.

    End of change