Selecting Fields 

Use

Use this screen to select the fields upon which to base your query. You may select fields from different tables in your data service. There is no limit to the number of fields you may select.

Selecting fields typically determines which fields will be displayed in the result.

 

Procedure

...

       1.      In the Available Tables and Fields section, locate and select a field.

This section lists the data service you chose on the Select a System screen as the root node of a tree, followed by any catalogs contained in that service.

                            a.      Expand a catalog to see a list of schema in that catalog.

                            b.      Expand a schema to see a list of tables in that schema.

                            c.      Expand the table that contains the field you want, and click to select the field.

       2.      Click à to transfer the field to the Selected Fields list.

       3.      Add additional fields from the same or from different tables as desired.

       4.      To add all fields in a table to the Selected Fields list, select the table and click à.

       5.      To remove a field from the Selected Fields list, select the field and click ß.

       6.      To remove all fields from the Selected Fields list, click Clear.

       7.      Click Next.

 

Result

You proceed to the Configure Joins screen.

To configure joins, you must select fields from two or more different tables. If you have selected fields from only one table on this screen, the wizard bypasses the Configure Joins screen and you proceed to the Configure Filters screen.