ENABLE Reference Manual

ENABLE ATTRIBUTES
TREE Attribute
Determining Appropriate Join Fields. To find potential join
fields, examine the record descriptions associated with both
boxes. These record descriptions must describe matching fields.
Fields match if they have compatible data types.
You obtain the data type of a field from the PIC clause
associated with that field in the record description. If the
data types of both fields are compatible, the fields are
potential join fields. Table 4-3 lists the compatible data
types.
Table 4-3. Compatible Data Types
-----------------------------------------------------------------
| |
| Data Type Compatible Data Types |
|_______________________________________________________________|
| |
| Alphabetic Alphabetic (PIC A) |
| (PIC A) Alphanumeric (PIC X or TYPE CHARACTER) |
| |
| |
| Alphanumeric Alphabetic (PIC A) |
| (PIC X or TYPE Alphanumeric (PIC X or TYPE CHARACTER) |
| CHARACTER) Numeric Integer (PIC 9, PIC 9 COMP or |
| TYPE BINARY) |
| Numeric Noninteger (PIC 9 V 9.. or |
| Scaled item) |
| |
| |
| Numeric Integer Numeric Integer (PIC 9, PIC 9 COMP or |
| (PIC 9, PIC 9 TYPE BINARY) |
| COMP or TYPE Numeric Noninteger (PIC 9 V 9.. or |
| BINARY) Scaled item) |
| Alphanumeric (PIC X or TYPE CHARACTER) |
| |
| |
| Numeric Numeric Integer (PIC 9, PIC 9 COMP or |
| Noninteger TYPE BINARY) |
| (PIC 9 V 9.. or Numeric Noninteger (PIC 9 V 9.. or |
| Scaled item ) Scaled item) |
| Alphanumeric (PIC X or TYPE CHARACTER) |
| |
| |
| Note that the data type of a courtesy key is Numeric |
| Integer. |
| |
-----------------------------------------------------------------
4-79