By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,610 Members | 1,697 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,610 IT Pros & Developers. It's quick & easy.

Stored procedures in SYSPROC schema

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
<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

P: n/a
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

P: n/a
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.