IBM SC41-5210-04 manual Authorization list name, Exclude

For all options, if the file does not exist in the specified library, Query tries to create that file.

Authority in Query for iSeries reports: Type the value for the kind of object authority that you want to give to other users for your database file. (This authority value is used only if your query creates a new file.) The values that you can specify are:

*LIBCRTAUT

Library create authority assigns the authority from the create authority (CRTAUT) value in the library the object is being created into. The authority could be *ALL, *CHANGE, *EXCLUDE, *USE, or an authorization list name. Your ability to use the file depends on the authority assigned.

*CHANGE

Change authority allows other users to perform all operations on the object except those limited to the owner or controlled by object existence authority and object management authority. A user can change or use the file in any way except to: replace or add new members, delete the file, or transfer it to a new owner.

*ALL

All authority allows other users to perform all operations on the object except those limited to the owner or controlled by authorization list management rights. A user can do anything with the file (including deleting it), except for transferring it to a new owner.

*EXCLUDE

Exclude authority prevents other users from doing anything with the file. Unless given specific types of authority, no user except its owner can use the file.

*USE

Use authority allows other users to read records in the file.

authorization list name

If you specify the name of an authorization list, its authority is used to control the ability that users have to use the file. For more information, see the iSeries Security Reference book.

The following table shows, for each predefined type of authority, what can be done with the file:

Type of	’	Create	Replace	Add New	Add to	Replace
Authority ’		New File	the File	Member	Member	Member
--------- ’		--------	--------	-------	------	-------
*ALL	’	Yes	Yes	Yes	Yes	Yes
*CHANGE	’	Yes	No	No	Yes	No
*USE	’	Yes	No	No	No	No
*EXCLUDE	’	Yes	No	No	No	No

Note: If the authority you specify is *LIBCRTAUT, the value assigned when the object was created is used.

Text in Query for iSeries reports: You can type a comment (text) of up to and including 50 characters in this prompt to describe a file that Query for iSeries creates or replaces when this query is run. The comment reminds you what the file is for when it is displayed later in a list of files. The comment is displayed, for example, on the Select File display whenever the Text column is shown.

Print definition in Query for iSeries reports: Type a Y or N to indicate if you want a copy of your query definition to be printed whenever the query output is stored in the database file. N (No) is the default.

Y=Yes

A copy of your query definition (and the output database file definition) is to be printed whenever the query output is stored in the file.

N=No

A copy of the query definition is not to be printed when the query is run.

Chapter 13. Selecting output type and output form in Query for iSeries reports 159