Data Base Utility (DBU)

File Access Utility for the IBM AS/400

Optional Graphical User Interface (GUI) in Version 7.0

Overview

Data Base Utility (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. In the Green Screen version, just key in the command DBU followed by a file name and press "Enter". An easy-to-read, formatted screen will appear instantly.

The optional Graphical User Interface (GUI) in Version 7.0, developed by using Java, means that DBU may be used on any Windows platform or on any operating system with a compatible Java Virtual Machine (JVM). Using a TCP/IP connection, information from the database is presented in an Operations Navigator-like screen. Additionally there is an Operations Navigator database node allowing the DBU to "plug in" to IBM's graphical operations interface, which makes for easier operations management and display of library/file information.

DBU also works with logicals over multiple physicals with multiple members and join files (display only on join files). Members and/or formats may be selected from the logicals to be displayed or updated.

Records may be updated or displayed in character or hexadecimal mode. Keys may be set to access logical files and fields may be selected for display or update.

DBU Traditional Green Screen Display Screen showing 2 open files

DBU Green Screen Display

DBU Version 7.0 GUI Display Screen showing 1 open file

DBU GUI Display

DBU Features

Screen Features   Search & Replace
On-screen Help   Execute Interactively or in Batch
Refresh Screen   Boolean Logic for Arguments (and, or)
Highlight field cursor is in   Place Scanned data in output file
Command Line Command Key   Operators=GT LG EQ GE LE NE NG NL CT
Pull Down Menus   Scan for Decimal Data Errors(& Fix)
Mouse Capability   Global Delete
132 Column Support   Print Results of Search/Replace
Screen Formatting   Field Control
Single record, multiple columns   Enter Upper/Lower Case
Formatted/Unformatted Data Display   Upper/Lower Case by User
Column Heading in Multiple Record Format   Auto Dup Fields
Multiple File Display (4 files on one screen)   Display Field Attributes
Lock Fields on screen
Documentation Features   Navigation
Print Database Relations   Command Key Driven
Print File Layout   Fast Path Commands
Print Current Record   Menu for Access directly to DBU Features
Print Member List New Fast Commands - NEW in 7.0
Print Format List Map your own function keys - NEW in 7.0
New Print Options - NEW in 7.0
File Support   Other Great Stuff
Set Key   Display Journal Receiver by Fields
Floating Point Support   DDM Support
Open Query File Support   Electronic Customer Support with ECS downloads
"Quick Launch" icons for DBU support - NEW in 7.0   Access/Update data areas
Export database records to multiple formats - NEW in 7.0 DBU Tip of the Day - NEW in 7.0
National language support - NEW in 7.0
Authority by Users
Add, Change Delete by user   Customize DBU Windows
Replace function on Search   --Set size of windows
Change in unformatted multiple mode   --Set color of windows
Setup defaults for initial DBU Screen   Set screen file format & columns
Turn on audit trail by user   Set screen size

back to top

If you have any questions on DBU, contact details are given on our home page
Home