DBU 7.0 GUI USER GUIDE

DATA BASE UTILITY

This software system consists of computer software and documentation. It contains trade secrets and confidential information which are proprietary to ProData Computer Services, Inc. ("ProData"). Its use or disclosure in whole or in part without the express written permission of ProData is prohibited.

This software system is also an unpublished work protected under the copyright laws of the United States of America. If this work becomes published the following notice shall apply:

INTRODUCTION

Welcome to ProData Computer Service's Data Base Utility 7.0 GUI 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. It can be used to access journal receivers, data areas and user spaces. You can create DBU applications to act as programs to access your data. There are thousands of ways to use DBU, and you will find new uses for DBU as you go.

This release operates on Microsoft Windows 95 and later or IBM'S Network Station with TCP/IP connectivity. The interface was developed using JAVA and the JAVA virtual machine is distributed with the software.

Minimum requirement is a Pentium III with 128M RAM.

We recommend a Pentium IV with 256M RAM for optimum performance.

DBU requires 45M of disk space.

Access to the files and features follows the standards used in the standard windows GUI interface.

NAVIGATION SCREEN

The first screen that appears when DBU 7.0 is started is displayed below.

This screen is composed of the following parts:

• The Dialog Box, which allows the immediate opening of an object.

• The Header, which defines the version of DBU being used. In this case, DBU 7.0

• The Menu Bar offers a set of drop down menus for using DBU

• The Tool Bar, which allows immediate action by clicking on an icon

• The Display Area, which is used for navigation through libraries and files.

• The Status Bar, at the bottom of the screen, shows any errors encountered while using DBU.

Dialog Box

Values for Library:

• *LIBL

• *CURLIB

• *USRLIBL

• *ALLUSR

• *ALL

Values for Type:

• *FILE

• *JRN

• *DTAARA

• *DTAQ

• *ALL

To prevent this dialog box from appearing when DBU is started, un-check Show this dialog on startup in the dialog box.

Menu Bar

File

Open an object

Configurations to control DBU. See the DBU Configuration topic in this document.

Exit DBU

View

Tool Bar – toggles the Tool Bar on/off the screen.

Status Bar - toggles the Status Bar on/off the screen.

Web Update Log - shows any errors that have occurred during a Web Update.

Turn Tracing On/Off - shows the status of the Trace log. This log may be set using the Config... on the File menu above. It is only used in the case of problem determination, by a ProData technician.

Tools

IFS Update - Execute IFS Client GUI Update.

There are two ways to execute the IFS update.

1. Configure DBU/client to automatically check the IFS for updates each time the client is started. Open the Configuration dialog, select the Updates tab, and select Check IFS for update on startup.

2. From the Tools menu, select IFS Update. In both cases, DBU/client compares the IFS update and the current version to determine if an update is necessary. If so, the new files are transferred to the PC and DBU GUI shuts down. Changes take effect upon subsequent startup.

Web Update - Download a new version to DBU70 and IFS on the iSeries.

Web Update is a DBU client feature that allows the user to conveniently update DBU/iSeries and DBU/client executables from a PC. There are 3 steps to using Web Update.

1. Designate an update store

2. Execute Web Update

3. Execute IFS Update for each installed DBU/client.

Designate an update store

The update store is an IFS directory on a specified iSeries machine where DBU keeps the latest version of the DBU/client. The first system added to DBU (on startup for the very first time) is designated as the update store. The update store can be changed on the Updates tab in the Configuration dialog. IMPORTANT: To keep the DBU/client versions in synch, each DBU/client must designate the same update store.

Execute a Web Update

• From the Tools menu, select Web Update.

• The DBU Web Update dialog appears, listing each system that is configured in DBU/client, the IP address, the release date of each system, and a check box to select which systems are to be updated.

• Once the systems to be updated have been selected, click the Update button.

• A dialog appears to indicate the completion of each task in the update process. These tasks are:

o Contacting ProData – establish contact with ProData’s update server via the Internet.

o Saving objects – the update server saves all DBU objects newer than the release date of the local AS/400.

o Receiving save file – transfers the save file from the update server to the local AS/400.

o Restoring objects – restores saved objects to the DBU70 library.

o Receiving client update – transfers DBU/client updates to the designated “update store”.

o Posting client update to IFS – updates the DBU/client version on the PC.

