The following series of screen shots demonstrate some of the features available with iFileUtility. Scroll down and take a look at how easy this is to use and the flexibility that iFileUtility gives you.
This is the starting point for all QFU sessions.
In this example, we are looking at a Customer File that is not indexed.
From the initial screen, you can window left and right or window to a specific field name or number. You can also work with individual records.
A frequent task that IBM i programmers and terminal users have to do is to search through a file for a specific record and make a quick change to the record. iFileUtility excels at this type of task as you can see from the following two screen shots:
From the initial view, you can search for any record with a specific value in any field. You start this by pressing the F16 "Find" key. This displays the select screen shown here.
All you need to do is type in the field name, comparison operation code and search value. When you press ENTER, iFileUtility will start searching for a record that meets your condition.
iFileUtility will stop when the search is satisfied or the maximum number of search records has been met. This is a nice feature that guarantees that your terminal won't lock up looking all the way to the end of the file for bad information.
Once you find the record you need, just put a 2' (change) code on the line next to the record and iFileUtility will switch into single record format in *CHANGE mode.
From here you can scroll up and down to see all of the fields in the record.
All fields are available so you can make field content changes. Once you've made your field change, just press the ENTER key and your file will be changed. iFileUtility returns you to the file browse that you started with.
More often than not, however, you have to update more than just one record. If you know that there are only a few records, you can use the method described above to update your file. But if you've got hundreds of records, this process can get pretty tedious.
To address this problem, iFileUtility has a "Find/Replace" function:
When you select the F17 "Replace" function, the screen shown here is displayed.
From this point, you can specify selection rules along with replacement rules. You can select on multiple fields and replace multiple fields.
To enter selection rules, just press the F7 "If" function.
The screen shown here is displayed. You can enter a simple selection as shown here or you can enter a more complex selection.