DEFINE SCRATCHPADENTRY (Define a scratch pad entry)

Use this command to enter data on a new line in the scratch pad. The scratch pad is a database table that the server hosts. You can use the scratch pad to store diverse information in table format.

Privilege class

To issue this command, you must have system privilege.

Syntax

Read syntax diagramSkip visual syntax diagramDEFine SCRATCHPadentrymajor_categoryminor_categorysubjectLine=number Data=data

Parameters

major_category (Required)
Specifies the major category in which data is to be stored. Enter a text string of up to 100 alphanumeric characters. This parameter is case sensitive. In addition to alphanumeric characters, you can also specify special characters. Only the following special characters are available for the major category parameter.
Character Description
_ Underscore
. Period
- Hyphen
+ Plus
& Ampersand
minor_category (Required)
Specifies the minor category in which data is to be stored. Minor categories are sections within major categories. Enter a text string of up to 100 alphanumeric characters. This parameter is case sensitive. In addition to alphanumeric characters, you can also specify special characters. Only the following special characters are available for the minor category parameter.
Character Description
_ Underscore
. Period
- Hyphen
+ Plus
& Ampersand
subject (Required)
Specifies the subject under which data is to be stored. Subjects are sections within minor categories. Enter a text string of up to 100 alphanumeric characters. You can also specify blank characters and all special characters. Enclose the text in quotation marks if the subject contains any blank characters. This parameter is case sensitive.
Line (Required)
Specifies the number of the line on which data is to be stored. Lines are sections within subjects. Specify an integer in the range 1 - 1000.
Data (Required)
Specifies the data to be stored on the line. You can enter up to 1000 characters. You can also specify blank characters and all special characters. Enclose the text in quotation marks if the data contains any blank characters. This parameter is case sensitive.

Example: Define a scratch pad entry

Enter the vacation dates of an administrator, Jane, in a table that stores information about the location of all administrators.
define scratchpadentry admin_info location jane line=2 data=
"Out of the office from 1-15 Nov."

Related commands

Table 1. Commands related to DEFINE SCRATCHPADENTRY
Command Description
DELETE SCRATCHPADENTRY Deletes a line of data from 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.