Keywords › SELDATA Keyword—SDT SELDATA Field › Example: SELDATA keyword

Example: SELDATA keyword

This example adds a SELDATA field to the SELECT record called PROBE1 for all the first names of employees that begin with Mike in departments 100 and above:

TSS ADDTO(SDT) SELECT(PROBE1)
               SELDATA('IF DEPARTMENT GE "100" AND "MIKE" ')

In this example, dept is defined in the SDT RECORD with the data‑type of CHAR. Values 0 to 9, A to Z, and special characters are accepted.:

SELDATA('IF dept EQ "HR1000"')

This example uses * as a wildcard match. If the LHS field dept contains a value that begins with H, and ends with 100, this would result in a match or a true expression:

SELDATA('IF dept EQ "H**100"')

For data‑types of PACKED, ZONED, or BIN, enter only decimal digits (0 to 9) without quotes and a maximum of 16 decimal digits. In this example salary is defined in the SDT RECORD with the data‑type of PACKED, ZONED, or BIN:

SELDATA('IF salary LT 50000')

In this example the decimal value is a negative number:

SELDATA('IF Total LE ‑1000')

In this example the data‑type is HEX:

SELDATA('IF Table EQ X"FFFFFFFF"')