Re: DB2 stored procedure not shown by DSPSAVF

I will have to test it, but how do you save and restore a stored
procedure which is the stub for an external program which does not yet
exist? When the stored proc is created the defn is stored in the
global procedures table of DB2 and as some sort of associated data in
the EXTERNAL PROGRAM or SPECIFIC that the procedure is created as. If
the EXTERNAL PROGRAM does not exist, how is the stored proc saved?

I think my question is broader and relates to how a DB2 database is
saved and restored on AIX vs IBM i. On another platform, can you save
a DB2 schema, display the save media and see a listing of DB2 objects
saved, then restore all or parts of that schema from the save media?



On Tue, Sep 15, 2009 at 4:35 PM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

How do you figure stored procedures are not objects?

Every stored procedure is either a *PGM or a proc in a *SRVPGM.

The only thing funky is that there's a catalog table that tracks the names.

Charles

On Tue, Sep 15, 2009 at 3:58 PM, Steve Richter <stephenrichter@xxxxxxxxx> wrote:

On Tue, Sep 15, 2009 at 2:36 PM, Elvis Budimlic
<ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Yes, but here is a link to an article that explains it much better than I
could:

http://www.mcpressonline.com/programming/sql/procedures-and-functions-and-ca
talogs-oh-my.html

wow, good article.  Interesting how the pure as400 design of
implementing everything as objects was not adhered to for stored
procedures.

thanks for the help,
--