Setting up and changing your QMF user profile

Your QMF user profile tells QMF how you want to display information and process commands, and what printer to use when you print reports or charts.

About this task

Your user profile is the same as the system default when you first begin to use QMF. You can change the information in your profile to match your specific needs at any time.


Choose one of the following options, depending on whether you want to display, change, or save your QMF user profile:

  • To display your QMF user profile, do one of the following operations:
    • Press the Profile function key.
    • Enter SHOW PROFILE (or SH PROF) on the command line.
    The Profile panel displays, as shown in the following figure.
    Figure 1. The QMF Profile panel controls aspects of your QMF session.
     General Operands:
          CASE     ===> UPPER    Enter UPPER, STRING, or MIXED.
          DECIMAL  ===> PERIOD   Enter PERIOD, COMMA, or FRENCH.
          CONFIRM  ===> YES      Enter YES or NO.
          MODEL    ===> REL      QMF Administration operand. May not be changed.
     Defaults for printing:
          WIDTH    ===> 132      Number of characters per line.
          LENGTH   ===> 60       Number of lines per page.
          PRINTER  ===>          Printer to be used for output.
     QMF Administration Operands:  (Not usually changed)
          SPACE    ===> "DSQDBDEF"."DSQTSDEF"
                        Enter the name of Db2 DATABASE or TABLESPACE in which
                        tables will be saved by the SAVE DATA command.
          TRACE    ===> NONE
                        Enter ALL, NONE or a character string of function-id,
                        trace-level pairs.
     1=Help         2=Save        3=End       4=Print       5=Chart     6=Query
     7=             8=            9=Form     10=           11=         12=Report
     COMMAND ===>
  • To change your QMF user profile, position the cursor on any value in your QMF profile and type over it with the value you want.

    You can change any of the profile values at any time. The following table shows some of the values of the options in your profile.

    Table 1. Some settings in the QMF profile. You can set your QMF profile with your preferences.
    Profile value Explanation
    CASE ===> UPPER QMF recognizes commands only in uppercase. If you want to enter information in mixed or lowercase, change your profile to show CASE ===> UPPER so that QMF converts your data entries to uppercase. However, if your site uses mixed-case passwords, set the CASE value to MIXED if you use the CONNECT command. Otherwise, QMF converts your password to uppercase upon entry and fails to connect to the target database. When CASE is MIXED, you must enter all QMF commands in uppercase for them to be recognized.
    DECIMAL ===> PERIOD Although other indicators (such as a comma) are available, the examples in the topics in this information use a period as a decimal point indicator.
    CONFIRM ===> YES When CONFIRM ===> YES is specified, QMF displays a confirmation panel before a command changes or replaces an object in the database. For the exercises in this information, be sure YES is specified.
    LANGUAGE ===> PROMPTED Choose LANGUAGE ===> PROMPTED when you want QMF to prompt you for the information you need to write a query.

    Choose LANGUAGE ===> SQL when you want to write queries directly in Structured Query Language (SQL).

    Choose LANGUAGE ===> QBE when you want to use the QMF Query-by-Example feature.

  • To save your QMF user profile after you have all the values set the way that you want, press the Save function key or enter SAVE or SAVE PROFILE on the command line. QMF stores the changed profile in the database, and uses the changed profile the next time you begin a QMF session.

    If you press the End function key before you save your profile, the changes you make to your profile remain in effect only until you end your QMF session.