Frequently Asked Questions

System Information & Authorization Code Screen Display:

How can I find out the model #, serial # and LPAR # of my system?

From an iSeries-AS/400 command line, do the following:

  1. Add AQUESTVIEW to your library list.
  2. Type in WRKVIEWINF and press [enter].
  3. Model #, Serial # and LPAR # (see current partition for LPAR #) is shown on display screen.
faq-1
How can I see what version of QuestView I'm using?

From an iSeries-AS/400 command line, do the following:

  1. Add AQUESTVIEW to your library list.
  2. Type in WRKVIEWINF and press [enter].
  3. "QuestView Version:" line '...Serial # ...' will display current version in use.
faq-2
How can I check my QuestView authorization code, and confirm its status?

From an iSeries-AS/400 command line, do the following:

  1. Add AQUESTVIEW to your library list and press [enter].
  2. "Existing code" line will display the current code, and "Existing code status" will display either "LICENSED CODE,"
faq-3

Or (if the code is nearing expiration) the number of days before the code expires.

faq-4
How can I get a screen print of my QuestView Authorization Code?

From an iSeries-AS/400 command line, do the following:

  1. Add AQUESTVIEW to your library list.
  2. Type in WRKVIEWINF and press [enter].
  3. Get screen print.
Where is my QuestView authorization code located?

The location of the authorization code is in the data area VIEWKEY in the AQUESTVIEW library.

Creating & Modifying VIEW Program:

What is a View Program?

A VIEW Program is nothing more than a saved set of QuestView parameters that launch QuestView with these settings in place. This makes it very easy to "program" a data maintenance or reviewing program with lots of functionality. It can be done in minutes as opposed to the hours it may take in RPG or DFU.

An important feature of VIEW Programs is that they are actual *PGM objects, which can call, or be called by, other programs, passing parameters and accepting parameters. This makes them very easy to integrate into user menus and other iSeries-AS/400 programs.

When is it appropriate to create a View Program?

It is time to create a View Program when:

  • You wish to incorporate several VIEW Program, RPG, or CL programs
  • You need to repetitively update an AS/400 data file (i.e., an address database).
  • You need to allow users to view data without update abilities (i.e., an accounts receivable database).
  • You need to repeatedly correct decimal data errors in packed fields, and they can also appear in zoned fields
  • You want to allow users to query a database but they do not know Open Query syntax.
  • Just about any other time you need to edit or look at AS/400 data.
How do you create a View Program?

Pressing F14 , or pulling down Create A Program on the Program menu opens a pop-up window allowing you to enter the specifications for a View Program, which will capture all of the current QuestView settings in a small program, which can then be called directly from the command line, attached to a command, or called from any other program.

Can I modify an existing View Program or do I have to create a new View Program?

A. You can modify any VIEW Program, and either re-create it under the old name and library (replacing the original), or a new name and/or library (leaving the original intact).

B. Once a View Program has been created, pressing F21, or pulling down Load a Program on the Program menu, opens a pop-up window allowing you to load the settings from any View Program for modification. Once the settings have been loaded and modified to your satisfaction, the program can be re-created the same way it was created originally.

Disaster Recovery & Emergency Code:

How can a QuestView customer obtain a disaster recovery (DR) code for testing?

QuestView customers with current support contract can access our 24/7 Code on Demand web site for a code to activate QuestView on a new iSeries-AS/400 for a few days of testing.

Click on this link to go to: Code on Demand

Is there an emergency phone number that I can call after hours?

Yes. In case of emergency during off hours, please call +1 949-278-7342 and leave a message if needed.

We are getting ready to conduct our Disaster Recovery (DR) test, do you have any instructions?

Please follow these instructions to activate QuestView on your disaster recovery iSeries-AS/400:

  1. Sign on as QSECOFR (or equivalent).
  2. rstobj *all qtemp *savf savf(aquestview/aqvwbackup)
  3. qtemp/install.
  4. Input the new authorization code (or get code from link below).
Code on Demand

Customizing QuestView Data Screens & Functions:

When I launch QuestView, Dots are displayed on QuestView screens, how can I get rid of the Dots?

