Field names

The meaning of a field name depends on its context.

A field name can be used to:

• Identify a field.
• Specify values of the field, as in the following contexts:
  • In an ORDER BY clause, a field name specifies all values in the intermediate result table to which the clause is applied. For example, ORDER BY HOSPNAME orders an intermediate result table by the values of the field HOSPNAME.
  • In a search condition, a field name specifies a value for each row or group to which the construct is applied. For example, when the search condition CODE = 20 is applied to some row, the value specified by the field name CODE is the value of the field CODE in that row.
• Provide a field name for an expression to temporarily rename a field, or as in the AS clause in the select-clause.