Using SYSPROC.ADMIN_CMD to terminate load

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • David Beardsley

    #1

    Using SYSPROC.ADMIN_CMD to terminate load

    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!
Working...