Move SQL Proc from Development to Production in DB2 V72 1

[chizi]

Hi all,

I created 20+ SQL procedure on DB2(V72) Development database on AIX5.2, now I want move them to Production DB2 database(same as V72) on AIX(Same as 5.2).

Since I have not installed any C/C++ compilers on Production server, can I use GET ROUTINE/PUT ROUTINE? How can Production database get these SQL procedure from Development database?

I appreciate your time very much!

 

[sathyarams]

FAQ on stored proc deployment can be found in the forum at

http://www.tek-tips.com/faqs.cfm?spid=178&sfid=2953

More DB2 questions answered at

http://www.dbforums.com/f8