Data Manipulation Language (DML) Generation

DML Generation transforms requests into a format that allows retrieval from native DBMS engines. Specifically, it translates the request into the Data Manipulation Language (DML) and invokes one or more data adapters. A data adapter generates the native DML of the DBMS and passes it to the DBMS for processing.

DML Generation is used when an application attempts to perform one of the following:

• Read from non-relational data sources.
• Address a join between heterogeneous data sources in a single SQL statement.
• Join two or more relational tables from different RDBMS engines.
• Join data sources that are distributed across servers.
• Send an SQL request using syntax for which there is no corresponding feature flag for the target RDBMS.
• Retrieve defined columns.
• Retrieve data from tables having security restrictions in the Server Dynamic Catalog.
• Use a Hub or Full-Function Server whose APT setting is OFF.

DML Generation is shown in the shaded portion of the solid-line circle as shown in the figure below.