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:
The Profile panel displays, as shown in the following figure.
- Press the Profile function key.
- Enter SHOW PROFILE (or SH PROF) on the command line.
- To change your QMF user
profile, position the cursor on any value in your QMF profile and type over it with the value you
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 ===> UPPERso 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 ===> YESis 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
LANGUAGE ===> PROMPTED Choose
LANGUAGE ===> PROMPTEDwhen you want QMF to prompt you for the information you need to write a query.
LANGUAGE ===> SQLwhen you want to write queries directly in Structured Query Language (SQL).
LANGUAGE ===> QBEwhen 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.