I'm trying to write a stored procedure that will terminate a load for
a given table using the SYSPROC.ADMIN_C MD 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_C MD('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!
a given table using the SYSPROC.ADMIN_C MD 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_C MD('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!