From the Connection alias drop-down list, specify the connection alias. You can use the Connection Specs push button to specify database connection information.

From the Access set combo box, specify the access set that holds the query specification that you want to use.

Access sets can contain query, stored procedure, and connection specifications that developers can share.

You must define an access set. If you have not already defined an access set, VA Smalltalk prompts you to create one.

From the Stored Procedure Spec Name drop-down list, specify an existing stored procedure specification.

A stored procedure specification defines the intputs and outputs that a Stored Procedurepart will send to or receive from the stored procedure file.

You can use the following push buttons to work with the items that appear in the Stored Procedure specification list:

Select New to define a new stored procedure specification using the Stored Procedure Specifications - Settings window. A different settings view window is displayed depending on the selected connection alias. The stored procedure specification is placed in the access set specified in the Access set field.

Select Edit to change an existing stored procedure specification using the Stored Procedure Specifications - Settings window. A different settings view window is displayed depending on the selected connection alias.

Select Delete to delete the stored procedure specification from the access set. You can select a stored procedure specification from the Stored Procedure Spec Name combo box.

The Stored Procedure Description field shows the description of the stored procedure specified in Stored Procedure Spec Name. The information in this field cannot be modified.

Select Connection Specs to specify database connection information.

Select New to create a new stored procedure specification.

Select Edit to edit the selected stored procedure specification.

Select Delete to delete the selected stored procedure specification.