QuestView

Database utility for IBM i (AS/400)

See and fix your IBM i data, fast.

QuestView opens any file on your IBM i. You can view records, edit them, scan for values, and fix bad data.

It is easy to use. It respects the security you already set up.

Contact us See the features

What QuestView does

QuestView has tools for developers, database administrators, and analysts. Here is what it does.

View and edit

Work with any record

  • Show one record or many at once. Put the fields in the order you want.
  • See each field's type and length.
  • Find a record by its number, by a full or partial key, or by a scan.
  • Turn updates on or off while you look.
  • Open physical, logical, join logical, and Open Query files. Files with or without an external description work too.
  • See how files relate to each other. Read the entries of a journaled file.
Build programs

Let QuestView write the program

  • Choose the screen, the fields, and the function keys. Press F6.
  • QuestView builds an inquiry, entry, or maintenance program for you.
  • Your users call it like any other program. They do not need deep IBM i skills to keep data current.
  • Pass parameters to RPG, COBOL, or CL programs.
  • Build a program from journal entries.
Scan and update

Find the records you need

  • Scan forward or backward. Use wildcards, and match upper and lower case if you like.
  • Compare with EQ, GT, GE, LT, or LE. Set a limit on the number of records.
  • Scan up to 16 fields at once.
  • Search, replace, and update across whole records or up to 16 fields.
5250 or desktop

Use the screen you like

  • The 5250 (green screen) version has search and replace, hex editing, undelete, and a view of database relations.
  • It runs Open Query File (OPNQRYF) queries and reads the JD Edwards data dictionary.
  • The graphical version is a plug-in for IBM Rational Developer for i (RDi). It also runs as its own desktop app.
  • The graphical version connects to more than one system and opens several files at once.

Find and fix bad data

A decimal data error can stop a program that reads the file.

QuestView finds the bad field for you. It shows the value next to its hex form, so you can see what is wrong. Then you change the hex to a valid value.

QuestView also has undelete, so you can bring back a record that was deleted by mistake.

Security you control

QuestView follows the regular IBM i object security. It works at security levels 40 and 50.

Decide who does what

  • Choose who can display, change, or delete records.
  • Choose who can use the command line.
  • Block adds, deletes, or updates for a file.

Protect and track

  • Hide fields that hold private data.
  • Remove function keys that a user should not have.
  • Print an audit trail of each change, from before and after images and journal entries.

Help for current customers

If you have a licensed system with support, you can get a new license code at any time on the Code on Demand page. You can also ask us by email. Here is what to do.

  1. Add the library AQUESTVIEW to your library list.

  2. Run the command WRKVIEWINF. It shows your system's model, serial, and LPAR. On an older system, the LPAR may be 00.

  3. On the Code on Demand page, enter the model, serial, and LPAR of your licensed system at the top. Then enter the model, serial, and LPAR of the system that needs a license code, along with your name and email. The code arrives by email. Or email these details and your company name to info@touchtonecorp.com, and we reply with your code.

For any other question, email us or call +1 (714) 755-2810, Monday to Friday, 8 a.m. to 5 p.m. Pacific time. You can also use the contact page.

Made by Touchtone

Touchtone Corporation makes QuestView. Touchtone was founded in 1991 and began by building software for IBM i (AS/400). We are known for useful software and for the care we give our customers.

Visit touchtonecorp.com to see our other products.