Database

The Database folder has significant enhancements with some of the functions moved to different or new sub folders. New and enhanced functions include:

  • Support of the, new with V5R2, set of industry-standard SQL functions.

  • SQL Assistant: This is the long awaited Navigator prompting for SQL statement syntax support. This is a superset of the prompting support also available through the OS/400 Start SQL (STRSQL) command interface.

  • Added support for multiple databases on the same iSeries. This is implemented using the V5R2 inclusion of OS/400 library-based (QSYS.LIB) objects within an Independent Auxiliary Storage Pool (IASP). The context menu option for Run SQL Scripts is now selected on a database name folder instead of the Database folder ...

Get Managing OS/400 with Operations Navigator V5R1 Volume I: Overview and More now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.