Execute IFS Update There are two ways to execute the IFS update.

1. Configure DBU/client to automatically check the IFS for updates each time the client is started. Open the Configuration dialog, select the Updates tab, and select Check IFS for update on startup.

2. From the Tools menu, select IFS Update.

In both cases, DBU/client compares the IFS update and the current version to determine if an update is necessary. If so, the new files are transferred to the PC and DBU shuts down. Changes take effect upon subsequent startup.

Help

Help Topics - Brings up on line documentation for DBU 7.0 GUI.

About DBU - Shows the current installation level of DBU GUI on the PC and the information needed to contact ProData.

Tool Bar

Open a File

DBU Configuration - See the DBU Configurations topic.

On line Help – Brings up on line documentation for DBU 7.0 GUI

CHANGING THE LIBRARY LIST

Since only the files in the currently active library list may be accessed through the tree structure, the user may want to change the library list to access files. Please note that any file in any library may be accessed (except for authority exceptions), using the Open File options on the Menu Bar and Tool Bar as well as the start-up dialog box.

To change the library list, from the navigation screen below:

Right click on the system name to get the dialog box.

Move the cursor over Library List to see the options.

Click to choose one of the predetermined library lists (*LIBL *CURLIB, etc.)

**OR**

Click on Change Library List to get all of the libraries currently in the list, as shown below.

To add a library to the library list, click on to add it.

To remove a library from the library list, click on the library in the library list then click on to remove it.

To move the library in the library list, click on the library then use to move the library up or down within the library list.

For DBU70 to function properly the DBU70 library must be below the QTEMP library in the library list.

Click OK to complete the library list changes that have been selected.

Selecting a DBU Application

DBU Applications are a way of defining the way a file is to be accessed, (what logical files, fields, arrangement of fields, etc), and then saving those preferences as an application. DBU Applications must still be created through green screen DBU, but can be accessed through GUI. Right Click On the iSeries system name to get the dialog box, and then click on DBU Applications and a list of all existing DBU applications will be shown.

Click on the desired application then click on Select to run the application.

DBU Configuration

Access the DBU configuration screens from the file menu on the Menu Bar. DBU configuration allows a user to:

• Edit the systems to be accessed by DBU

• Change the default screen presentation in DBU

• Turn the audit log on/off

• Indicate where downloaded DBU updates reside

The top half of this window is used to add/edit/delete other iSeries systems to the DBU screen.

To add a system, click on Add, and the following pop-up window will appear.

It may be necessary to get the IP or Host Name from the System Administrator. The Descriptive Name is whatever the user wants it to be, so long as it is meaningful.

To edit or delete, first click on the desired system to be worked on and then click on Edit or Delete. A pop-up window will allow the user to edit.

After editing click on the Add button to confirm the changes.

The bottom half of the window configures the defaults and controls the DBU updates.

Click on the Defaults tab to set up default values for DBU.

See the following table for configuration information.

Format	Determines whether the screen comes up in single or multiple mode. If *DBUAUT is left as the default, the system checks the DBU authority file to determine whether it is single or multiple format which is used.
Mode	Determines if the screen comes up in Add, Change or Display mode. If *DBUAUT is left as the default, the system checks the DBU authority file to determine what Mode is used.
Records To Display	DBU uses this number to determine how many records to display at a time in multiple record mode. The max number is 50.
Print Audit Log	DBU has the ability to print a log of all operations performed to the file in DBU. This option can be turned off here, or the option can be controlled by the DBU Authority file.
View Tool Bar	This is a toggle to remove or add the Tool Bar to the Navigation Screen.
View Status	This is a toggle to remove or add the Status Bar at the bottom of the Navigation Screen.
Trace ON	This is a toggle to start tracing the GUI statements if there is an error. Most generally the user will not use this unless directed to by a technician.

Click on the Updates tab to name the system to which updates will be downloaded.

If only one system has been defined, the Store update on box will not be active, and the value in it cannot be changed. In the preceding figure, the Store update on box is “grayed out” because only one system has been configured for DBU. With multiple systems configured, Store update on can be opened as a drop down box where a user can select the system where the updates from the DBU downloaded file, will be stored. This is important, because if there are multiple users in the shop, then only the first person needs to download the updates. The rest will be automatically updated from the IFS if the Check IFS for update on startup box is checked.

Click on the JD Edwards tab to configure for J.D. Edwards data conversion.

