The primary goal of this manual is to make you an efficient and productive user of DATA BASE UTILITY. To accomplish this, we have presented the features of DBU to you in two different formats:
1) User’s Guide: Presented in a more personal tone, it leads the user through all the features of DBU. However, experienced DBU users may find some sections of this format helpful in learning the new features of DBU.
2) User’s Reference: Presented in a more formal tone, it concisely explains all the features of DBU. This format assumes that the user is experienced with DBU and does not want to be led through the features by a demonstration.
Regardless of the format you choose to learn DBU, this manual will enhance performance if used correctly. Both text formats try to present the material in the clearest manner possible in order to give the user a clear understanding of the DBU features.
The only text notation, that needs to be explained for this manual, is the brackets [] used in the User’s Guide. The brackets [] are used to identify the exact key or keys to be pressed. For example, if the user were being taught about the F1 key, the user might see something like this: "The F1 key is used to display on-screen help text. Press [F1] now to ..." Note that when F1 is being discussed it does not have the brackets around it, but when the user is actually supposed to press F1, the brackets are around it.
DBU is a file access utility which can be used to locate and update records from one to as many as four different files via logical paths or relative record numbers in any physical file. No creation time is involved. From your main screen or command line, type in "GO DBUMNU" or "DBUMNU" and press enter. The DBU menu will appear on your screen. You can also bring up a file from a command line by keying in DBU followed by a file name. DBU also works with logicals over multiple physicals with multiple members and join files (display only on join files). Members and/or formats can be selected from the logicals to be updated or displayed. Records can be updated or displayed in character or hexadecimal mode. Keys can be set to access logical files and it is possible to select only certain fields to be displayed or updated. DBU has a Menu-driven Windows Environment. Almost all command key functions can be performed by utilizing one of the seven main headings on the DBU Action Bar. Up to four files can be displayed in four different windows on one screen. Access to each window is as simple as using a mouse or the keyboard arrow keys to move the cursor to the desired window (file). DBU also has numerous display options available to facilitate better manipulation and utilization of your files while in DBU. Displays can be as simple as one single record in an optional one, two, or three column format or as complicated as four different files simultaneously showing multiple records. DBU windows can be resized and/or moved in order to optimize screen space. Any individual window of the Multiple File Display can be "zoomed into" or "maximized" and then returned to its original size with a single keystroke. Each window’s border characters can be changed for ease of file identification and, if a color monitor is used, the window’s border color can be changed to any one of five colors. An audit log is available to a user-defined output queue. This audit log can be authorized as required by user or group profile or voluntarily activated by any authorized user. A "Print Record" feature is also available for users desiring a printed copy of a record. A SEARCH/REPLACE OPTIONS screen is available by command key or via the DBU Action Bar. The SEARCH/REPLACE OPTIONS screen prompts the user for necessary parameters to perform a Search or a Search & Replace routine. The AND/OR parameter allows the Search or Search & Replace criteria to range from simple to complex because it permits the user to create either a single Search/Search & Replace parameter or an assembly of a more intricate set of Search/Search & Replace conditions. Parameters such as FIELD NAME/*STRPOS, FROM/TO criteria, and logical tests that consist of EQ, NE, LE, GE, LT, GT, and CT allow for intricate conditions to be applied to a Search or Search & Replace routine. Miscellaneous parameters such as: # OCCURRENCES, IGNORE CASE, PRINT RESULTS, and # RECORDS SEARCHED further enhances the sophisticated Search or Search & Replace capabilities of DBU. Another feature of DBU is the DBU Application. Screens can be designed by selecting fields, etc. and perhaps opening multiple files in different windows. This formatting can be given a name, saved as an application and recalled by DBU. All files and screens will appear as the application was designed. The features outlined above are only a few of the many features and capabilities of DBU that will help you save hours of time debugging data base errors during new development or after program errors have occurred. Another important aspect of DBU is the Security it offers. Complete user profile-tailored security allows DBU to be placed on non-technical user menus, making DBU capable of being more than a programmers’ productivity tool. In fact, DBU is currently being used today by many non-technical personnel as a substitute for programmer-written maintenance and display programs. Perhaps the most important features of DATA BASE UTILITY are:
1) PRODATA Computer Service’s strong belief in and willingness to stand by DBU because we feel it is the best File Access Utility today, and
2) The continued support we provide to DBU customers. PRODATA’s commitment to excellence ensures our DBU customers of an ongoing, friendly service should any questions or comments concerning DBU arise.
Welcome to ProData Computer Service's Data Base Utility documentation. DBU is a file access utility that can be used to locate and update records from a single file or as many as four different files via logical paths or relative record numbers. DBU was designed to be as user friendly as possible while at the same time giving maximum power to even the newest users. In order to help meet these requirements we have decided to present DBU in a window-like environment that could use a mouse if the user so desired and has an Info-Windows terminal. The mouse will also work when using a P.C. with Rhumba.** It is the goal of this documentation to effectively educate the new user in what we feel is the most advanced file access utility available today. The documentation is divided into five units: The first unit explains the command "DBU" which is used to access the files. It also explains each of the command’s options.
**NOTE: If you wish to access the action bar and pull down menus using your mouse, when using RHUMBA, you need only to configure each action bar selection as a hot spot and point and click.
Some basics to check before starting DBU:
On the command line enter [DBU] and press [F4] to bring up the DBU command prompt.
DBU Command Prompt Screen 
Figure 1.2 The DBU Command Prompt Screen will appear on your screen. There are thirteen parameters on this command. File/Application Name:... Required. Enter a file name or a previously created DBU application. This parameter defaults to *PRV which allows DBU to bring back the last file/application that was used. If your last use of DBU involved an application, then the 'DBU type' parameter must be *DBUAPP for the previous application to be retrieved. Library Name:... Required. Enter the library name (*LIBL is the default) that contains the file to be accessed or
DBU Type:... Required.
The default for the "DBU Type" field is *FILE. At first, most DBU types will be a *FILE type. Once you become familiar with DBU, you may choose to generate a DBU application to present data formatted to your specifications. You would then enter the application name at the "File/Application Name" prompt and enter *DBUAPP at the "DBU Type" prompt. Please keep in mind that the DBU Application feature is accessible to only those with the proper authority level. Member Name:... This parameter allows you to define a specific file member. The default is *FIRST so that, unless otherwise specified, all files accessed by DBU will display the first member in the file. To display a complete list of all members, key in *ALL. Using the generic* choice allows you to key in one or two letters and an asterisk to get a shortened member listing. The next nine fields are options that may be applied when DBU accesses a file. Note that the: Default Format:... Default Mode:.. Print Audit Log:... options have *DBUAUT (DBU Authority) as their default. *DBUAUT is explained in depth in Unit 5. *DBUAUT will set these options according to what is allowed by the individual user profile. Allow Change of File Name:...The possible values are:
Revoke Add Authority:... Revoke Change Authority:... Revoke Delete Authority:... are options that have *NO as a default which means that the user will have the authority to add, change and delete records in the file. This parameter may be changed to *YES if you do not wish the user to have this authority when the database is accessed. If the user profile in DBUAUT has the authority to add, change or delete, that authority can be revoked here. If the user does not have the authority to add, change or delete in DBUAUT, then this parameter can not override that authority. Number of Columns:... option refers to how many columns on the screen are initially used to display the fields in a record. However, as you will seen in the next section, while you are in the DBU Main Display, you may change the number of columns used to display the fields from one column to as many as three columns, at any time.
PeopleSoft installation….option refers to JDE/Oracle plug-in.
Accessing Your File The first display you will see when accessing a file with DBU is: **RETRIEVING FILE INFORMATION**. If DBU doesn't find the file, you will see the command prompt screen again with an error message at the bottom. 
Figure 1.3 There are a number of reasons why you might see this screen:
Obtain authorization or correct the errors and re-enter. Summary The first step to take when preparing to use DBU is to ensure the "DBU70" library has been added to your library list. The DBU command prompt screen consists of thirteen parameters. Providing that the file that DBU is to access is located in a library on your library list, the only mandatory field is the "File/Application Name" field. After the first three parameters, the remaining ten fields are for setting defaults or initial settings for DBU. If your file is in your library list, just type DBU followed by the file name desired. If the message, "Invalid File, Library or Member name" comes up on the screen, you have something wrong. Prompt DBU and enter in your file name and library name on the "DATA BASE UTILITY" screen. Check to ensure that:
If all of the above is correct, you will have no problem accessing your file with DBU.
After successfully finding your file, the initial DBU Screen will appear. For documentation purposes, five major sections of the screen below have been identified. Compare these to the screen.
Figure 1.5
In order to use the pull down menus, the action bar must be activated. You can activate the action bar by pressing F10. Position the cursor at the desired menu heading and press Enter to pull down that menu. Each menu has multiple options. If using a mouse, position the cursor on the menu item desired and click left mouse button. If using keyboard, enter option desired and press enter. You can exit the menu by pressing F12. The Action Bar provides an alternate method to perform the functions of most of the Command Keys. In fact, it also offers some functions not accessible through the command keys. The Action Bar makes DBU a mouse-compatible windows environment. Providing you have the correct type of terminal, you would be able to access the Action Bar, pull down the menu of your choice, and then select the option you need without even touching the keyboard! Another reason for the Action Bar is the multitude of functions that DBU contains. Twenty-four command keys were not enough to harness the power that DBU possesses! All of the functions accessible through the Action Bar are explained in Unit 3. You can activate the Action Bar with F10 and then use the Tab key to move to the menu heading you want. After tabbing to the required menu heading, press "Enter" to pull down that menu. You can back out of the menu by pressing F12.
**NOTE: The "WINDOW" menu can only be pulled down when multiple files are open.
Try looking at all the menus to become familiar with where different commands are located in the menu system. For your convenience, Appendix A: Command Keys To Action Bar Menus, displays a chart indicating the location in the menus of all the functions that are accessible through the command keys.
This area of the screen primarily shows information on the file being accessed. This information is visible while in the Single File display only. The "Mode" of display is also shown, it will be Add, Update, Delete or Display. The one input field is the "Control" field. This field allows navigation within the file and has many other options. See "Control Field" below.
File. . . The DBU "File" automatically displays the name of the active displayed file.
NOTE: This field will not be displayed while multiple files are displayed unless the window containing the active file is maximized by using either F23 (Window Max) or the Action Bar.
Library . The DBU "Library" automatically displays the library name the active displayed file is located in.
NOTE: This field will not be displayed while multiple files are displayed unless the window containing the active file is maximized by using either F23 (Window Max) or the Action Bar.
Page Number . . . The DBU "Page#" automatically displays the page number of the active displayed record. Lengthy records may require more than one screen. Each screen required for any single record is considered a "Page".
EXAMPLE: An indication of PAGE# . . .: 1 of 3 informs the user that the current display is the first of three pages that contain the displayed active record.
There are three things that may be done to attempt to fit the record on one page:
1. If the record is just one or two fields too long to fit on one screen, use F2 (Non-display Keys) to remove the command keys displayed at the bottom of the main DBU screen. Removing the command keys allows two more lines to display fields.
2. The user may also use F13 (Columns) to increase the number of columns displayed (up to a maximum number of three) on one screen.
3. F4=List Fields may be used. The list Fields screen will allow the user to select only those fields needed for viewing to appear on the main DBU screen. Consequently, the amount of room needed to display the record may have been reduced enough to allow the record to fit in one column on one screen.
NOTE: This field will not be displayed while multiple files are displayed unless the window containing the active file is maximized by using either F23 (Window Max) or the Action Bar.
Member. . . The DBU "Member" automatically displays the member name of the active displayed file.
NOTE: This field will not be displayed while multiple files are displayed unless the window containing the active file is maximized by using either F23 (Window Max) or the Action Bar.
Format. . . The DBU "Format" automatically displays the Record Format of the active displayed file.
NOTE: This field will not be displayed while multiple files are displayed unless the window containing the active file is maximized by using either F23 (Window Max) or the Action Bar.
Mode . . . The DBU "Mode" automatically displays the Display Mode (Add, Change, Display, or Delete) of the active displayed file.
NOTE: This field will not be displayed while multiple files are displayed unless the window containing the active file is maximized by using either F23 (Window Max) or the Action Bar.
Record Length. . . The DBU "Record Length" automatically displays the record length of the active displayed file. DBU can handle record lengths up to 32,766 as of Version 7.0
NOTE: This field will not be displayed while multiple files are displayed unless the window containing the active file is maximized by using either F23 (Window Max) or the Action Bar.
File Access. . . The DBU "File Access" automatically displays the file access of the active displayed file. This field will display one of two file access methods:
NOTE: This field will not be displayed while multiple files are displayed unless the window containing the active file is maximized by using either F23 (Window Max) or the Action Bar.
Record Number. . . The DBU "Record Number" automatically displays the relative record number of the active displayed file. There are three ways a user may use this field:
NOTE: This field will not be displayed while multiple files are displayed unless the window containing the active file maximized by using either F23 (Window Max) or the Action Bar.
W"n": Where "W" = Window, and "n" = Number column (Field) to be the leftmost or first column (Field) on the display screen or window.
|
F1 |
||
|
F2 |
||
|
F3 |
||
|
F4 |
||
|
F5 |
||
|
F6 |
||
|
F7 |
||
|
F8 |
||
|
F9 |
||
|
F10 |
||
|
F11 |
||
|
F12 |
||
|
F13 |
||
|
F14 |
||
|
F15 |
||
|
F16 |
||
|
F17 |
||
|
F18 |
||
|
F19 |
||
|
F20 |
||
|
F21 |
||
|
F22 |
||
|
F23 |
||
|
F24 |
|
OPTION |
PURPOSE/FUNCTION |
|
SEQ# |
Indicates which sequential position each field will be displayed relative to the other fields of the record. |
|
SELECT |
Indicates which fields DBU will display. The default setting with no fields selected will display all fields. Selecting, with an "S" or "X", any one field will override the default setting and will display only the fields selected. Keying an "L" into the select field will Lock that field on the screen. Keying an "O" will Omit that field from the screen. |
|
DISPLAY ONLY |
Applicable in Update Mode only; write protects selected fields. Cursor will position at first field not selected. |
|
NEW LINE |
Applicable to two or three column record display only; causes selected field to break to new line. |
|
NEW PAGE |
Applicable to one, two, and three column record display modes; indicates field to start new page after page break. |
|
AUTO DUP |
Applicable to Add Mode only; data in selected fields will automatically be duplicated in subsequently added records. |
|
UPPER CASE |
Applicable to Add and Change Modes; selected field's data will be input as upper case. Default is lower case. |
|
FUNCTION |
|
|
ADD |
Adds records to end of the file. |
|
CHANGE |
Update or edit an existing record. |
|
DISPLAY |
Displays records. No editing or adding permitted. |
|
DELETE |
Deletes selected record. |
|
REFRESH |
Applicable to the Change Mode; While changing a record in DBU, the user may recall the originally accessed record in its entirety. NOTE: This feature is disabled after changes have been made to a record and enter has been pressed. |
In order to use the pull down menus, the action bar must be activated. You can activate the action bar by pressing F10. Position the cursor at the desired menu heading and press Enter to pull down that menu. Each menu has multiple options. If using a mouse, position the cursor on the menu item desired and click left mouse button. If using keyboard, enter option desired and press enter. You can exit the menu by pressing F12. The File Menu displays nine options to the users. All nine options are file handling options. The nine options are shown below in Figure 2.1.
Figure 2.1
File Menu Options Open Option Figure 2.2 is an example of the Open New File option.
Figure 2.2
*generic: First letter or couple of letters of member followed by an asterisk.
*FIRST: First member in file.
*ALL: All members.
NOTE: F22 will toggle between all of the open files you have on your screen.
Suspend Option Figure 2.3 below is a sample of the Suspend File Window 
Figure 2.3
2. Suspend... Pulls down the Suspend File window which is only valid when multiple files are opened in the DBU window environment. While in Multiple File Mode the user may access the Suspend File window to remove a file from the Multiple Windows Display. A file is suspended by removing the "1" on the field preceding the file name you would like suspended, and pressing enter. The current active file will be highlighted on the Suspend File window. To reactivate suspended file, redisplay Suspend File Window and place a "1" next to the file that you suspended. Press enter to reactivate this file. Keying SSP on the Control Field will also access the Suspend File window.
Close Option Figure 2.4 below is a sample of the Close File Window 
Figure 2.4
3. Close... Pulls down the Close File window. Keying CLO on the Control Field also closes an active file. The user may select from two options:
Single File Display: Selecting Confirm while in single file display mode will not close the active displayed file or terminate the DBU session. You need to press F3 to accomplish this task. If you are not using multiple files and you try to close a single file, you will get a message that says "You are not in a windows environment. Selection ignored."
Multiple File Display: Selecting Confirm while in multiple file display mode will close the active displayed file only and will return control to the multiple file display screen highlighting the next available active file.
Fields Option Figure 2.5 below is an example of the Fields Screen that appears when the Fields option is selected from the File Menu. Just enter "4" in the input field and press enter or position the cursor on option name and double click to select. Pressing F4 will also bring up the DBU Field Selection screen. 
Figure 2.5
NOTE: Options will remain in effect until user changes them or until DBU is exited.
From the top: File......: Name of the current file being accessed. It cannot be changed on this screen. Library...: Name of the library being accessed. It cannot be changed on this screen. Member....: Name of the member being accessed. It cannot be changed on this screen. Position To Record Format - This field allows the user to display the layout and the name of the fields in any format in the file. This does not change the format being accessed by DBU, just allows the user to look at the fields that are in the other formats. The format displayed will always be the format currently being accessed. DBU can be directed to just access one format of the file exclusively. Look at the Format Menu on the Action Bar or key FTS in 'Control Field' on the Main DBU Screen. Position to Field Name- By keying in a field name and pressing enter, DBU will go directly to that field. The “position to” applies only to this Field Selection Screen. Single Record Text/Field Name - If keying in TXT, the actual text descriptions will display on the screen. If keying in FLD, just the field description will display on the screen. If keying in BTH, both text description and field description will display. If keying in ALS, Alias will be displayed.
Mult Record Text/Field/Column Heading – If keying in TXT, the actual text descriptions will display on the screen. If keying in FLD, just the field description will display on the screen. If keying in HDG, the field heading will display on the screen. If keying in ALS, the alias will display on the screen. Select/Remove Field Auto Dup - SEL will mark every field to be auto duped and RMV will remove auto dup from every field.
Source File - Name of source file that contains the RPG program which has 'I' specs defining the field layout.
Library - Library where source file resides.
Source Member - Member of source file.
RPG File Name - Name of RPG program with internal "I" specs defining field names.
Replace existing Fields -
Y = DBU will present file on screen as though it was externally defined by the "I" specs. The original layout will not be presented. All applicable DBU operations can be performed.
N = DBU will present the fields defined in the "I" specs after the file defined fields. This works as a data structure but the data will be presented twice. Updating either the original data field or the imported fields will update the file. All applicable DBU operations can be performed.
F9=Export Fields - Will create/change physical file member in a source file from the fields selected on the field selection screen. The fields will be ordered by the Seq# on the field selection screen. If no fields are selected, all fields will be copied. This option may be used two ways:
Source File - Name of the source file which will contain(s) the physical file specifications to be created/changed.
Library - Library where source file resides.
Source Member - Physical files member to be created/changed.
Replace Existing Member -
Y = Replace existing file specifications with fields selected on screen.
N = Selected field will be added to the end of the existing physical file specification in the source member.
Member Text -
*SAME - Do not change text on an existing member.
Text - Either change text on an existing member or define text for a new member. Text will not carry to new member if it is being created from an existing member.
Record Format Name - Name to be used for the record format if different from the physical file name.
F10=More Attributes - Displays a second line of information that shows New Line, New Page, Auto Dup and Upper Case fields. F12=Cancel - Returns users back to the previous screen. F15=Reset Sequence - If sequence number has been changed, this command key resequences the fields on the screen back to the sequence in which they appear in the physical file. F17=Upper/Lower - If any fields have been selected for upper case, F17 will remove the selection. If no fields have been selected, then all other alpha-numeric fields will be marked for upper case. You may also unmark any fields you desire. F24=More Keys - Brings up more command keys.
Members Figure 2.6 below is an example of the Members Screen 
Figure 2.6
Formats Option Figure 2.7 below is an example of the Formats Screen 
Figure 2.7
Data Base Relations Figure 2.8 below is an example of the Data Base Relations Screen 
Figure 2.8
NOTE: Any file opened from this screen will replace the currently active file.
Set Key Figure 2.9 is an example of the Set Key Screen. 
Figure 2.9
NOTE: Keys are limited by a total of 99 characters for the total of the field’s characters. (I.E. If you have ten keyed fields and they are each ten characters long, you might have a problem with your search of that key.)
NOTE: Keep in mind if the field is an ascending or descending numeric field.
Reactivate Deleted Record Figure 3.11 is an example of the Reactivate Deleted Records Window. 
alter up to four different file windows). The Format Menu options are on the followinpages. 
SINGLE:change sc
Mrecords i
C/the user 
Figure 2.15
Figure 2.16
DISPLAY OPTIONS WINDOW
|
COLUMN |
FUNCTION |
||||||||||||
|
WINDOW |
Numbered 1 through 4, the Window column is the only column on the window that does not accept input. The numbers represent the windows that can contain files while in the Multiple File Display. The numbers correspond to the sequence that files are opened. For example, Window 1 corresponds to the first file opened, Window 2 corresponds to the second file opened, and so on. |
||||||||||||
|
ROW |
Represents the Row point of origin for the upper left corner of the respective window. |
||||||||||||
|
COLUMN |
Represents the Column point of origin for the upper left corner of the respective window. |
||||||||||||
|
WIDTH |
Represents the left-to-right Width of the respective window. |
||||||||||||
|
LENGTH |
Represents the top-to-bottom Length of the respective window. |
||||||||||||
|
TOP |
Represents the Characters to use for the top of the respective window. This column is split into two sub columns: a. COR: Represents the character to use for the Top Corners of the respective window. b. BOR: Represents the character to use for the Top Border of the respective window. |
||||||||||||
|
L/R |
Represents the Characters to use for the left and right sides of the respective window. |
||||||||||||
|
BOTTOM |
Represents the Characters to use for the bottom of the respective window. This column is split into 2 sub columns: a. COR: Represents the character to use for the Bottom Corners of the respective window. b. BOR: Represents the character to use for the Bottom Border of the respective window. |
||||||||||||
|
COLOR |
Represents the Color to use for the border of the respective window. This option is limited by the type of terminal used. If a color terminal is used, the possible options are:
|
NOTE: Color terminals will always display the active window with a white border.
Figure 2.17 Allows user to select purpose or type display screen (current mode of display is shown highlighted):
|
MODE |
FUNCTION |
|
1. ADD |
Adds records to the end of the file. Keying ADD in the Control Field will change mode to Add. |
|
2. CHANGE |
Update or edit an existing record. Keying CHG in the Control Field Field will change mode to Change. |
|
3. DISPLAY |
Displays records. No editing or adding permitted. Keying DSP in the Control Field will change mode to Display. |
|
4. DELETE |
Deletes selected record. Keying DLT in the Control Field will change mode to Delete. |
|
5. REFRESH |
Applicable to the Change Mode. While changing a record in DBU, the user may recall the originally accessed record in its entirety. Pressing F5 will also Refresh the screen (if enter has not been pressed). |
NOTE: All modes above are based on user authority that is set up in the DBU Authority Screen (explained in Unit 5) of this documentation. The Refresh feature is disabled after changes have been made to a record and enter has been pressed.
Figure 2.18 All four of the options of this menu are applicable to Multiple File Displays only. The options are as follows:
Figure 2.19 A. Selecting option "2" from the Windows menu will return the user to the Multiple File Display. There will be two differences, however:
a. The windows will be present without any data contained within, and
b. The message: "Cursor inside Window=Move. On Border=Resize. F10=Mark Window & Continue" will be displayed at the bottom of the screen.
Figure 2.20
B. If the user wants to resize, he/she must place the cursor on the border of the active displayed file (Use F22 or place cursor on file and press enter to make a different file active) and press F10.
a. The message "Position Cursor at new location and press Enter" will appear on your screen.
Figure 2.21
C. After pressing F10, the user will receive the message: "Position cursor at new location and press Enter." After pressing enter, the screen displaying the message: "Cursor inside Window=Move. On Border=Resize. F10=Mark Window & Continue". 
Figure 2.22
D. If no further changes are necessary, press F12 to exit the Window menu.
E. If on the other hand, the user wanted to move the active file's window, he/she would:
a. Place the cursor within the borders of the file to be moved and press F10,
b. Place the cursor at the new position desired for the active file's new upper left corner position, then press enter.
c. DBU will reposition the window and, if no further changes are necessary, the user can press F12 to exit the Window menu.
3. MINIMIZE: Applicable to Multiple File Displays only; this option can be accomplished by using the command key F23. This command is used to reduce the active displayed file's window to its original size before it was enlarged by the Maximize command.
4. MAXIMIZE: Applicable to Multiple File Displays only; this option can be accomplished by using the command key F23. This command is used to enlarge the active displayed file's window to full screen size.
There are two options available from the Search Menu below. 
Figure 2.23 By placing a '1' in the field on the Define Search window and pressing Enter, the 'Define Search/Replace' screen will appear as shown below. You can also bring up the Define Search/Replace screen by pressing F15. 
Figure 2.24 DEFINE SEARCH: 
Figure 2.24a This section of the Search/Replace screen prompts the user to define the parameters for a search function.
A/O A = And, O = Or
AND - Use to string search criteria together so that all criteria must be true in order for the search to be satisfied.
OR - Use if only one of the defined equations are necessary for search parameters to be met or to start a new group of search criteria.
Field Name, *RCD, RRN User has option of searching on field names, content of records or relative record numbers or combinations of the three.
Field Name Enter field name to be searched. If the field names are not known, position the cursor in the field and press F4. A list of names in the file will be displayed and may be selected back to the search screen. Depending on the placement of the cursor, the fields will be retrieved back to the search or the replace fields. The system will enter *STRPOS if character string is to be searched. The FROM and TO fields are to be used only if a character string is to be searched.
*RCD Enter *RCD if you wish to search for decimal data errors. *RCD needs to be used in conjunction with *DECERR in the value field.
*RRN Enter *RRN if you wish to search for a particular relative record number or a group of relative record numbers.
From Numerical starting position, in the record, of character string to be searched. To Numerical ending position, in the record, of character string to be searched.
Op User has option of logical expressions to apply to search parameters:
GT: GREATER THAN - Find record(s) greater than search parameters.
LT: LESS THAN - Find records(s) less than search parameter.
EQ: EQUAL - Find records (s) equal to search parameters.
GE: GREATER THAN, EQUAL - Find records(s) greater than or equal to search parameters.
LE: LESS THAN, EQUAL - Find record(s) less than or equal to search parameters.
NE: NOT EQUAL - Find records(s) not equal to search parameters.
NG: NOT GREATER - Find records(s) not greater than search parameters.
NL: NOT LESS - Find record(s) not less than search parameters.
CT: CONTAINING - Find records(s) that contain user-defined character string any where inside user-defined "FROM" and "TO" positions.
VALUE or *DECERR: User has option of what type of data is to be placed into field or character string to be changed. Values are as below:
FIELD: Enter the name of the field that contains the data to be used as search parameter.
NUMBER: Enter a number that is to be used as the search parameter.
CHARACTERS: Enter the character string that is to be used as the search parameter. If using start positions instead of field names, put single quotes around the value (even if numeric).
HEX: Enter a valid 'X' String (i.e. Zoned Decimal 09 = X'F0F9' and Packed Decimal 09 = X'09F).
*DECERR: Enter *DECERR when searching for data decimal errors.
Fill out the parameters and press F16 or the enter key. The enter key will return to the Search/Replace screen, from which F16 can be pressed to continue the search. If enter is not pressed, F16 will proceed to search the file for the criteria defined. The search will begin using the current record displayed on the screen. If the current record is one that has already been found using the search criteria, the search begins with the next record in the file. The search proceeds forward if "Occurrences to Process" is 1=Next or 2=All. The search proceeds backward if "Occurrences to Process" is 3=Previous. The case (upper/lower) can be ignored for the search and the results of the replace can be printed. The search will read the number of records in the "Records to Search" field. If a search is satisfied before this number is reached, the record will be presented on the screen, and F16 at that point will continue to search until the total number of records read matches this number. If the search is not satisfied, this number of records will be read and a message "Maximum records read, scan condition not found" will be returned to the screen. The last record read will be presented and F16 at this point will start the search using the next record in the file and the same number of records will be searched. The fields for this section are defined below:
B. REPLACE FUNCTION This part of the Search/Replace screen prompts the user to define the parameters used to make a replace to any records satisfying the search parameters defined in the top (search) half of the Search/Replace screen. The replace section of the screen contains the following fields:
FIELD NAME: User has option of using field names or character strings or combinations of both as defined area of data to be changed.
FIELD NAME: Enter field name to be changed. *STRPOS will automatically be entered if character string is to be changed. The following two fields are to be used only if a character string is to be changed:
FROM: Enter numerical starting position of desired character string.
TO: Enter numerical ending position of desired character string.
VALUE or *DELETE: User has option of what type of data is to be placed into field or character string to be changed.
FIELD: Enter the name of the field that contains the data to be copied into the field or character string to be changed.
NUMBER: Enter a number that is to be copied into the field or character string to be changed.
CHARACTERS: Enter the character string that is to be copied into the field or character string to be changed. If using start positions instead of field names, put single quotes around the value (even if numeric).
HEX: Enter a valid 'X' String (i.e. Zoned Decimal 09 = X'F0F9 and Packed Decimal 09 = X'09f').
*DELETE: Enter *DELETE if you are doing a global delete of information in the Search area of the screen.
OCCURRENCES TO PROCESS: Prompts user to define number of repetitions and the type of Search and Replace that is to occur. The user has three options:
1 = NEXT: Causes the search to search forward through the file. The next record to satisfy the search criteria is displayed. If a replace is defined, a message to use F17=Replace to initiate the replace function is displayed. F17 will change only the displayed record and then the search automatically continues from that record. A F16=Search instead of a F17=Replace will search for the next record and not do the replace.
2 = ALL: Causes the search to search forward through the file. If used in conjunction with the replace function, all records which satisfy the search criteria will have the replace function performed without presenting any of the records back to the screen. USE WITH CAUTION.
3 = PREVIOUS: Causes the search to search backward through the file. The previous record to satisfy the search criteria is displayed. If a replace is defined, a message to use F17=Replace to initiate the replace function is displayed. F17 will change only the displayed record and then the search automatically continues backward from that record. A F16=Search instead of a F17=Replace will search for the previous record and not do the replace.
KIND OF MATCH: Prompts user to specify whether the search and replace function is to accept only those records that match with same case the defined search parameters or whether the case is to be ignored.
1 = SAME CASE: Accept only those matching records of the same case as the defined search parameters.
2 = IGNORE CASE: Ignore case while performing search and replace function.
PRINT RESULTS: Prints an audit log of all records updated with the replace values entered.
RECORDS TO SEARCH: Prompts user to select maximum number of records to be searched before the search and replace function stops.
• SEARCH(Execute): Applicable to the Search function of Search/Replace screen only. After search parameters have been entered on the Search/Replace (F15) screen and either 1=NEXT or 3=PREVIOUS is used for OCCURRENCES, press F16 to commence searching. The display will return to the main DBU display screen showing the first record meeting the search criteria. Pressing F16 again will show the next/previous record meeting the search criteria and so on until the end of the file or until no more records are found satisfying the search criteria. Another way to run a search is in batch. Searching in this way will still start the search at the place where you are in the file just like an interactive search. DBU allows you to create the search, then key an F21 to submit the search to batch. If you are performing a straight search in batch with no replace, with Print Results ' Y', the report you receive will show the record numbers that equaled the parameters you set up. If you do a search/replace in batch and specify 'Y' on Print Results, the search/replace will happen and you will have a report of all changes made. If you do a search/replace with Print Results 'N', you will still get a short report showing which records were changed but not a full audit log. Below are a few examples of some searches you may perform. The following parameters will search for all records with decimal data errors: 
Figure 2.25 The next example will search for specific relative record numbers and delete them: 
Figure 2.26 These are just a few of the many searches that you can perform in DBU.
Figure 2.27 The Extra menu contains a few of the command key functions plus a few newly added functions that will help the user to perform DBU tasks with even more efficiency. The Extra Menu options are explained on the following pages: 
Figure 2.28
EXAMPLE The Multiple Record Display currently shows columns (Fields) 9 through 15. In order to move to the left, the user presses F19 or selects this option from the Extra Menu. The Multiple Record Display Screen consequently displays columns (Fields) 3 through 8. Pressing F19 after selecting this option again will cause the display to page to the left again showing columns (Fields) 1 through 5.
NOTE: The number of columns (Fields) displayed on any individual screen or window depends on the length of the fields and/or the size of the active window.
EXAMPLE: The Multiple Record Display Screen currently shows columns (Fields) 1 through 6. In order to move to the right, the user presses F20 or selects this option from the Extra Menu. the Multiple Record Display Screen consequently displays columns (Fields) 7 through 12. Pressing F20 or selecting this option again will cause the display to page to the right again showing columns (Fields) 13 through 19 and so on until the last columns (Fields) of the records are shown.
NOTE: The number of columns (Fields) displayed on any individual screen or window depends on the length of the fields and/or the size of the active window.
Figure 2.29
Figure 2.30 NOTE: Trying to access another file using DBU from this command line will give you a "Recursive Call Error".
Figure 2.31
1=SELECT: Selecting a DBU application will close any files currently open and open only those files called by the DBU application selected. All DBU options selected by the DBU application will apply until changed, a new DBU application is run, or the DBU session is terminated.
2=CHANGE LIBRARY/MEMBER: A list of all files used in the application will appear. The user can then change the library name or the member name on any of the files. This change will stay in effect until the user changes it again. This option would be used when a file has been moved to a different library after the application has been created, or if an application was created over one member that now the user wants to access different members.
NOTE: The Library/Member can be overridden at execution time if the application only has one file.
4=DELETE: Placing option 4 on a DBU application's select line will delete that application.
5=DISPLAY: Selecting option 5 for an application will display a description of the application, its authority and descriptions of all the files the application invokes.
CREATING/REPLACING A DBU APPLICATION (F6): Pressing F6 accesses the Create/Replace Application window if the user is authorized. There are three parameters the window prompts the user to define in order for the application to be created/replaced: Application Name.. Enter an application name of ten characters or less. Description.... Enter an application description of forty-four characters or less. Public Authority.. Enter one of four parameters:
CHANGE Users are authorized to change the application. USE Users are authorized to use the application. ALL Users are allowed all authority to the application. EXCLUDE Users are not allowed to use or change the application.
This authority applies to *PUBLIC if you need individual profile authority execute the application and then in the control field type APP. When you get to the DBU Applications screen press F6 (Create/Replace Application) and then F14 (Edit Authority) and you will be presented with a screen to define the User and type of Authority that applies to the application (this does not apply to the authority for the object that the application is using). You may also use the F14 key when creating a new application to detail the individual authority by profile.
DBU checks for physical file changes when an application is loaded. If the physical file has changed, DBU issues a message, "Level Check error on File, New file layout has been retrieved". This application should be recreated or the results may be unpredictable. DBU will format the screen for you and lets you go on, but the application will not appear the same.
Figure 2.32 is an example of the Help Menu. 
Figure 2.32
This menu is designed to help the user get into the online help without having to go in through an individual field. Options 1-4 take you directly to a major unit of DBU documentation. Option 5 shows the information about the release level your copy of DBU is on. Option 6 has the information on ProData's name, address and phone number. Option 7 displays all of the Tips of the Day, notice you can also print these with F14.
Open Query is an IBM function that DBU now incorporates to pull certain parts or certain records of files into DBU without pulling the whole file. There are three parameters that need to be filled in after taking option 7 from the DBU Menu or keying in DBUQRY and pressing enter. These parameters are: 
Figure 3.1 After keying in the above parameters or using the generic* names, use the roll keys to display the following six screens. 
Figure 3.2 
Figure 3.3 
Figure 3.4 
Figure 3.5 
Figure 3.6 
Figure 3.7 After keying in the information on the preceding screens, press enter. You may then pull that part of the file into DBU. For more information on how to use specific fields from Open Query, use the extended help feature [F1] from any field.
**Note: When using Open Query from anything other than the DBU Menu (i.e. IBM's command for Open Query), screen 5 on the Sequential Only field should be *NO, screen 6 on the Performance Optimization field should read *FIRSTIO. These two fields will make the query run more efficiently. When using the DBU Open Query from the DBU Menu or the DBUQRY command, these fields are not changeable from the default.
The Display Journal is used so that you can see journal entries broken down into fields instead of many long lines of unbroken data. Once you have keyed an 8 on the command line from the DBU Menu or keyed in DBUJRN, press enter and the following parameters will appear: 
Figure 3.8 There are two screens that will display on your screen. 
Figure 3.9 
Figure 3.10 The two previous screens are used to input information to narrow down the part of the journal that will be coming into the DBU screen. For more information on how to use the Display Journal, use extended help [F1] on any individual field that you may have a question. Normally, the journal files are very hard to read. Now that DBU incorporates the journaling function, you can see your journal broken down into fields instead of unbroken lines of text. Using DBU to look at the journal is as easy as using the above screens to display the journal and then pressing enter to take this information and bring up the DBU screen with the journal information in it. Or you can simply use the main DBU prompt and key in the name of the journal, the library and on the DBU Type field, key in *JRN. This will also bring up the journal in easier to read broken down fields.
This command is supplied with DBU to allow individual profiles to have different authority levels. It also controls the operating environment for DBU. User profiles may be Added, Updated, Deleted or Displayed. To add a profile, press F6, and fill in all the options. For any other operation, fill in the blank in front of the profile with an option of 1=Update, 4=Delete or 5=Display. One user profile must exist for DBU to operate. If no user profiles are set up in DBU, *PUBLIC will be added by DBU. From a command line, key in DBUAUT. This will bring up the Update DBU User Authority/Options screens. DBU is shipped with only the *PUBLIC profile, the others shown are for reference only. 
Figure 4.0 To Add/Change a User To create different authority for different users, press F6. The following add screens will appear, with all the defaults the same as filled in. To change a user profile, key in the Profile name and hit Enter.
Figure 4.1 
Profile This ten character field is used to enter the user profile of the person that is authorized to use DBU.
Allowable Modes These fields are to control the ability to update a file. For each of the update modes, enter a ‘Y’ if the user profile will have the authority to that update mode. Enter an ‘N’ if they will not have the authority. This authority will not override the system authority if the user does not have authority to a file.
Change in Unformatted Multiple Mode Controls the ability to change records in an unformatted multiple mode.
Upper/Lower Field Text Conversion This authority refers to field text which is displayed while working in DBU, and F4=List Fields is pressed followed by F10=Field Text. This text comes from your DDS, but the case in which it is displayed may be changed by using this default. Enter a ‘Y’ and the field text will automatically be converted to upper & lower case, a 'N' will leave the field text in the format in which it was created.
Support SQL Limits on Binary fields Controls binary field limits for SQL created files.
Change Log This option is used to determine whether an audit trail is to be printed each time a change, add, or delete is made to the file being accessed. ‘Y’ will print an audit trail and a ‘N’ will not print an audit trail. Output Queue Identifies the output queue to be used for the audit trail. If no printer is indicated, the default for the job is used. Library Enter the library which has the definition for the output queue being used for the audit trail.
Copy output log to Database file Entering a Y in this field will copy the Audit Log spoolfile to a database file (DBU70/ DBUSPLOG), each instance will produce a separate member in this file.
Print Only changed fields or ALL fields Entering a C will print only changed fields, entering an A will print all fields for the record.
Confirm Msg (Y/N)
Exit This default controls whether a confirmation screen comes up when F3=Exit is pressed. A ‘Y’ will cause the confirmation screen to appear. An ‘N’ will exit directly out of DBU.
Add This default controls whether a confirmation message comes up when you add a record. A ‘Y’ will cause the confirmation message to appear. An ‘N’ will add the record without bringing up a confirm message.
Change This default controls whether a confirmation message comes up when you change a record. A 'Y' will cause the confirmation message to appear. A 'N' will make the change to the record without bringing up a confirm message.
Command Line Access This authority controls whether a command line maybe used by a profile while in DBU. A 'Y' will allow command line access an 'N' will not allow command line access while in DBU.
Allow DDS Export This authority controls whether a user profile may export DDS. A 'Y' allows the export of DDS. A 'N' will not allow the user to export DDS.
Output Query This authority controls whether a user profile is able to output the results of a query to a file. A 'Y' will allow the creation of an output file. A 'N' will not allow the creation of an output file from a DBU query.
Reactivate Deleted Records This authority controls whether a user profile is allowed to reactivate deleted records. A 'Y' will allow the reclamation of deleted records. An 'N' will not allow a deleted record to be retrieved.
Display Tip of the Day during Trial period A’Y’ will display the Tip of the Day for the first 30 days using DBU. An ‘N’ will not display the Tip of the Day.
Figure 4.2 
Mode Determines the initial update/display mode of the DBU screen when DBU is invoked. ‘A’ will bring up the screen in Add mode. ‘C’ will bring up the screen in Change mode. ‘D’ will bring up the screen in Display mode. This update mode can be changed while in DBU with a command key, only if the user has the authority to that mode.
Columns Determines the number of columns used to display the fields in a record. Up to three columns may be used. If the number of fields in the file exceeds the number which may be displayed on one screen, the roll key is used to access the rest of the fields.
Format Determines the number of records to appear on the display at one time. An ‘S’ will cause a single record to appear on the screen. An ‘ M’ will bring up the initial screen with multiple records.
Size Determines the size of the display screen used to format the windows used when multiple files are opened. Only applicable if the display station is 132 characters compatible. Otherwise, 80 is always the default.
Highlight Change Field A 'Y' entered in the 'Change' field will cause the field that the cursor is on to be highlighted. The field will only be highlighted in change mode.
Highlight Key Field(s) A 'Y' will cause the keys of the logical/join files to be highlighted in all modes.
Highlight Null data A’Y’ will cause null fields to be highlighted in all modes.
Field Headings These fields are used to determine which headings will be displayed for the fields.
TXT=Text Text defined for the field in DDS
FLD=Field Name Field Name from the file
BTH=Both The text field from the DDS will be displayed with the field name from the file overlaying the last positions of the text. For a 132 column screen, BTH is valid for 1 & 2 column data display. For an 80 column screen, BTH is valid only if one column of data is displayed.
ALS=Alias An alias will be displayed.
TXT=Text Text defined for the field in DDS
FLD=Field Name Field Name from the file
HDG=Heading Heading defined for the field in DDS
ALS=Alias An alias will be displayed.
Default Cursor Location The cursor may be set to position at the first field on the record or on the control field.
Display F=Function Keys Each DBU screen has a number of command keys (F=) on the bottom of the screen. The keys may be removed by entering a 'N' in this field.
Figure 4.3 
Upper/Lower Case Default Determines whether upper or lower case letters are used as the default, when keying into an alphanumeric field.
Use Validity Checking DBU will normally use the validity checking defined in DDS, to validate the data on entry. Use this field, if for some reason, you need to set off this validity checking.
Allow User to change KEY fields Entering a ‘Y’ will allow the user to change key fields.
Data Area Processing This authority determines the user’s ability to update a dataarea.
D - the user may use DBU to only Display the dataarea.
U - the user may use DBU to update and display the dataarea.
N - the user may not update or display a dataarea.
User Space Processing This authority determines the user’s ability to update a user space.
D - the user may use DBU to only Display the user space.
U - the user may use DBU to update and display the user space.
N - the user may not update or display a user space.
Protect Date Editing 'Protect Date Editing' only applies to fields which are defined as 'Date/Time Stamp' fields. Ordinarily, these fields will be displayed with their date separators embedded in the field, and the date separators do not have to be keyed. All date and time stamp fields must be written to the data base with the correct separators. DBU will protect these separators, during data entry, so that mistakes aren't made. BUT, some emulators don't support this function. So Protect Date Editing may be turned off, and it is the user’s responsibility to correctly key the date/time stamp.
Y - Protect date/time stamp separators.
N - Date/time stamp separators are the responsibility of the user.
Process Null Values If the fields in a file are created with null capability, but the programs which are used to access them are created overriding the null capability, the programs will blow up if null values get in these fields. This could happen using DBU, for instance. In order to prevent this from happening, DBU will write nulls or blanks to the fields that are null capable.
Y - Write null values to the field if the field is blank or zero on input.
N - Write zeros or blanks to the null capable fields.
Date Format/Add 'Date Format/Add' only applies to fields which are defined as 'Date/Time Stamp' fields. If DBU is in ADD mode, all date and time stamp fields are preloaded with the current date/time stamp or a null date/time stamp based on this field. They may be changed on input.
CUR - Current Date/Time Stamp
NUL - Null Date (010101) Time Stamp (????)
Convert JDE date will convert the ‘Data Item Class…DATEW’ fields to an editable *USA format. DBU will also convert the date back to the original format when the user makes a change to the date.
Edit JDE numeric field length ‘Y’ will allow the user to edit numeric field length attributes.
Figure 4.4 
# of records to search Enter the # of records to be searched at one time. After this number of records has been reached, the search will stop, and wait for further action. # of records to search before issuing progress message Enter the # of records to search before being informed of the progress. i.e. If 5000 records are to be searched and this parameter is 100, then every 100 records a message will be displayed showing the total number of records searched. Allow replace option Determines whether the user may use the replace/delete option of a search. If this parameter is 'N', the bottom (replace) portion of the Search/Replace screen does not appear.
Produce RRN report of records updated A list of the RRN of all records changed is generated as a default. To suppress this list, change this parameter to 'N'.
Prompt for Submit to Batch This authority determines the user's ability to prompt the submit job when submitting the job to batch.
Job Queue/Library Identifies the Job Queue/Library to be used for the submitted job. If no job queue is defined the default is obtained from the Job Definition Attributes of the current job.
Output Queue/Library Identifies the Output Queue/Library to be used for the audit trail spoolfile from the search. If no output queue is defined the printer device from the Job Definition Attributes of the current job will be the default.
Figure 4.5 
It is possible to have up to 4 files open at the same time in DBU, using DBU Windows. These windows are created for each file when F18=New File is pressed, while in DBU.
You may design your own preferences. If you press Enter without filling in any of the fields, the program will fill them in for you. The windows may be redefined on the fly after opening a new file.
Outline of Windows
Each window can be outlined by any of the EBCDIC characters. Just fill in the characters you prefer for the corners and borders.
Position/Color of Windows
Row, Column, Width, Length, Color - These five attributes are used to determine where the window will appear on the screen. Just press Enter and the defaults will be filled in. Otherwise, the following information will allow you to key in your own values. There are two screen sizes to define. The 132 column display is only valid if the terminal using DBU supports 132 character width displays.
Row - the horizontal coordinate for the top of the window.
Column - The vertical coordinate for the left side of the window.
Width - the number of positions from the left corner to the right corner.
Length - The number of lines from the top corner to the bottom corner.
Color - Establishes the color that you would like for the borders for each of the windows. The active window will always show as white. Valid colors are B=Blue, G=Green, P=Pink, T=Turquoise and Y=Yellow.
Once the information above is keyed onto the screen, press Enter. A message will appear at the bottom of the screen, "Verify and Press enter to Update". After you press enter a second time, a message will come up saying "Profile Added" or "Profile Changed", etc.
The screens below show 2, 3, & 4 windows open. The shipped defaults were used in the design. All functions available in single file mode, are available for files in multiple windows. 2 Windows 
Figure 4.5c 3 Windows 
Figure 4.5d 4 Windows 
Figure 4.5e
Figure 4.6
This screen allows you to map the function keys for the profile. Typing the appropriate F key number will execute the function to the right of the key number.
Function Command Key Pull-Down Menu Location
Help F1 -
Display/Nondisplay Keys F2 Extra Menu, Option 7
Exit F3 File Menu, Option 9
List Fields F4 File Menu, Option 4
Refresh F5 Mode Menu, Option 5
Set Key F6 File Menu, Option 8
Backward F7 Extra Menu, Option 4
Forward F8 Extra Menu, Option 3
Character/Hexadecimal Display F9 Format Menu, Option 3
Action Bar F10 -
Display Modes F11 Mode Menu, Options 1-4
Cancel F12 -
Columns F13 Format Menu, Option 1
Data Base Relations F14 File Menu, Option 7
Define Search/Search & Replace F15 Search Menu, Option 1
Search F16 Search Menu, Option 2
Replace F17 -
New File F18 File Menu, Option 1
Page Left F19 Extra Menu, Option 5
Page Right F20 Extra Menu, Option 6
Single Record/Multiple Records F21 Format Menu, Options 1 & 2
Next File F22 Window Menu, Option 1
Window Max F23 Window Menu, Options 3 & 4
More Keys F24 -
Suspend File - File Menu, Option 2
Close File - File Menu, Option 3
Members - File Menu, Option 5
Formats - File Menu, Option 6
Formatted/Unformatted Columns - Format Menu, Option 2
Screen Display Option - Format Menu, Option 4
Window Sizing - Window Menu, Option 2
Audit Log - Extra Menu, Option 1
Print Current Record - Extra Menu, Option 2
Command Line - Extra Menu, Option 8
DBU Applications - Extra Menu, Option 9