They're column separators. You can either turn off column seps in whatever emulator or terminal you're using, or turn off full color in QuestView.

Note: see FAQ's How to turn off Column Separators for more details.

How to turn off Column Separators in QuestView for IBM Client Access?

The column separators can be turned off as follows:

  1. Click Edit (in the menu bar) > Preferences > Appearance > Display Setup.
  2. In the Display Setup window, select the category called Viewing (use the scroll bar).
  3. A Settings box on the right side of the screen will allow you to turn off Column separators.
Does the undelete function still require an exclusive lock on the file in order to restore a previously deleted record?

Yes. That is inherent to the only known way to undelete records, and is unlikely to ever change unless IBM itself decides to offer an undelete function.

Also, variable-length fields on deleted records are not recoverable.

Does QuestView allow you to look at data or change data if the field has a data decimal error?

Yes. QuestView has always had the ability to deal with decimal data errors. Among your options, you can bring up the hexadecimal display (note that fields with DD errors are displayed in hex whether you have the full hex display turned on or not), and use that to fix the error, or you can do a search-and-replace for decimal data errors.

Can you tell us how to hard code the scan setting to 1000, instead of 100? I see where to change it while in a session, but it doesn't stick afterwards. Any assistance would be greatly appreciated.

To set the default for any option that is defaultable, use VIEWOPTS. "Max number of records to scan at a time" is the third option (and the fourth green entry field, row 5 of the screen) on the first page.

How do I change some users ability from "display update with Hex?"

Hex can be disabled globally in VIEWOPTS, or for individual users (or globally for individual files, or for specific combinations of file and user) from VIEWAUTH.

QuestView Printing:

How can I print a full record in QuestView versus printing page by page?

Whenever a System Print AID code is sent to QuestView, in single-record mode, it will print the entire record on however many pages are required. If by some chance you are getting screen prints instead, it is because (if you're using a terminal) the terminal is set on local print, or (if you're using an emulator) you are using the local print function rather than the system print function.

Note: If this doesn't answer the question, please call +1 (714) 755-2810 from 8:00 – 5:00 p.m. P.S.T and provide more details or see link below.

http://www.questview.com/contact-us.html

Where can I find the Print Options in QuestView?
  1. Open a file in QuestView.
  2. Press F10 from the single or multiple-record screen to move cursor up to the drop down menu.
  3. Select "O" to display the Options drop down menu.
  4. Select 4 to open Print options drop down menu.
Can I print the Database Relations screen in QuestView?

The Data Base Relations screen is printed in full, except that there are no alternating color bands, and instead of color coding descending keys, they are preceded by the letter D.

Can I Query a file while using QuestView?

QuestView can execute the Open Query File (OPNQRYF) command, and display the records it retrieves. This allows you to perform the following functions dynamically, independently of the access paths of permanent physical and logical files:

  • Select records based on values in fields
  • Order records using any fields as keys
  • Use a record format other than that of the file
  • Join files together, including joins over permanent logicals and join files
  • Specify key fields from any of the joined files (not just the primary)
  • Display only the first record from a group
  • Group many records into a single record
  • Compute aggregate functions from grouped records
  • Compute values from mapped fields, allowing complex calculations

For a complete listing of these capabilities, please refer to the QuestView User Manual and/or QuestView Learning Guide.

QuestView Viewing, Editing & Scanning data files:

How can I view and edit an iSeries-AS/400 data file in QuestView?

To view the file, simply type: VIEW [library/member name] at the prompt. QuestView will launch and open the appropriate database for viewing. To edit or update that file (if you have authority to do so), simply press [F11] and QuestView will switch you to update mode where you can tab through the fields and edit them. Note that all of the fields will be underlined. This indicates that they can be edited. After editing, press Enter. The change(s) will take effect immediately.

Where can I find other information about the data file?

QuestView allows you complete access to a wide variety of other information about the data files you are working with. This information is generally accessed through the QuestView menu or through one of the function keys listed along the bottom of the screen. A few of these function keys are listed below:

  • [F18] - view database relations
  • [F14] - view field attributes
  • [F8] - command line access

