Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
Initial Programming Considerations : Data types : Arrays


The OpenEdge database allows you to define fields as arrays, also called field extents. The DataServer interprets specially named data source columns of the same data type as an OpenEdge field with the same number of array elements. You name the data source columns column_name##1, column_name##2, and so forth, to correspond to an OpenEdge array named colunm_name. The DataServer creates a single field definition in the schema holder for the field extents. See Migrating an OpenEdge database to MS SQL Server for instructions on adding these columns automatically with the OpenEdge DB to MS SQL Server utility.