Using queries

Queries are maintained using the Query list window. The Query list window is used to list available queries for most object types. From the window, queries can be created, changed, viewed, copied, and deleted. They can also be executed there. Executing a query, sometimes called "running" a Query, causes a list window to be opened. The list window executes the selected query and displays the results. The Query list window is displayed by selecting the Open Query List function on the File menu.

Creating queries

The Query list window is used to list, maintain, and create queries.

The following steps describe how to create a query.

  1. Open the Query list window by selecting Open Query List from the File menu.
  2. Click the New button. This opens the Query editor.
  3. In the Query editor, do the following:
    1. Type a name for the query in the Query Name field.
    2. Type a description in the Description field.
    3. Select Public, Protected, or Private to indicate how you want to share the query.
    4. Click Next. This opens the Selected Column Information window.
  4. In the Selected Column Information window, select the columns that you want in the query, then click Next. The Sort Information window appears.
  5. In the Sort Information window, indicate how you want the information sorted, then click Next. The Selection Criteria window appears.
  6. In the Selection Criteria window, specify the filter conditions you want to use to limit the results of the query, then click Finish.

Now, you can run the query.

Running queries

Queries can be executed from the Query list window.

The following steps describe how to run a query.

  1. Open the Query list window by selecting Open Query List from the File menu.
  2. In the Query list window, make the following selections:
    1. From the Functional Area drop-down list, select the functional area for the query you want to run. The object types associated with the selected functional area appear in the Object Type list. The functional area choices are: Mapping, XML, EDI, Record Oriented DAta, or Message Log.
    2. Select the object type from the Object Type list. The queries defined for the selected object type appear in the Queries field.
    3. In the Queries field, select the query you want to run.
  3. Click Run.

Copyright IBM Corp. 2003, 2005