For a complete listing of these capabilities, please refer to the QuestView User Manual and/or QuestView Learning Guide.

Why can't I see all the fields in the data file?

This is most likely because you have turned off field display for those fields in a prior session of QuestView. QuestView remembers the last settings you used until you log off the AS/400 and log back on (so that you don't have to reset things like multi-record view vs. single-record view and so forth). You can either log off and back on or simply reverse the changes you made previously. Also, you can execute the command RCLRSC at the AS/400 Command Line. Next, execute the View Command and all values will be restored, and all fields will be displayed.

How can I scan on specific fields?

To scan on selected fields only, press F14 from either the single or multiple-record screen. Then tab to the specific field on which you want to perform the scan. Enter an S into the entry area for that field. If you would like to scan on multiple fields, enter an S in each field you'd like to scan (maximum of 16 fields). Now, when you perform a scan, only those fields with your specified value will be selected and will all be displayed. To display a particular field, use the F14 screen. The scan value is entered in the scan field on the data screen of choice. There are also scan options available on the Scan Options pop-up menu. F16 scans forward and F17 scans backward.

How do I turn off specific scanning and go back to scanning all fields?

Simply press F14 again and remove the "S" from all the fields on which you don't want specific scanning. (If you clear all fields, you go back to scanning all fields.) F16 scans forward and F17 scans backward.

QuestView Deleting/Undelete Records:

Can QuestView Restore/Recover Deleted Records?

Yes. QuestView now includes a fully-integrated Undelete utility. To access Undelete, go to the Services (F8) screen, from any physical file, and press F23. Once the file has been successfully loaded into the undelete utility, you will see a record displayed by fields. Use the Page Up and Page Down keys, and/or the relative record number field, to move through the file, or F19/F20 to search for deleted records. Once you have found the record to be restored, press F23 to attempt undeletion.

Note: please contact us at +1 (714) 755-2810 from 8:00 a.m. - 5:00 p.m. P.S.T for Undelete addendum PDF or contact us via link below.

http://www.questview.com/contact-us.html
Does QuestView have a Search and Replace feature?

Yes. Pressing F15 from either data screen, while in update mode, activates the Search and Replace Function, bringing up a simple full-screen dialog with two entry fields, marked "Search For" and "Replace With." Pressing F15 or F23 after entering the Search and Replace strings replaces all occurrences of the Search string in the file with the Replace string. If fields have been selected for the Scan function (using the Field Attributes screen), only the selected fields are affected; otherwise, all fields are affected.

Can I do a Global Update?

Yes. If exactly one field is selected for scanning, F22 on the Search and Replace screen will activate a Global Update function, replacing the contents of the selected field with the Replace string, regardless of the present contents of that field.

QuestView Installation:

How can I check to make sure all users are out of QuestView before I install/upgrade to a new version of QuestView?

One good way would be to look for locks on the file, AQUESTVIEW/VIEW.

Key in command: WRKOBJLCK AQUESTVIEW/VIEW OBJTYPE(*FILE).

What does GETUPDATES do and why should it be run?

GETUPDATES is a utility that will download updates (mainly QuestView updates) from our FTP server, quickly and painlessly, with much less trouble than doing a normal installation. It should be your first choice whenever you want the latest version.

What options are available for customers to install QuestView?

Several options are available via the internet:

A. FTP installation. Please call +1 (714) 755-2810 M-F from 8:00 a.m. – 5:00 p.m. P.S.T for FTP installation instructions or contact us via the link below:

http://www.questview.com/contact-us.html

B. Web installation. See link below:

http://www.questview.com/install.html

C. SAVF installation. Please call +1 (714) 755-2810 M-F from 8:00 a.m. – 5:00 p.m. P.S.T for SAVF installation instructions or contact us via the link below:

http://www.questview.com/contact-us.html
My iSeries-AS/400 does not have access to the internet. What other option can I use to install QuestView?

QuestView can be installed using a SAVF. Please call +1 (714) 755-2810 M-F from 8:00 a.m. – 5:00 p.m. P.S.T for instructions or contact us via the link below:

http://www.questview.com/contact-us.html