Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Database

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 itself. On a single database system (only support until V5R2 IASPs) the database name defaults to the system name.

  • The Libraries, Database Navigator, and SQL Performance Monitor folders are now also under the database name folder.

  • New folders to access transaction level detail information for (jobs/threads) implementing commitment control cycles:

    - Database Transactions (single system commitment control)

    - Global Transactions (multiple system commitment control)

  • Improved Database Navigator (shows database objects inter-relationships) graphical displays.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint