CDDLHELP.HLB  —  FIELD_DESCRIPTION_CLAUSE, Example
  The  following  example  contains  DESCRIPTION  text  of  the  record
  definition as a whole, and of the elementary field ID.

  DEFINE RECORD CDD$TOP.CORPORATE.EMPLOYEE_LIST
      DESCRIPTION /* This record contains the employee master list,
                    and it is the source from which employee fields
                    in other record descriptions are copied. */.
      EMPLOYEE STRUCTURE.
          /* An employee's ID number is his or her social
          security number. */
          ID                       DATATYPE IS UNSIGNED NUMERIC
                                   SIZE IS 9 DIGITS.
          NAME STRUCTURE.
              LAST_NAME            DATATYPE IS TEXT
                                   SIZE IS 15 CHARACTERS.
              FIRST_NAME           DATATYPE IS TEXT
                                   SIZE IS 10 CHARACTERS.
              MIDDLE_INITIAL       DATATYPE IS TEXT
                                   SIZE IS 1 CHARACTER.
          END NAME STRUCTURE.
          ADDRESS                  COPY FROM
                                   CDD$TOP.CORPORATE.ADDRESS_RECORD.
          DEPT_CODE                DATATYPE IS UNSIGNED NUMERIC
                                   SIZE IS 3 DIGITS.
      END EMPLOYEE STRUCTURE.
  END EMPLOYEE_LIST RECORD.
Close Help