iSeries Navigator Database Tools
Sharon Hoffman
iSeries Navigator Database Tools
Beginning with V5R1, IBM has added significant new database tools to iSeries Navigator, the no-charge GUI interface to OS/400.
As of V5R2, the iSeries Navigator database tools include Database Navigator, which creates a graphical map of the relationships between database objects,
Run SQL, which lets you write and save SQL scripts, SQL Assist, which builds SQL statements interactively, Visual Explain, which analyzes query performance, and Generate SQL, which creates SQL statements based on a database object such as a physical file -- no DDS source code required.
In addition, you can use iSeries Navigator to modify file layouts, view data, specify triggers (both external and SQL), and define constraints.
This session illustrates the iSeries Navigator database support and discusses how you can use these functions to manage increasingly complex iSeries databases.
Sharon Hoffman began working with IBM midrange systems in 1981, and she is currently a senior technical editor for iSeries NEWS magazine. She focuses on emerging technologies such as Java and XML and is particularly interested in how these technologies integrate with existing iSeries applications. Her background includes extensive application development experience as a programmer, systems analyst, and consultant. She's also been involved with IT education for more than 20 years as an instructor, writer, and editor and is currently teaching several online e-learning classes. Sharon is a regular speaker at COMMON and other industry events.