Re: Promoting Stored Procedures

["Andrew Goade" <agoade@xxxxxxxxxxxx>]

Kevin,
What did the SQL look like that you used to create the procedure??  Here is
an example we use to create our procedures.

CREATE PROCEDURE *libl/procname(IN XMLMSG VARCHAR ( 32000))
RESULT SETS 1 LANGUAGE RPGLE NOT DETERMINISTIC READS SQL DATA
EXTERNAL NAME *libl/procname PARAMETER STYLE GENERAL

Notice there are two places to specify the procedure name(procname) and the
library it is in.

If you need to drop the procedure and create it again.

Andy



|---------+----------------------------->
|         |           keblake@xxxxxxxxxx|
|         |           -corp.com         |
|         |           Sent by:          |
|         |           rpg400-l-bounces@x|
|         |           idrange.com       |
|         |                             |
|         |                             |
|         |           05/08/2003 10:12  |
|         |           AM                |
|         |           Please respond to |
|         |           RPG programming on|
|         |           the AS400 /       |
|         |           iSeries           |
|         |                             |
|---------+----------------------------->
  
>---------------------------------------------------------------------------------------------------------------------------------------------|
  |                                                                             
                                                                |
  |       To:       rpg400-l@xxxxxxxxxxxx                                       
                                                                |
  |       cc:                                                                   
                                                                |
  |       Subject:  Promoting Stored Procedures                                 
                                                                |
  
>---------------------------------------------------------------------------------------------------------------------------------------------|




We have just begun using stored procedures in our shop and are now ready to
promote them to the test environment.
The problem is we do not have a change management system.
To ease administrative overhead  we attempted to just move the external
program associated with the stored procedure. The sysprocs record lists the
program location as *libl so we assumed we could do this without deleting
and recreating the procedure. However when the stored procedure was invoked
it still attempted to use the program at the dev level and it no longer
exists there.

So, what should be the promotion path of stored procedures and how do you
handle needing the same procedure at different levels i.e., Dev and Prod?

I appreciate any help...

Kevin E. Blake
Highlights For Children
I.S. Sr. Staff Specialist
614-487-2706


_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.