Click on the J.D. Edwards format check box to enable. Then use the Environment pull down box to select the desired J.D. Edwards environment. Click on OK to apply.

ACCESSING FILES w/TREE STRUCTURE

To access a file (or any of the other objects that DBU can access) through the tree structure, click on the + sign beside any system name on the Navigation Screen. All the libraries on that system, which the user has authority to, will be listed. Click on the + sign besides any library and all the objects that are accessible by DBU will be listed.

In this case DBU70 was selected and all the various objects which can be accessed by DBU appear under the library. Clicking on the + sign at this level will bring up all the objects of that particular type, as shown above. Or click on the folder and all the objects of that type will appear on the right frame.

From here right click on the file name and select Edit

*or*

click on the + sign on the object level to bring up the various information that can be accessed for each file. This second option is shown below.

• Fields - will show the all the field names, the field type the length of the field and the associated text.

• Logicals - will show all the logicals over the file, if it is a physical. Double clicking on the logical name will bring that file up for accessing.

• Members - will show all the members in physical or logical files.

As an example of working with a file, right click on file name DBPDEMO then click on Edit.

The file is now ready to work with.

ACCESSING FILES w/Navigation Bars

Open a file using the Menu Bar

• Click on File on the Menu Bar

• Click on Open to get a Dialog Box

• Fill in the parameters and click on OK to bring up the file

• This opened file will replace the current session if there is already one open

Open a file using the Tool Bar

• Click on

on the Tool Bar to get a Dialog Box

• Fill in the parameters and click on OK to bring up the file

• This opened file will replace the current session if there is already one open

DATA EDITOR SCREEN

After successfully finding the desired file, the initial DBU Screen will appear. For documentation purposes, five major sections of the screen below have been identified.

Header

Menu Bar

Tool Bar

Tab Panel

Record Display Area

DBU Header Bar

This area denotes the Session number, System name, Library name, File name, Member name and Format name being accessed.

DBU Menu Bar

DBU Menu Bar - File

Close all – Will close all open DBU sessions

Position To…

This is valid for logical files only. Shows all keys on the logical file and sets DBU to point at the beginning of a specific key. Fill in the key(s) press OK. The file will be positioned at that key, or the next higher key if that key does not exist.

RDR – Retrieve Deleted Records

"RDR" is a toggle switch to set 'on' or 'off' the displaying of deleted records as they are encountered in the file. The records that are deleted appear highlighted in yellow as they are encountered. There will be a Reactivate button on the bottom of the screen; click on it and the record will be reactivated, and the next record in the file will be displayed. RDR is only valid if the file is a physical that is not keyed.

Config…

Configure DBU. See the DBU Configuration topic in this document.

Click on Print and the following dialog box appears. PC printer selections will be printed on the user’s default printer. For iSeries/AS400 selections the print out of the record goes to the OUTQ defined by the user job, or can be overridden to the OUTQ defined in DBU authority. When printing to a PC while in multiple record format mode, the number of records printed will be equal to the Records to display value selected in DBU Configuration.

Exit – Exits from the current DBU session

DBU Menu Bar – Edit

Use Copy and Paste just as in other windows applications to duplicate data.

DBU Menu Bar - View

The Toolbar and Status bar are toggle switches which allow the tool bar and the status bar (message bar at the bottom of the screen) to be removed from or restored to the screen.

DBU Menu Bar - Format

Preferences… - Controls the layout of the screen fields, and the reading of the formats (see DBU Preferences below)

Single/Multiple - The screen may be toggled between Single or Multiple record mode

Character/Hex - The records displayed may be toggled between Character or Hexadecimal format

DBU Preferences

Fields Preferences

The Fields Preference allows the user to:

• Position the file to a particular field in the file

• Use column heading or text on the fields display

• Choose a particular format in the file to display

• Choose/move the fields to be displayed and indicate whether they can be updated/duped or are case sensitive

There are 3 pull down boxes at the top of the window

• The Position to Field box will position the screen to the first or last field in the record

• The Description box selects the source for the field description.

Text – the text of the field

Field Name – the field name

Both – in single record format only, the text description and the field name are both displayed

Alias – a name the user creates

• The Format box is for logical files only, and selects the fields that are in one particular logical format

The next portion of the window is used to make changes to the ways fields are presented and handled on the screen. All the fields in the file are initially shown.

