Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2013

    Unanswered: Db2 stored procedure deploy


    I have some updated stored procedure on 1 db2 db. and i need to deploy these SP
    to another db through command line.
    As it is my daily task i need to deploy several stored procedures and so wanted to do this task automated.

    Can anyone please help me how to deploy stored procedure from 1db to another through command line?

    Thanks in advance.

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    you could use db2look to get all code and cut this from this file to a new file
    execute db2 -td@ -vf xxxx with previous connect to install this sp in any db
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  3. #3
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    Consider the GET ROUTINE and PUT ROUTINE CLP commands (or the corresponding stored procedures).
    "It does not work" is not a valid problem statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts