Data Base Utility (DBU) - File Access Utility for the IBM AS/400

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.

 

Optional Graphical User Interface (GUI) in Version 7.0

 

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 Version 7.0 GUI Display Screen showing 1 open file

DBU Features

Screen Features
  • On-screen Help   
  • Refresh Screen  
  • Highlight field cursor is in   
  • Command Line Command Key   
  • Pull Down Menus   
  • Mouse Capability   
  • 132 Column Support
Search & Replace
  • Execute Interactively or in Batch
  • Boolean Logic for Arguments (and, or)
  • Place Scanned data in output file
  • Operators=GT LG EQ GE LE NE NG NL CT
  • Scan for Decimal Data Errors(& Fix)
  • Global Delete
  • Print Results of Search/Replace
Screen Formatting
  • Single record, multiple columns    
  • Formatted/Unformatted Data Display   
  • Column Heading in Multiple Record Format   
  • Multiple File Display (4 files on one screen)   
  • Lock Fields on screen
Field Control
  • Enter Upper/Lower Case
  • Upper/Lower Case by User
  • Auto Dup Fields
  • Display Field Attributes

 
Documentation Features
  • Print Database Relations   
  • Print File Layout   
  • Print Current Record   
  • Print Member List  
  • Print Format List  
  • New Print Options - NEW in 7.0
Navigation
  • Command Key Driven
  • Fast Path Commands
  • Menu for Access directly to DBU Features
  • New Fast Commands - NEW in 7.0
  • Map your own function keys - NEW in 7.0
File Support
  • Set Key   
  • Floating Point Support   
  • Open Query File Support   
  • "Quick Launch" icons for DBU support - NEW in 7.0   
  • Export database records to multiple formats - NEW in 7.0  
  • National language support - NEW in 7.0
Other Great Stuff
  • Display Journal Receiver by Fields
  • DDM Support
  • Electronic Customer Support with ECS downloads
  • Access/Update data areas
  • DBU Tip of the Day - NEW in 7.0
Authority by Users
  • Add, Change Delete by user   
  • Replace function on Search   
  • Change in unformatted multiple mode   
  • Setup defaults for initial DBU Screen   
  • Turn on audit trail by user
  • Customize DBU Windows
  • --Set size of windows
  • --Set color of windows
  • Set screen file format & columns
  • Set screen size

Contact Us

Professional Software Solutions Limited: © 2011 - Contact Us - Built by Software Assistance Website Design - Backsite