DELETE SCRATCHPADENTRY (Delete a scratch pad entry)
Use this command to delete one or more lines of data from a scratch pad.
Privilege class
To issue this command, you must have system privilege.
Syntax
Parameters
- major_category (Required)
- Specifies the major category from which one or more lines of data are to be deleted. This parameter is case sensitive.
- minor_category (Required)
- Specifies the minor category from which one or more lines of data are to be deleted. This parameter is case sensitive.
- subject (Required)
- Specifies the subject from which one or more lines of data are to be deleted. This parameter is case sensitive.
- Line
- Specifies a line of data that is to be deleted. For number, enter the number of the line that is to be deleted. All data on the line is deleted. The numbering of other lines in the subject section is not affected. You can delete all lines of data from a subject section by omitting the Line parameter in this command.
Example: Delete all lines of data from a subject in a scratch pad
Delete all lines of data about the location of an administrator, Jane, from a database that
stores information about
administrators:
delete scratchpadentry admin_info location janeRelated commands
| Command | Description |
|---|---|
| DEFINE SCRATCHPADENTRY | Creates a line of data in the scratch pad. |
| QUERY SCRATCHPADENTRY | Displays information that is contained in the scratch pad. |
| SET SCRATCHPADRETENTION | Specifies the amount of time for which scratch pad entries are retained. |
| UPDATE SCRATCHPADENTRY | Updates data on a line in the scratch pad. |
