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

Select Connection Specs 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 Query name drop-down list, specify the query specification name you want to use. The drop-down list shows the query specifications that were created or imported from the access set you specified in the Access set field.

If the query specification you want to use does not exist, you must either create it or import it.

If you are creating or importing a query specification, you do not need to specify a query specification name.

The query specification must specify an SQL statement that references the tables, views, and columns contained in the database you specified in the Database name field. The SQL statement will be validated against the database when you select Apply or when you select Edit from the Query pull-down menu.

If you are exporting or deleting a query specification, you can specify any query specification name.

The Description field shows the description of the SQL statement you have specified in the Query name field.

The description cannot be edited in this field.

In the Static Package field, specify the package name.

Select Package Specs to create a new static package.

Select Use high level qualifiers to create new queries with qualified table names. You cannot change existing queries.

The SQL Statement list shows the SQL statements for the query specification you have selected. You cannot directly edit the items in this list.

You can use the following push buttons to work with the SQL Statements:

Create a new SQL statement to be added in the SQL Statement list.

Edit the SQL statement you selected in the SQL Statement list.

Import the SQL query from a file using the Select File window.

Export the SQL query statement to a file using the Select Output Filewindow.

Change the data types of host variables used in the query statement.