SQL Select Handling

[This is preliminary documentation and subject to change.]

This topic outlines how the adapter parses SQL SELECT statements, and converts them into CIM calls. It describes SELECT statement processing in terms of the CIM calls that must be made, and touches on the data structures used within the ODBC adapter.

It does not consider the internal operation of the Managed Object (MO) Server, mini-servers, or providers.

Finally, it describes how SQL Query Decomposition proceeds. SQL Query Decomposition is the process whereby SQL SELECT statements are broken down into single table select queries, and passed as queries to the WBEM Gateway interface if it supports SQL handling.