Text - text defined for the field in DDS.

Field Name - name of the field as described in DDS. To move a field from its current position on the screen, click on the field and use the Up/Down keys to position the field on the screen.

Key Sequence - shows the keys in the file, numbered from 1 (highest key) to nth (lowest key).

Select - is a toggle to either select a field for the screen, or to not show the field on the screen.

Display Only - is a toggle to select whether a field may be updated or not.

Auto Dup - is a toggle to select whether this field may be duped using the dup key.

Upper Case - is a toggle to select whether only upper case characters may be keyed, or whether mixed case characters are allowed.

The rest of the fields are definition only:

Type - defines the field type, whether numeric, alpha, etc.

Length - the length of field.

Dec - if a numeric field, this is the decimal positions.

Loc - position in the file of the starting character of the field.

When all the desired changes have been made, click OK to apply the changes.

Sequencing the fields on the screen.

To arrange the fields on the screen in a different order, select the field by clicking on it and then use the up and down arrows to move the field to another position.

Import

Use the Import button to define a DBU application which will allow the user to work with a file that is not externally described as though it is externally described. Select Source File to pull the field descriptions from an RPG source file. An RPG program must exist which has “I” specs defining the file. Select Physical File to pull the field descriptions from an existing physical file.

Import – Source File selected

• Source File – the name of the source file that contains the RPG program which has “I” specs defining the field layout

• Library – the library where the source file resides

• Source Member – the member of the source file

• RPG File Name – the name of the RPG program with internal “I” specs defining the field names

• Replace Existing File –

Checked – DBU will present the file on the 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.

Not Checked – 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.

Import – Physical File selected

With this function a physical file description can be used to separate data in a data area into fields.

Export

Use the Export button to create/change the physical file member in a source file from the fields selected on the field selection screen. The fields will be ordered by the sequence number on the field selection screen. If no fields are selected, all fields will be copied. This may be used two ways:

1. Create source specs for an S/36 described file.

2. Create new source member for an existing externally described file

Caution: The default source member name is the file name of the externally described file. If using this method, change the source member name and/or the source and library name or the original physical file specification will be replaced

• Source File – the name of the source file which will contain the physical file specifications to be created or changed.

• Library – the library where source file resides.

• Source Member – the physical file member to be created or changed.

• Replace Existing Member –

• Checked - replace existing file specifications with fields selected on screen.

• Not checked – the selected field will be added to the end of the existing physical file specification in the source member.

• Member Text –

*SAME - do not change the 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 – the name to be used for the record format if it is different from the physical file name.

Create Field

The Create Field button can be used two ways:

• 1 Breakup fields into smaller fields if they are not packed.

• 2 Combine contiguous fields into larger fields.

Click on the Create Field button and the following screen appears.

Fill in the boxes:

• Field Name - the name of the new field, must be unique in the file

• Type- pull down box for field type

• Length- total length of new field

• Dec- number of decimals, if created field is numeric

• Loc- is the starting position of the first contiguous field to be combined

• Field Text- New text for the created field

• Select- Toggle switch to select fields, if the toggle is off, the field will disappear when Preferences screen is exited

• Display Only- Toggle switch to make a field display only, or to allow updates to that field

• Auto Dup- is valid in add mode, when the Auto Dup toggle is checked on a field, the last value of that field will appear on the screen when a new record is to be added

• Upper Case- Toggle switch between upper case and mixed case entry into a field. If the toggle is checked, then only upper case may be keyed into these fields

When all the boxes are filled in, press Add, and the new field will appear at the top of the Preferences screen. Create as many fields as desired. New fields will appear in order as they are created and will have a * in the field type to identify which are the created fields. The new fields can then be selected for a DBU application and all applicable DBU operations will apply. Fields are created for applications only. The source member of the physical file will not change.

Remove Field

The Remove Field button will work only for fields that have been created using the Create Field button. If no fields have been created the Remove Field button will be inactive. To remove a field, click on the field to be removed to highlight it and make the Remove Field button active, then click on Remove Field.

Sort Keys

The Sort Keys button is used with keyed physical and logical files. Pressing Sort Keys will reorder the displayed fields, placing the keyed fields at the top in key sequence order.

Headings Preferences

The Headings preference displays the column headings for each field.

Formats Preferences

