Old versionsSee all
DBU offers an easy access to database objects for the IBM i5, iSeries or AS/400 and remote databases with a network connection to that system. When using DBU, the database object is presented in either 5250 display emulation (in 80 or 132 columns) or Graphical User Interface (DBU/GUI).
DBU presents information about the database object such as record length, record format, and text description in a readable format immediately after accessing the object using DBU, all while presenting the actual data in either single or multiple record display. Detailed information regarding field layout, database relations, key field access and a lot more is available with one keystroke once the object is accessed using DBU.
Additional features of DBU allow a sophisticated Search and Replace function with Boolean logic and operator extensions. Output from the Search and Replace can be global deletes, a subset of data, output file creation, global replacement of data and printed results. The Search and Replace can also be submitted for batch processing with one keystroke. A built in audit function allows for printed reports to be generated for any add, changes or deletes made using DBU. A more sophisticated auditing function is available with the use of the DBU Audit Journal plug-in for SOX requirements.
DBU allows for easy navigation of the database object through the use of fast path commands entered into the control field of the original display. Using the control field you can move from the top of the file to the bottom or to any relative record number in between with just a few keystrokes. DBU also allows you to have up to four files open at any time with all files presented on the screen at the same time or individually.
DBU offers a menu system that can give seasoned professionals access to the DBU commands (DBUMNU). Some of these options include DBUQRY (OPNQRYF), DBUAPP (DBU Applications can provide a quick method to design database maintenance routines), DBUJRN (DSPJRN), DBUSPC (User Space), DBUDTA (Data Area) and DBUQUE (Data Queue). Another option available with DBUMNU is DBURDB, this plug-in allows DBU access to remote databases from the system that DBU resides on.
DBU/GUI offers the same capabilities of the 5250 emulation but in a Windows friendly display. Using DBU/GUI you can also export data to the local PC in a variety of formats. Through the use of DBU Applications, desktop Icons can be created that can be accessed through a mouse click to perform data manipulation routinely. DBU/GUI does not use interactive resources on your system but instead uses the typical IBM Client/Server facilities to function in a batch processing method allowing for less resource overhead on busy systems.