REPLACE PROCEDURE TDSTATS.AbortCollect (
IN CmdListID BIGINT,
IN CmdListName VARCHAR(128) CHARACTER SET UNICODE,
IN DatabaseName VARCHAR(128) CHARACTER SET UNICODE,
IN TableName VARCHAR(128) CHARACTER SET UNICODE,
IN RequestID BIGINT,
IN AbortInProgress CHAR(1) CHARACTER SET LATIN,
OUT NumPendingAborted INTEGER,
OUT NumInProgressAborted INTEGER
)
...
;
Syntax Elements
- CmdListID
- System-assigned commands list ID from a prior call to PrepCollect.
- See the usage notes.
- CmdListName
- Commands list name run by an in-progress RunCollect.
- See the usage notes.
- DatabaseName
- Name of the database whose collections in CmdListName are to be aborted.
- TableName
- Name of the table whose collections in CmdListName are to be aborted.
- RequestID
- Individual collection ID within CmdListName that is to be aborted.
- AbortInProgress
- Possible values:
- Y: AbortCollect stops the qualifying collections even if the collections are already in progress.
- N (default): AbortCollect allows in-progress collections to finish.
- NumPendingAborted
- Number of pending collection statements that were aborted.
- NumInProgressAborted
- Number of in-progress collection statements that were aborted.