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 ------------------------------------------------------------------------DQKM0 DATAQUERY: USER PROFILE FOR => ________________________________ ----------------------------------------------------------------------------- HARDCOPY PRINT OPTIONS EXPLANATION ----------------------------------------------------------------------------- NETWORK PRINTER-ID => ____ Four Character ID of Network printer PRINT QUERY TEXT => ___ YES print the query text, NO do not PRINT STATISTICS => ___ YES print the query stats, NO do not PRINT BANNER PAGE => ___ YES print the banner page, NO do not PRINT USING WINDOWS => ___ YES window format, NO wrap format PRINT PAGES TOGETHER => ___ YES pages together, NO windows together PRINT NUMBER OF COLUMNS => ___ Three digit column width of hardcopy PRINT NUMBER OF ROWS => ___ Three digit page length in rows ----------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN <PF3> DISP GROUPS <PF4> UPDATE <PF5> PROFILE <PF6> NOT USED <PF7> NOT USED <PF8> NOT USED
Timing
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).
(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.
(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.)
(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.
PF Keys
Each PF key for the User Profile panel is listed below.
Display group to which user is assigned.
Save the values displayed on this panel. Refresh User Profile panel.
Display print options for profile. Print Options panel appears. See the section on printer options for details.
|
Copyright © 2014 CA.
All rights reserved.
|
|