INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

DB2 Application Development

STORED PROCEDURE DEPLOYMENT by sathyarams
Posted: 30 Dec 02

The CREATE PROCEDURE Statement for SQL Stored Procedures requires a C/C++ compiler for successful execution. Prior to Version 7.2,  DB2 required a compiler to be present on every system where the stored procedure will be deployed.  From Version 7.2,  it is sufficient to have the compiler on only one system for every OS platform. Two new commands were introduced to deploy the Stored Procedure developed/created on one system to another.   GET ROUTINE Command for extracting the stored procedure and PUT ROUTINE Command for deploying the Stored procedure on another machine.

GET ROUTINE INTO filename FROM [SPECIFIC] PROCEDURE routine-name

The Specific name of the routine is used when two procedures exist with the same name.  The specific name of a procedure can be obtained from the SYSCAT.PROCEDURES Table.

If ftp is used for file transfer, the binary mode should be used.

PUT ROUTINE FROM filename [OWNER new-owner] [USE REGISTERS]

The OWNER Name is used when the Stored Procedure is deployed in another instance with a different name.

USE REGISTERS uses the current values of CURRENT SCHEMA and CURRENT PATH Registry variables. If not used, the original ones at the source are used.

Back to IBM: DB2 FAQ Index
Back to IBM: DB2 Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close