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

> ## The schema holder

> As noted in the previous section, a schema holder contains information about the MSS data sources. This information, called the schema of the data source, is a description of its structure, its tables, the fields within its tables, and its indexes.

> OpenEdge accesses the schema holder only when it compiles procedures and at the beginning of a run-time session for schema caching (the loading of data definitions into memory). Typically, the schema holder is not accessed during a run-time session after the initial schema caching.

> Before an OpenEdge client can access data in the MSS data source, you must create a schema holder and load the required data source definitions into the schema holder. You can then use the Data Dictionary to add OpenEdge database features such as validation expressions and messages.

> Figure 1–3 illustrates the schema-loading process.

> Figure 1–3: The schema-loading process

> If you plan to use the DataServer to send SQL statements directly to the data source using only the `RUN` `STORED–PROCEDURE` syntax and you do not expect returned data, you need not load data definitions into the schema holder. However, you must do the following:

> - Load the stored procedure into the schema holder.

> - Connect to an empty data source.

> However, the RDBMS stored procedures also supports s and ProDataSet functionality which does support returning data to the foreign data source. For information on using `RUN` `STORED–PROCEDURE`, see Chapter 3, " RDBMS Stored Procedure Details."

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