The COPYFROM= keyword is only valid on an ADD statement. All other keywords are valid on either an ADD or an UPDATE statement.
(Optional) Specifies that the characteristics of the new user ID being added are to be copied from an existing user ID. Follow COPYFROM= with an existing user ID. This option can only be used with the ADD statement. This is a very useful option for adding a large number of users.
User Authorization Options
For both the ADD and UPDATE statement the following options are valid:
(Optional) Specify the CA Datacom/DB accounting code to be used with CA Datacom/DB accounting for CA Dataquery. See your Database Administrator for this information. (No default)
(Optional)
Y (yes) specifies that this user can only perform associate user tasks.
N (no), the default, does not limit this user to associate user tasks; thus enabling this user to create and edit queries, view database information, use commands, and so on.
(Optional)
Y (yes) permits user to see a list of active CA Dataquery users and perform such functions as broadcasting messages, forcing signoff, and cancel FIND in progress.
N (no), the default, does not allow the user to perform active user functions.
(Optional) Authorizes the user read-only access to all data available to CA Dataquery.
Y (yes), allows the user read-only access to data. CA Dataquery does not perform any data security check.
N (no), the default, CA Dataquery qualifies this user's access to data by the data authorizations specified in security control.
(Optional) Specify if this user is permitted to build a CA Dataquery batch export file whereby data accessed from the database is exported and saved for later use. It allows the user to use the EXPORT command while using batch CA Dataquery.
Y (yes), the default, allows the user to export data.
N (no) prohibits the user from exporting data.
(Optional) Enter a valid 1- to 15-character alphanumeric group level 1 name for CA Dataquery security control. (No default.) See the discussion in Assigning Group Levels for more information.
(Optional) Enter a valid 1- to 15-character alphanumeric group level 2 name as specified in CA Dataquery security control. If you enter a group level 2 name, you must also enter a group level 1 name. (No default.) See the discussion in Assigning Group Levels for more information.
(Optional) Specify a valid 1- to 15-character alphanumeric group level 3 name as specified in CA Dataquery security control. If you enter a group level 3 name, you must also enter a group level 1 and a group level 2 name. (No default.) See the discussion in Assigning Group Levels for more information.
(Optional) Enter a 1- to 9-character alphanumeric password. This field is used to assign an individual user password. (No default.)
(Required) Specify SQL if SQL, or DQL if DQL Language, is authorized for this user. DQL is the default and limits the user to DQL Language only. Specifying QRYLANG=SQL and SQLDQL=Y (see page ADD and UPDATE Statement Optional Keywords) authorizes the user to both query languages. (Default is DQL.)
This parameter is no longer supported but is retained for compatibility
(Optional)
Y (yes) to allow this user to use SQL Data definition statements.
N (no), the default, restricts the user from using CREATE, COMMENT ON, GRANT, REVOKE and DROP statements.
(Optional)
Y (yes) to allow this user to use SQL Data maintenance statements.
N (no), the default, restricts the user from using INSERT, UPDATE, and DELETE.
(Optional)
Y (yes) to allow this user to change query languages on his profile.
N (no), the default, restricts the user from changing from DQL to SQL on his profile. Specifying QRYLANG=SQL (see page ADD and UPDATE Statement Optional Keywords) and SQLDQL=Y authorizes the user to both query languages. (Default is DQL.)
(Required) Indicate whether this user is allowed to submit batch queries.
Y (yes), the default, permits the submission of batch queries.
N (no) does not.
Administrative Functions
The following options enable (or deny) the user access to any or all administrative functions.
(Required)
Y (yes) if this user is to have the administrative ability to create, view, delete, or edit a condition.
N (no), the default, denies this user access to the CONDITIONS option on the Administrative Menu.
(Required)
Y (yes) if this user is to have the administrative ability to request a CA Dataquery Request Table and/or a storage dump in the form of a transaction dump or a module dump.
N (no), the default, denies the user access to the DIAGNOSTICS option on the Administrative Menu.
(Required)
Y (yes) if this user is to have the administrative ability to create, delete, or modify a set.
N (no), the default, denies the user access to the SETS option on the Administrative Menu.
(Required)
Y (yes) if this user is to have the administrative ability to create, delete, view, or edit a CA Dataquery JCL member.
N (no), the default, denies this user access to the JCL MAINTENANCE option on the Administrative Menu.
(Required)
Y (yes) if the user is to have the administrative ability to translate, edit, delete, or display CA Dataquery panels, program literals, and vocabulary terms to another language.
N (no), the default, denies access to the LANGUAGE option on the Administrative Menu.
(Optional) A value from 1 through 99999 used to specify a threshold value for estimated I/O for DQL find processing. When this value is exceeded, the user will be presented a panel and asked if he wants to continue. The system default from the CA Dataquery System Option Table is used if this value is zero.
(Required)
Y (yes) if this user is allowed to create and maintain personal tables. Also authorizes a user to create personal tables for his own individual use. Specify the area of the database where personal tables are to be stored in Override System Options.
N (no), the default, prohibits the user from having personal tables.
(Required)
Y (yes) if this user is to have the administrative ability to start, stop, restart, and cancel spooled print jobs.
N (no), the default, denies the user access to the spooled print job functions on the Administrative Menu.
(Required)
Y (yes) if this user is to have the administrative ability to create, maintain, execute, and/or submit queries listed on the Admin Directory of Queries and Terms panel.
N (no), the default, denies this user access to the LIBRARY option on the Administrative Menu.
(Required)
Y (yes) if this user is to have the administrative ability to create, delete, view, or edit a restriction.
N (no), the default, denies the user access to the RESTRICTIONS option on the Administrative Menu.
(Required)
Y (yes) if the user is to have the administrative ability to relate users to a table, tables to a user, or profile codes to a user. This field authorizes this user record and field security control functions.
N (no), the default, denies the user access to the Security Control option on the Administrative Menu.
(Required)
Y (yes) if this user is to have the administrative function of adding, deleting, and maintaining users, as well as access to active users, passwords, and profile.
N (no), the default, prohibits this user from viewing and/or accessing the USERS and PROFILE options on the Administrative Menu. :nt text='Caution'. Any user that has authorization for this function has the ability to authorize themselves or others to perform any of the administrative functions. Care should be taken when deciding who and how many users may have this authority as this is a key to security. If a user is authorized for User Maintenance, that user cannot change his own authorization to N (no).
Override System Defaults
The following options enable the user to override system default options.
(Required if the query language authorized for this user is SQL, or if personal database is authorized for this user, or if SQL AND DQL ALLOWED=YES.) Enter a 1- to 18-character authorization ID. This establishes the user's default authorization ID for personal database and for all SQL Mode. (No default)
(Optional) Enter a value from 1 through 99999 to specify the total number of physical blocks on the DQF (found table) that this user can own at one time during a query execution. Ensure that the value specified for this user still leaves adequate space for all other users. (The system default is used if this value is zeros.)
(Optional) Input a numeric value from 1 through 99999 to specify a search limit for this user that overrides the system default. This feature limits the amount of time CA Dataquery is to process before pausing to allow the user to end the query. MXREQ keeps one query from monopolizing the system. (The system default is used if this value is zeros.)
(Optional) Indicate a value from 1 through 99999 to specify the number of times CA Dataquery is to relinquish control to other tasks during a query execution before pausing to allow a user to end processing. (The system default is used if this value is zeros.)
(Optional) Specify the 1- to 4-character network printer ID to be used by this user.
(Optional) Specify the 1- to 32-character name for the CA Datacom/DB area to be used for this user's personal tables. Check with the CA Datacom/DB Administrator for this information. The default is in the System Option Table or if this is blank, the default is the CA Datacom/DB SQL DEFAULT area specified in MUF startup options (see the CA Datacom/DB Database and System Administration Guide for more information on MUF startup options).
(Optional) Specify the 2-character primary language ID for this user's primary language. AE (American English), the default, is automatically distributed with CA Dataquery. Your site can also have German, French, or any other language of your company's choosing. (Default is AE.)
(Optional) Specify the 2-character secondary language ID for this user's secondary language. AE (American English), the default, is automatically distributed with CA Dataquery. Your site can also have German, French, or any other language of your company's choosing. (Default is AE.)
(Optional) Input a value from 1 through 16 to specify, in 4096-byte pages, the maximum amount of contiguous storage area for in-core sorting which CA Dataquery requests of CICS at one time. If this amount is not available when needed, CA Dataquery tries to allocate a number of smaller areas for the sort.
(Optional) Enter a value from 1 to 1024 to specify, in 4096-byte pages, the maximum amount of storage CA Dataquery is to allocate to process a single sort request without using the database index for sorting. The value specified here overrides the system default for this user. (The system default is used if this value is zeros.)
Profile Options
The following options enable the user to override system default options.
(Optional)
Y (yes) to include CA Datacom Datadictionary aliases in the Directory of Tables, Keys and Fields Display, Fields Display, and Keys Display panels.
N (no), the default, excludes CA Datacom Datadictionary aliases from these display panels. (See the CA Dataquery end user documentation for details on these panels.)
(Optional) Enter 1 character. Specifies the character that the user wishes to use as a decimal point. Do not list as the last option on a statement. If necessary, add the QUERYLANG= option for the mode in use after DPCHAR=. The default is the value of the DECPT= parameter in the System Option Table.
(Optional) Determines if duplicate values for columns specified as control break columns are suppressed in the generated report.
Y (yes), the default, the value contained in a control break column is displayed only once. Each time the value in the control break column changes, the new value is displayed. If the output continues to the top of a new page, the current value in the control break column is displayed at the top of the new page.
N (no), value prints on every detail line.
(Optional)
Y (yes) to suppress the display of the Online Execute Query panel. Users would want to suppress the display of the Online Execute Query panel if their queries always read and collect data and display it on their terminals. Suppressing the display saves a step during the execution process by accepting the execution defaults.
N (no), the default, causes the Online Execute Query panel to be displayed.
(Optional) Determines the manner in which a compound field is represented when displayed on a report.
Y (yes), fields comprising the compound field are shown as individual fields.
N (no), the default, a compound field is shown as though it is a single alphanumeric field, even though one or more of the simple fields contained in the compound field is a numeric field which cannot be printed. (Default is N)
(Optional)
Y (yes) to suppress the PF key descriptions on the print panel that displays the report.
N (no), the default, causes the PF keys descriptions to be displayed.
Printer Options
The valid printer options are:
(Optional)
Y (yes), the default, if this user's print jobs are to be preceded with a banner page containing user name, date, and time, to aid in distributing the reports.
N (no) suppresses the printing of the banner page.
(Optional) Specify the width of the hardcopy on the network printer by stating the number of columns to be printed. Indicate a 3-character numeric value. Valid entries are 00 or 80 to 255. (Default is 0.)
(Optional) Use this field when printing a report composed of two adjacent (side-by-side) pages. If the first page (left-hand page) is labeled A and the second page (right-hand page) is labeled B and the report is three pages in length.
Y (yes), the default, would result in these pages being printed in the order of 1A, 1B, 2A, 2B, 3A, 3B.
N (no) results in a printing order of 1A, 2A, 3A, 1B, 2B, 3B.
(Optional)
Y (yes), the default, if the statistics of the query that produced the report are to be printed when the report is printed on the network printer.
N (no) does not print the query statistics.
(Optional)
Y (yes), the default, if the text of the query that produced the report is to be printed when the report is printed on an online network printer.
N (no) does not print the query text.
(Optional) Specify the number of rows to be printed on one page of hardcopy on the network printer. Indicate a 3-character numeric value. Valid entries are 00 or 12 to 255. 1 through 11 are not valid entries. (Default is 0.)
(Optional)
Y (yes) if the report extends beyond 80 columns and you do not want the report lines to wrap.
N (No), the default, if you want the print lines to use wrapping.
|
Copyright © 2014 CA.
All rights reserved.
|
|