The Formats preference allows the user to select which format(s) of a multiple format logical file is to be worked with. Select the option wanted, and press the OK button to return to the DBU process.

DBU Menu Bar - Mode

This defines the action that is to be taken on the records in the file. The modes are Display, Edit, Add, Delete and Refresh. When Display, Edit or Add is chosen, the screen remains in that mode until changed. Delete functions only in single record format.

• Display puts the file in Display mode. No updates or deletes can be performed.

• Edit puts the file in Edit mode. If a field is marked for display only it cannot be edited. Click on the field to be changed, key over the data and press Enter. Note that the Update button at the bottom of the screen is now active. If any other fields are to be changed, do so now. Click on the Cancel button to return all the changed fields back to their original values. Click on the Update button to save the changes. Update also positions to the next record in the file.

• Add puts the file in Add mode. The field names are shown but the data fields are empty. Key in the data for the first field and press Enter. Note that the Update button at the bottom of the screen is now active. Enter data into the remaining fields. Click on the Update button to add the record to the file. Click on the Cancel button to clear all of the fields at once.

• Delete is used to delete a single record. A “Delete current record?” warning window will be displayed. No other DBU functions will work until a “Yes” or “No” answer is selected or the window is closed.

• Refresh is used to restore the screen to the original data, if the data has been keyed over but not updated.

DBU Menu Bar - Search

The parameters used to execute a search or a search/replace are defined on this screen. A subset of the data matching the search criteria can also be created.

Define Search – sets up the parameters to search/replace

Search – continues the Search function which has already been initiated in the 'Define Search'

Close Subset - Closes the file subset, if one was created in the Search function

Define Search

The parameters used to execute a search or a search/replace are defined on the following screen.

There are three parts to this screen.

Search - The top section of this screen is used to define the parameters to find the data

Replace - Defines the parameters to be used to update the file

Search Control - Parameters to control other aspects of the Search

SEARCH FUNCTION

Press Add, and the Search Entry dialog box appears.

Fill out the parameters and press OK. The Search/Replace screen will now contain this information. Continue adding selections, as wanted. Then press Search to find the record. 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 fields for this Dialog Box are defined below:

Operator - The user may have a multiple argument search to group or string the search criteria together.

• Blank - A blank operator signifies a new set of search criteria.

• 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 - A Relative Record Number, a Range, Entire Record or a Field Name can be searched on. Combinations of the four may also be used.

• *RRN = Relative Record Number - Select Relative Record Number to search using RRN as a base.

e.g.

• *STRPOS = Starting Position - Click on *STRPOS if a search is to be made from one position in the record to another.

e.g.

• *RCD = Entire Record - Click on Entire Record to search for decimal data errors or a specific data string within the record.

e.g.

• Field Name - Enter field name to be searched. If the field names are not known, position the cursor on the Field Name drop down arrow and right click. A list of fields in the file will be displayed, just click on the field wanted and continue filling out the Dialog Box.

From - Enter numerical starting position in the record. This is only if *STRPOS is requested.

To - Enter numerical ending position in the record. This is only if *STRPOS is requested.

Operation - User has a choice of logical expressions to apply to search parameters:

• Contains - Find record(s) that contain user-defined character string any where inside the defined search range.

• Equal - Find record(s) equal to search parameters.

• Greater Than - Find record(s) greater than search parameters.

• Greater Than or Equal - Find records(s) greater than or equal to search parameters.

• Less Than - Find records(s) less than search parameter.

• Less Than or Equal - Find record(s) less than or equal to search parameters.

• Not Equal - Find records(s) not equal to search parameters.

• Not Greater Than - Find records(s) not greater than search parameters.

• Not Less Than - Find record(s) not less than search parameters.

Value - The use of the Values parameter, gives the user almost unlimited ways of searching/replacing. Values are as below:

• field name - Enter the name of the field that contains the data to be used as search parameter. If the field names are not known, position the cursor on the Field Name drop down arrow and right click. A list of fields in the file will be displayed, just click on the field wanted.

• a 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 'from and to' positions instead of field names, put single quotes around the value (even if numeric).

• hex string - Enter a valid 'X' String (i.e. Zoned Decimal 09 = X'F0F9' and Packed Decimal 09 = X'09F').

• decimal data error - Select Decimal Data Error from the drop down, when searching for data decimal errors.

• When all parameters are filled in, click on Search to initiate the search function.

