Use the Query Spec tab to specify the database and SQL you want to use.
Page 1 Settings
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, VisualAge prompts you to create one.
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 cannot be edited in this field.
Page 2 Settings
You can use the following push buttons to work with the SQL Statements: