Browse Prior Art Database

Binding With a List of Files

IP.com Disclosure Number: IPCOM000034716D
Original Publication Date: 1989-Apr-01
Included in the Prior Art Database: 2005-Jan-27
Document File: 1 page(s) / 11K

Publishing Venue

IBM

Related People

Buquoi, GH: AUTHOR [+2]

Abstract

A method is described which allows binding a list of access plans to a database. Without this method, the binder will accept only one access plan at a time to be bound to a database. The binder will issue a 'Start Using Database' command, bind the access plan to the database, and then issue a 'Stop Using Database' command. If there are 12 access plans to be bound, then this sequence is performed 12 times, resulting in slow performance. In accordance with the new method, the binder accepts a list of access plans to be bound. The caller of the binder precedes the filename containing the list with an '@'. This way the binder recognizes the input filename to be a list of access plans, instead of the name of a particular access plan.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 100% of the total text.

Page 1 of 1

Binding With a List of Files

A method is described which allows binding a list of access plans to a database. Without this method, the binder will accept only one access plan at a time to be bound to a database. The binder will issue a 'Start Using Database' command, bind the access plan to the database, and then issue a 'Stop Using Database' command. If there are 12 access plans to be bound, then this sequence is performed 12 times, resulting in slow performance. In accordance with the new method, the binder accepts a list of access plans to be bound. The caller of the binder precedes the filename containing the list with an '@'. This way the binder recognizes the input filename to be a list of access plans, instead of the name of a particular access plan. The binder then issues one 'Start Using Database' command, binds each access plan in the list, and then issues one 'Stop Using Database' command. Advantages of this method include:

1. Greatly increased performance when binding several access

plans.

2. Enhanced usability: An ASCII file can be created that contains

the list of access plans. This file can be modified as

needed.

1