Release 10.1A: OpenEdge Data Management:
DataServer for Microsoft SQL Server

> ## Modifying tables to support arrays

> The DataServer allows you to extend OpenEdge’s ability to support database arrays to your data source. To have access to this functionality, you must make changes to your data source table.

> | To modify a table to support arrays:

> 1. Name the columns of a data source table that you want the DataServer to roll into an array `column`##1, `column`##2, etc. The columns must be adjacent and in sequence.

> 2. Make sure that these columns are of the same data type and size. For example, if you want the schema holder to include an array named `MONTH` with 12 elements, the data source table must have 12 adjacent columns of the same data type named `month##1`, `month##2`, `month##3`, and so forth. OpenEdge names the corresponding field in the schema holder `month`. In your applications, refer to each element of the array as `month[1]`, `month[2]`, `month[3]`, and so forth.

> 3. If you have already created your schema holder, update it to reflect your changes to the data source table.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095