Setting Results Set Properties

 

You can specify properties, such as read, write, and execute authority, for a results set. You can only specify properties for a saved results set.

To specify results set properties:

1.         In the Results branch of the desired connection in the DB2 Web Query navigation tree, click the results set for which you want to set properties.

The Results menu appears.

2.         From the drop-down menu, select Properties.

The Result Properties page appears.

3.         Select a group for the results set. To add a new group, enter the name of the group and click Add.

Note:     Because each group is associated with an SQL ID, your DB2 administrator must add the desired group to your DB2 installation before you can add the group to DB2 Web Query.

4.         If you wish, edit the name of the results set.

5.         Select a category for the results set. To add a new category, enter the name of the category and click Add.

6.         If you wish, enter a description of the results set.

7.         Set permissions for the results set.

You can set Read, Write, and Execute permissions for the results set. By default, the creator of the results set has Read, Write, and Execute permissions. You can specify permissions for other users in the group specified for the results set, as well as permissions for all users:

Read

The user can view the result set.

Write

The user can modify or delete the results set.

Execute

The user can export the results set.

8.         Click Save.

DB2 Web Query saves the results set, and displays a confirmation message.