Previous Topic: PFn - Execute a PF Key FunctionNext Topic: SQL - Change to SQL Mode


PROFILE - Display Your User Profile

Purpose

Entering PROFILE and pressing Enter displays the User Profile panel containing CA Dataquery options you can change. See Panels for a complete discussion of your user options.

When to Use It

When you want to view or change your session options.

Syntax

Enter

With

When You Want to:

PROFILE

No operand

Display or change your options on the User Profile panel.

Example

=> PROFILE Enter the desired options and press the appropriate PFkey ------------------------------------------------------------------------DQE30 DATAQUERY: TOTALING OPTIONS ----------------------------------------------------------------------------- QUERY NAME => USER-SAMPLE TOTALING OPTIONS X DETAIL and TOTALS - Produce report with detail and totals

Result

=> Overtype the values to be modified and press PF4 to complete the update ------------------------------------------------------------------------DQKL0 DATAQUERY: USER PROFILE FOR => BIRDS ----------------------------------------------------------------------------- PROFILE ITEM EXPLANATION ----------------------------------------------------------------------------- DATADICTIONARY DATABASE ID => _____ Five digit DB ID number for D D access LIST AND DISPLAY ALIASES => ___ YES show aliases, NO suppress aliases GROUP DISPLAY => ___ YES break out simple cols, 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