Re: Move stored procedure definitions to another AS400.

[Dieter.Bender@xxxxxxxxxxx (Dieter Bender)]

Hi,

in this case (external stored procedures) you could run a SQL script to the 
other box, or you might run the create procedure while you are connected to 
the other box.
The real problem arises, if you want to move a SQL procedure to another 
as400. This stuff must be created (and compiled) on the target system and 
often customers don't like compilers on production systems, or are not 
allowed to have.
In my opinion deployment of stored procedures is rather bad supported on 
as400.

Dieter Bender

On Saturday 03 May 2003 00:18, you wrote:
> I have created 2 dozens stored procedures on my AS400. They are implemented
> using CL/RPG.
>
> I need to move these external stored procedures to another AS400.
>
> I can move CL/RPG programs easily.
>
> Is there a easy way to move stored procedure definitions (in system catalog
> SYSROUTINE etc.) over to the other AS400?
>
> Thanks.
>
> Bruce
>
>
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
> mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo.cgi/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.

-- 
mfG

Dieter Bender


DV-Beratung Dieter Bender
Wetzlarerstr. 25
35435 Wettenberg
Tel. +49 641 9805855
Fax +49 641 9805856
www.bender-dv.de