REPLACE FUNCTION

The middle 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.

Click on Add to bring up the Replace Entry dialog box.

Field Name - From the drop down box choose one of the following.

• *STRPOS

• *RCD

• *RRN

• field name - click on a field name

From - Enter numerical starting position of desired character string in the record, if range is requested.

To - Enter numerical ending position of desired character string in the record, if range is requested.

Value - 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 - Click Delete to perform a global delete of information in the Search area of the screen.

After all the Search and/or Replace parameters are filled out, the search is performed by clicking on the Search button. The search can be further controlled by using the additional parameters on the bottom of the search screen.

SEARCH CONTROL

The search is controlled by the bottom parameters of the Search/Replace screen.

• Format - defines the specific format to be searched.

• Submit to batch - is a toggle. If checked, then the DBU search is submitted to the JOBQ defined on DBU authority. The search will start at the currently displayed record location, just like an interactive search. DBU allows a user to create a search and then submit the search to batch. When performing a straight search in batch with no replace and Print Results is checked, the report will contain the record numbers that fulfilled the defined search parameters. When performing a search/replace in batch and Print Results is checked, the search/replace will take place and a full audit log of all changes made will be created. If performing a search/replace with Print Results not checked, a short report will be created showing which records were changed, but there will be no full audit log.

• Occurrences to process - prompts the user to define the type of search that is to occur. The user has three options:

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 Dialog Box

to initiate the replace function is displayed. Replace will change only the displayed record and then the search automatically continues from that record. Skip will continue the search without updating the record. Cancel returns the user to the primary DBU screen.

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.

Previous causes the search to search backward through the file. The next previous record to satisfy the search criteria is displayed. If a replace is defined, a Dialog Box to initiate the replace function is displayed. Replace will change only the displayed record and then the search automatically continues backward from that record. Skip will continue the search without updating the record. Cancel returns the user to the primary DBU screen.

• Output results to iSeries file – allows the user to create a new subset of the data or add/replace the data to an existing file. A dialog box prompts the user for the parameters for the file.

• Output results to PC file – Output to a PC requires that Create subset of records be selected. A dialog box prompts the user for the parameters for the file.

• Match Case - is a toggle. It prompts user to specify whether the search and replace function is to accept only those records that match with the same case of the defined search parameters or whether the case is to be ignored.

• Print Results - is a toggle. It prints an audit log of all records updated with the replace function. The printout goes to the OUTQ defined by the user’s job, or can be overridden to the OUTQ defined in DBU authority.

• Records to search - defines the number of records to process in a search. If a search is satisfied before this number is reached, the record will be presented on the screen. If the search is continued, the file will be searched 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. Continuing the search at this point, will start the search using the next record in the file and the same number of records will be searched.

• Create subset of records - Replaces the record(s) currently displayed with a subset of the records meeting the search criteria. The display format of the subset will be the same as the format of the initial display. A subset of the data, with the word Subset in the upper left hand corner, will be displayed. Any changes to this subset will update the file.

To create a subset of the data in a separate file, choose Output results to iSeries file or Output results to PC file before searching. To go back to the original search screen, click on Search on the Menu Bar, and then Define Search. De-select the Create subset of records, and click on Search again. The original screen will be returned.

• Include deleted records – Deleted records will be included in the search and highlighted in yellow. Deleted records cannot be included in a subset.

• & Progress Messages every

records - works in conjunction with 'Records to Search'. e.g. A user may want to search 10,000 records and have a message indicate when 500 records have been searched. This is effective when searching a very large set of records and there may be very few hits on the search criteria.

DBU Menu Bar – Tools

Print Record - Click on Print Record and the following dialog box appears. PC printer selections will be printed on the user’s default printer. For iSeries/AS400 selections the print out of the record goes to the OUTQ defined by the user job, or can be overridden to the OUTQ defined in DBU authority. When printing to a PC while in multiple record format mode, the number of records printed will be equal to the Records to display value selected in DBU Configuration.

Create Desktop Icon – Use this to open a file in DBU7.0 immediately from the desk top, or start a DBU 7.0 application from the desktop. The application must first be created using a DBU 7.0 “Green Screen” session on the iSeries.

For opening a file in DBU from the desktop

• Display the desired file in DBU, then, under Tools on the Menu Bar click on Create Desktop Icon.

