Progress
DataServer
for ODBC Guide
Modifying Tables to Support Arrays
The DataServer allows you to extend Progress’s ability to support database arrays to your ODBC data source. To have access to this functionality, make the following changes to your data-source table:
- 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.
- Make sure that these columns are of the same data type. For example, if you want the schema holder to include an array named MONTH with 12 elements, the ODBC data-source table must have 12 adjacent columns of the same data type named month##1, month##2, month##3, and so forth. Progress 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.
- If you have already created your schema holder, update it to reflect your changes to the data-source table.
NOTE: For Informix arrays , enter the text "_ _" (two underscores) instead of "##" (two number signs).
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |