Example 1

    The following example defines a field and specifies a DATATRIEVE
    edit string for that field:

    DEFINE FIELD  MIDDLE_INITIAL
            DATATYPE IS TEXT SIZE 1
            EDIT_STRING FOR DATATRIEVE IS 'X.'.

    The X represents any alphanumeric character. When you access
    this field through DATATRIEVE, the field value is followed by a
    period. The DATATRIEVE documentation set contains a complete list
    of editing characters.

    Example 2

    The following example defines a DATATRIEVE query name for one
    field and a DATATRIEVE query header for another:

    DEFINE FIELD  STATE
            DATATYPE IS TEXT SIZE 2
            QUERY_NAME FOR DATATRIEVE IS "ST".
    DEFINE FIELD  SEX
            DATATYPE IS TEXT SIZE 1
            VALID IF SEX = 'M' OR SEX = 'F'
            QUERY_HEADER FOR DATATRIEVE IS "S"/"E"/"X".

    These statements define DATATRIEVE query names and query headers
    for the STATE and SEX fields. The header for the SEX field will
    be one character wide, like the field itself.