Profile Items
A discussion of each profile item follows.
User Profile (DQKL0)
=> Overtype the values to be modified and press PF4 to complete the update --------------------------------------------------------------------------DQKL0 DATAQUERY: USER PROFILE FOR => ________________________________ ------------------------------------------------------------------------------- PROFILE ITEM EXPLANATION ------------------------------------------------------------------------------- DATADICTIONARY DATABASE ID => _____ Five digit DB ID number for DD access LIST AND DISPLAY ALIASES => ___ YES show aliases, NO suppress aliases GROUP DISPLAY => ___ YES break out simple columns, NO do not SUPPRESS DUPLICATE COLUMNS => ___ YES turn on suppression, NO turn off SUPPRESS PFKEYS ON PRINT => ___ YES turn on suppression, NO turn off SUPPRESS EXECUTE PANEL => ___ YES turn on suppression, NO turn off PRIMARY LANGUAGE => __ TWO character primary language ID SECONDARY LANGUAGE => __ TWO character secondary language ID DECIMAL POINT CHARACTER => _ Character to be used for decimal point QUERY LANGUAGE => ___ Language for queries - SQL or DQL SQL AUTHORIZATION ID => __________________ ASSOCIATE USER ERRORS => ___ Display validation errors for assoc ------------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> DISP GROUPS <PF4> UPDATE <PF5> PRINT OPT <PF6> NOT USED <PF7> NOT USED <PF8> NOT USED
Description
CA Dataquery displays the values for each profile item that were assigned as defaults, or those that were later specified by the CA Dataquery Administrator or by you.
Action
You can change any profile item, but you should ensure that the values meet site standards. For example, if you specify a network printer ID that is not a valid ID, you cannot receive printed output.
When you change your own profile, the changes take effect immediately. The Datadictionary database ID always reverts back to the site default when you sign off. The SQL Authorization ID returns to the default when you sign off.
Profile Items
A discussion of each profile item follows:
(Required) Enter the CA Datacom/DB database ID that specifies the Datadictionary database to be accessed. The database specified must be a Datadictionary database accessible to CA Dataquery. CA Dataquery supplies the CA Datacom/DB database ID from the System Option Table.
(Required) Enter YES or NO. Specify YES to include Datadictionary aliases in the Directory of DQL Tables, and Keys and Columns Display panels. NO excludes Datadictionary aliases from these display panels. (See the CA Dataquery end user documentation for details on these panels.)
(Required) Enter YES or NO. Determines the way a compound field is displayed on a report. If you specify YES, fields making up the compound field are shown as individual fields. When you specify NO, a compound field is shown as 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. If an invalid value is entered, the parameter defaults to NO.
(Required) Enter YES or NO. Determines if duplicate values for columns specified as control break columns are suppressed in the generated report. If you specify YES, 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.
(Required) Enter YES or NO. Specify YES to suppress the PF key descriptions on the print panel that displays the report. NO causes the PF keys descriptions to be displayed.
(Required) Enter YES or NO. Specify YES to suppress the display of the Online Execution Query panel. NO causes the Online Execute Query panel to be displayed. A user would want to suppress the display of the Online Execution 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.
(Required) Enter 2 characters. Specifies the primary language to be used during the current CA Dataquery session. A valid 2-character entry overrides the language specified in the System Option Table at installation. (AE American English is the default if no other language is specified on the System Option Table.)
(Required) Enter 2 characters. Specifies the secondary language to be used during the current CA Dataquery session. A valid 2-character entry overrides the language specified in the System Option Table at installation. (AE American English is the default if no other language is specified on the System Option Table.)
(Optional) Enter 1 character. Specifies the decimal point character for this ID. The default is the value of the DECPT= parameter in the System Option Table.
(Required) Enter either DQL or SQL. Specifies the query language to be used for this ID. Y (yes) must have been specified on the User Table Maintenance in the field SQL AND DQL ALLOWED for the user to be able to change from DQL to SQL in this field.
(Required) Enter a 1- to 18-character authorization ID. Specifies the SQL authorization ID for execution of SQL statements for this ID.
When the SQL authorization ID is changed by the PROFILE or AUTHID command, it changes only on the user profile, and not on the User Table. The private SQL authorization ID attaches to the table name regardless of the authid in use during creation of the table. When the DISPLAY, LIST, EXECUTE, or CREATE functions are used, the profile authid is used.
(Optional) Enter YES to display normal end-user validation errors for the associate user. Enter NO to display only DQ244E when errors occur. DQ244E states only that the user is attempting to execute a query that has an error.
PF Keys
The following lists each PF key for the User Profile panel.
Returns to Main Menu without updating.
Displays Help panel PF key options.
Exits panel or Main Menu.
Displays group level names assigned to this user system.
Saves the values displayed on this panel.
Displays print options.
|
Copyright © 2014 CA.
All rights reserved.
|
|