468,117 Members | 1,584 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,117 developers. It's quick & easy.

Stored procedures in SYSPROC schema

Are stored procedures in SYSPROC schema documented and supportedd? I am
particularly intersted in the procedure SYSPROC.DB2LOAD which seems to
be a SQL wrapper to the db2 load API. If that is true, my SQL stored
procedures could benefit from having LOAD API accessibility without
need to write a C stored proc to call it.
Forgot to mention... I found it in DB2 V8.1.8 AIX and Linux after I
upgraded from V8.1.4.

Regards,
-Eugene

Nov 12 '05 #1
3 3848
<ef******@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
Are stored procedures in SYSPROC schema documented and supportedd? I am
particularly intersted in the procedure SYSPROC.DB2LOAD which seems to
be a SQL wrapper to the db2 load API. If that is true, my SQL stored
procedures could benefit from having LOAD API accessibility without
need to write a C stored proc to call it.
Forgot to mention... I found it in DB2 V8.1.8 AIX and Linux after I
upgraded from V8.1.4.

Regards,
-Eugene

Check out the Administrative API Reference and see if that is what you are
looking for.
Nov 12 '05 #2
You are referring to the DB2 admin C API ref, whereas I am seeking the
description for stored procs in SYSPROC schema that seem to be a
wrappers around some admin API calls.

-Eugene

Nov 12 '05 #3
ef******@gmail.com wrote:
You are referring to the DB2 admin C API ref, whereas I am seeking the
description for stored procs in SYSPROC schema that seem to be a
wrappers around some admin API calls.

-Eugene

I don't think there is any harm in using it. Just be aware that the
signature may be changed in a future release.
When you taek a look at V8.2.2 (FP9)
you will find a generic admin procedure which shows teh direction where
DB2 is going for these:
http://publib.boulder.ibm.com/infoce...n/r0012547.htm

Supported now are:
# DESCRIBE
# EXPORT
# PRUNE HISTORY/LOGFILE
# REORG INDEXES/TABLE
# RUNSTATS
# UPDATE DATABASE CONFIGURATION

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Chris | last post: by
1 post views Thread by DB_2 | last post: by
11 posts views Thread by jw56578 | last post: by
5 posts views Thread by PJackson | last post: by
13 posts views Thread by didacticone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.