Defining or Modifying the User Profile

Access

You can define or modify a user profile by performing either of the following. You must have User Maintenance authorization.

Typing USERS on the command line and pressing ENTER to display the Directory of CA Dataquery Users panel. Place the cursor on the user name and press <PF10> PROFILE to display the User Profile panel.
Signing on as that user and selecting the PROFILE option from the Administrative Menu.

When you change another user's profile, all field changes take effect when that user signs on next.

When changing your profile, some changes take effect immediately and some are changed for the duration of the current session only. The CA Datacom Datadictionary database ID always reverts back to the site default at sign-off. The SQL Authorization ID returns to the user's default at sign-off.

CA Dataquery supplies entries to the panel from the User table, the Option table, and the previous session (if any).

CA Dataquery displays the User Profile panel, an example of which 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 supresss 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        =>  __________________


 -------------------------------------------------------------------------------
 <PF1> HELP        <PF2> RETURN        <PF3> DISP GROUPS   <PF4> UPDATE
 <PF5> PRINT OPT   <PF6> NOT USED      <PF7> NOT USED      <PF8> NOT USED

DATADICTIONARY DATABASE ID

(Required) Enter the CA Datacom/DB database ID that specifies the CA Datacom Datadictionary database to be accessed. The database specified must be a CA Datacom Datadictionary database accessible to CA Dataquery. CA Dataquery supplies the CA Datacom/DB database ID from the System Option Table. This value can be changed by the user signed on only.

LIST AND DISPLAY ALIASES

(Required) Enter YES or NO. Specify YES to include CA Datacom Datadictionary aliases in the Directory of DQL Tables, and Keys and Columns Display panels. NO excludes CA Datacom Datadictionary aliases from these display panels. (See the CA Dataquery end user documentation for details on these panels.)

GROUP DISPLAY

(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.

SUPPRESS DUPLICATE COLUMNS

(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.

SUPPRESS PFKEYS ON PRINT

(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.

SUPPRESS EXECUTE PANEL

(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.

PRIMARY LANGUAGE

(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.)

SECONDARY LANGUAGE

(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.)

DECIMAL POINT CHARACTER

(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.

QUERY LANGUAGE

(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. This value can be changed by the user signed on only.

SQL AUTHORIZATION ID

(Required) Enter a 1- to 18-character authorization ID. Specifies the SQL authorization ID for execution of SQL statements for this ID. This value can be changed by the user signed on only and is valid for the current session only. To change this value for another user, you must use User Table Maintenance.

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.

PF Keys

Each PF key for the User Profile panel is listed below.

<PF3> DISP GROUPS: Display group to which user is assigned.
<PF4> UPDATE: Save the values displayed on this panel. Refresh User Profile panel.
<PF5> PRINT OPT: Display print options for profile. Print Options panel appears. See the section on printer options for details.