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,
--

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].