Stored procedures can provide major benefits in the areas of application performance, code re-use, security, and integrity. DB2Ar has offered ever-improving support for developing and operating stored procedures. This IBMAr RedpaperTM publication is devoted to tools that can be used for accelerating the development and debugging process, in particular to the stored procedure support provided by the latest and fastest evolving IBM product: Data Studio. We discuss topics related to handling stored procedures across different platforms. We concentrate on how to use tools for deployment of stored procedures on z/OSAr, but most considerations apply to the other members of the DB2 family. This paper is a major update of Part 6, qCool tools for an easier life, q of the IBM RedbooksAr publication DB2 9 for z/OS Stored Procedures: Through the CALL and Beyond, SG24-7604.Studio Installation options Shell-sharing with other Optim and Rational products X X Object and Data Management Create, alter, ... X Common DB support including DDL gen, analyze impact, compare and sync data, and property browser.
|Title||:||Data Studio and DB2 for z/OS Stored Procedures|
|Author||:||Paolo Bruni, Marichu Scanlon, IBM Redbooks|
|Publisher||:||IBM Redbooks - 2011-03-15|