The OpenEdge database allows you to define fields as arrays, also called field extents. OpenEdge interprets specially named data-source columns of the same data type as OpenEdge fields with the same number of array elements. You must name the data-source columns
column-name##1,
column-name##2, and so forth. In DB2 UDB, however, you must name these columns
column-name__1,
column-name __2, and so forth. (Some DB2 UDB OS environments have trouble translating the pound sign (hash sign) in object names.) The DataServer creates a single field definition in the schema holder for the field extents. See
Adding extended ABL support for instructions on adding these columns automatically with the Progress-to-ODBC utility.