Software: Quick File Utility/400
|
|
|
Software: Quick File Utility/400 |
 |
||||||||||||||||||
The following series of screen shots demonstrate some of the features available with QFU/400.
Scroll down and take a look at how easy this is to use and the flexibility that QFU/400 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 AS/400 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. QFU/400 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, QFU/400 will start searching for a record that meets your condition. |
QFU/400 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 QFU/400 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. QFU/400 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, QFU/400 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. |
 |
Once your selection rules are set, you can enter your replacement rules by
pressing the F8 "Replace" function.
The screen shown here allows you to specify field replacement rules. You can update a single field as shown here or you can update multiple fields. |
When you have entered your selection and replacement rules, QFU/400 will show the following screen and allow you to either make more rule changes or process the file update.
 |
This screen shows you what your "Find/Replace" will do when you run it. |
Once you're ready to run your replace function, just press the F10 function.
 |
This screen allows you to keep the generated program source for later
re-use
and possible tailoring by any RPG programmer.
It also allows you to specify a control report to show how many records are changed. |
For situations that are even more complex, QFU/400 provides and exit point in the Find/Replace function.
 |
Using this screen, you can specify complex selection rules at "input time"
in
the Find/Replace function.
You can also enter field manipulation rules at "output time". These both use simple RPG programming codes. |
To place your
order
for a FREE trial of Quick File Utility/400,
CLICK HERE
To get your
FREE trial via Internet Download, CLICK
HERE