•

• The message Desktop Link Created will appear in the Status Bar at the bottom of the screen, and an icon like this

will appear on the desktop.

For starting an application from the desktop

• From the initial DBU screen, right click on the iSeries system name that holds the desired application.

•

• Click on Dbu Applications. A window listing available DBU applications will pop up.

•

• Click on the desired application, then click on Select.

•

• The file and fields defined in the DBU application will be displayed.

•

• Under Tools on the Menu Bar click on Create Desktop Icon.

•

• The message Desktop Link Created will appear in the Status Bar at the bottom of the screen, and an icon like this

will appear on the desktop.

Export to PC – Export data to a PC file

• HTML – create the PC file in HTML format

• XML – create the PC file in XML format

• Comma – create the PC file in comma delimited format

• File: - Enter the name of the PC file in the text box

•

- Opens a PC window for selecting the folder where the file will be created

Click on OK to create and export the file to the PC.

DBU Menu Bar – Help

Online Help - Brings up on line documentation for DBU 7.0 GUI.

About DBU - Shows the current installation level of DBU GUI on the PC and the information needed to contact ProData.

DBU Tool Bar

Many of the functions on the Menu Bar are also on the Tool Bar. But there are actions that are taken using the tool bar that are not on the Menu Bar.

RRN

This field displays the relative record number of the record on the screen. It also can be used to position the file to a certain record number. This is valid only if the file is in arrival sequence, and not a keyed physical or logical file. Enter the RRN of the record to search for, and press Enter.

Position To…

RDR Toggle

RDR is a toggle switch to set 'on' or 'off' the displaying of deleted records as they are encountered in the file. The records that have been deleted are highlighted in yellow as they are encountered. There will be a 'reactivate button' on the bottom of the screen, click on it and the record will be reactivated, and the next record in the file will be displayed. RDR is only valid if the file is a physical that is not keyed.

Config…

This will display the DBU Configuration window. See the DBU Configuration section in this document.

First Record

Position the display to the first record in the file.

Previous Record

Position the display to the next previous record in the file.

Refresh

Refresh is used in Edit Mode to restore the screen to its previous content. e.g. A field is keyed into, but Enter has not been pressed. Refresh will return the screen to its original content.

Next Record

Position the display to the next record in the file.

Last Record

Position the display to the last record in the file.

Display Mode

This puts the file in Display mode. No updates or deletes can be performed.

Edit Mode

This puts the file in Edit mode. If a field is marked for display only it cannot be edited. Click on the field to be changed, key over the data and press Enter. Note that the Update button at the bottom of the screen is now active. If any other fields are to be changed, do so now. Click on the Cancel button to return all the changed fields back to their original values. Click on the Update button to save the changes. Update also positions to the next record in the file.

Add Mode

This puts the file in Add mode. The field names are shown but the data fields are empty. Key in the data for the first record and press Enter. Note that the Update button at the bottom of the screen is now active. Enter data into the remaining fields. Click on the Update button to add the record to the file. Click on the Cancel button to clear all of the fields at once.

Delete

This puts the file in Delete mode. A “Delete current record?” warning window will be displayed. No other DBU functions will work until a “Yes” or “No” answer is selected or the window is closed.

Preferences…

This controls the layout of the screen fields, and the reading of the formats (see DBU Preferences).

Single/Multiple Toggle

This option allows the user to Toggle between single record mode and multiple record mode.

Character/Hex Toggle

The records displayed may be toggled between Character or Hexadecimal format.

Define Search

This sets up the parameters to search/replace. See DBU Menu Bar – Search.

(not active) (active)

This continues the Search function which has already been initiated in the 'Define Search'. This will not be active (see right icon, above) until a search has been defined.

Help

This brings up on line documentation for DBU 7.0 GUI.

DBU Tab Panel

This bar works with file level attributes.

Data

Data displays all the field names along with the data in the fields.

Fields

Fields displays the file layout. The keys to the file, if any, are highlighted in yellow.

Relations

Data Base Relations are displayed. All of the access paths built over the physical file are listed. Left double clicking on the file name will bring up that file member, replacing the file in session.

Members

Members displays all the information on the members in the file. Left double clicking on the file name will bring up that file, replacing the file in session.

Formats

Formats displays all the information on the formats in the file. Left double clicking on the file name will bring up that file, replacing the file format in session.