{"product_id":"sql-for-eserver-i5-and-iseries-9781583470480","title":"SQL for eServer i5 and iSeries","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eThis examination of how SQL functions on the iSeries considers at all possible environments, including the traditional 5250 green screen applications, the SQL scripting tool within iSeries Navigator, and Visual Basic. Database management from creation to deletion is covered in detail. Programmers will learn how to implement referential constraints and primary and unique key indexes, check constraints, and journal physical files. How to extend a database with user-defined functions and procedures and how the new GUI development tools provide simplified methods for running, debugging, and tuning SQL statements are also explained.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003eIntroduction      Ch 1: Interactive SQL      Ch 2: SQL in iSeries Navigator      Ch 3: Embedded SQL      Ch 4: Advanced SQL Examples      Ch 5: Optimizing SQL      Ch 6: Creating Databases Objects      Ch 7: Creating Functions      Ch 8: Creating Stored Procedures      Ch 9: Creating SQL-based Tools      Ch 10: Using SQL from within Microsoft Office          Appendix A: SQL Basics for Beginners","brand":"MC Press, LLC","offers":[{"title":"Default Title","offer_id":53188750737751,"sku":"9781583470480","price":54.15,"currency_code":"GBP","in_stock":true}],"url":"https:\/\/bookcurl.com\/products\/sql-for-eserver-i5-and-iseries-9781583470480","provider":"Book Curl","version":"1.0","type":"link"}