O'Reilly logo

DB2® SQL PL: Essential Guide for DB2® UDB on Linux™, UNIX®, Windows®, i5/OS™, and z/OS®, Second Edition by Paul Yip, Fraser McArthur, Michael Gao, Raul Chong, Drew Bradstock, Clara Liu, Zamil Janmohamed

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 11. Deploying SQL Procedures, Functions, and Triggers

In this chapter, you will learn

  • Several methods for deploying SQL procedures

  • How to deploy functions and triggers

  • The pros and cons associated with each of the various deployment methods

  • Considerations for deploying and working with SQL procedures

Deployment of SQL procedures is the task of moving SQL procedures from one environment to another—for example, moving SQL procedures from a development environment to a test or production environment. This chapter discusses several ways in which this can be done. The method chosen to deploy your procedures will depend on your requirements.

The DB2 Development Center can be used to deploy SQL procedures on the following platforms: LUW, iSeries, and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required