1. Home
  2. /
  3. Panel Help
  4. /
  5. Cross Application
  6. /
  7. Work with query RUN...

Work with query RUN controls (ASTD43001)

This panel displays the records set up for your user profile. You can maintain and display the records set up for your user profile and the general user *ALL.

Through this routine you can create a user friendly interface to the iSeries Query Manager. It is possible to create a query run control where the user can enter the parameters, even through windows selection, that will be sent to the query.

The query run control routine works only in conjunction with existing queries created through iSeries Query Manager. This means that you first have to create the query and define the file and fields used to select records. In this routine you create an interface to the query so the user easily can enter a value pertaining to the field.

When entering this panel only the records with your user ID are displayed. To see and maintain all records remove your user ID from the first input field, User ID, at the bottom of the panel. Note: This is only possible if you have System administrator authority.

Options

Rename Select this option to rename a query.
Menu item Select this option to create a menu item for a query.
Run Select this option to run a query. Note: If you want to run a record with a different user ID than your own or *ALL this is the only place you can do so.

Function keys

Work with menus Access the Work with menus panel.

Selection fields

User ID
Displays the User profile for the record.
Request
Displays the name of the query run control.
Description
Displays the description of the query run control.

Add query RUN control (ASTD43004)

On this panel you define the keys for the new record you are adding.

User ID
Enter the user ID of the person who will be allowed to maintain and use this query run control. At run time a user can only access those records that contain their identical user id, or those records that are completed with user id *ALL. Note: When a user runs a query control with user ID *ALL a new record will be created with the user’s own user ID.
Request
Enter the name of query run control.
Description
Enter the description of the new record.