The flow chart in the following figure illustrates the DataServer's internal logic.
Figure 2. DataServer logic
As shown in the above figure, when you execute an application that accesses a supported data source, the Compiler translates OpenEdge ABL or SpeedScript statements into their SQL equivalents. The DataServer then issues the SQL statements to the appropriate ODBC driver through the ODBC API. The driver, which provides the software mechanisms for accessing and controlling the data source, processes the SQL statements, transfers them to the data-source manager, and returns the results to the DataServer through the ODBC API.
Note: SQL statements presented in the above figure have been simplified for the purpose of focusing on the data flow.
In order to facilitate the flow of statements between client and server, the DataServer places OpenEdge equivalents for data definitions from a supported data source into a schema holder (a repository for data definitions for one or more ODBC data sources). When the OpenEdge client or WebSpeed Agent executes statements and retrieves information from the data source, it relies on data definitions in the schema holder.
