Progress
DataServer for
Microsoft SQL Server
Guide
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.
Progress 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 a Progress 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 Progress Data Dictionary to add Progress 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:
For information on using RUN STORED–PROCEDURE, see the "Stored Procedures" section in Programming Considerations."
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |