Maintaining Special Security Records › SDT Record › Define SELECT Record to SDT

Define SELECT Record to SDT

The SELECT keyword is required when adding a SELECT record to the SDT Record.

To define a new SELECT record to the SDT, enter the command:

TSS ADDTO(SDT) SELECT(sel‑name)
               DESCRIPT(desc‑name)
               SELDATA(‘IF seldata‑fld |{logical operator|}
                       “value” AND|OR] seldata‑fld |
                       {logical operator\}”value”‘)

SELECT

Specifies a user‑defined record ID that must be unique for each SELECT record. It can contain letters, numbers, and special characters.

Size: 8 characters

DESCRIPT

Designates an optional user‑description field that is used as a logical name for this record. If the description field contains blanks, you must enclose it in single quotes.

Size: 32 characters

SELDATA

Contains the logical rules to be used as selection criteria for this expression. seldata‑fld must be surrounded by single quotes.

logical operator

Select one of these logical operators: EQ (equal to), NE (not equal to), LT (less than), GT (greater than), GE (greater than or equal to), LE (less than or equal to).

value

Specify a value to which the value of seldata‑fld is to be compared. If the SDT record definition has a type of CHAR, then the value must be surrounded by double quotes. Otherwise, do not use quotes when the record type is strictly numeric (for example, BIN, PACKED, ZONED).

AND|OR

Used to link multiple statements together. Use AND when both statements are to be true; use OR when either statement is to be true.

Example: define a SELECT record

This example creates a SELECT record called PROBE1 in the SDT, selecting departments ranging from 200 through 299:

TSS ADDTO(SDT) SELECT(PROBE1)
               SELDATA(‘IF DEPT GE “200” AND DEPT LE “299” ‘)