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

Using SYSPROC.ADMIN_CMD to terminate load

P: n/a
I'm trying to write a stored procedure that will terminate a load for
a given table using the SYSPROC.ADMIN_CMD procedure.

When I take the syntax that works using Quest:

LOAD
FROM '/dev/null' OF DEL
SAVECOUNT 1000
WARNINGCOUNT 100
TERMINATE INTO TABLE_NAME
ALLOW NO ACCESS;

And apply to the procedure:
CALL SYSPROC.ADMIN_CMD('LOAD FROM /dev/null OF DEL TERMINATE INTO
TABLE_NAME ALLOW NO ACCESS');

I get a pretty useless error:
Invalid procedure parameter value for parameter 1

(Note that I'm not using TABLE_NAME, but the actual name of the table)

Anyone know the correct syntax? This is on DB2 9 on AIX.

Also, is there any way to find the names of tables in load pending
uses a procedure or query?

TIA!
Feb 1 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.