SQL Engine 
Use
This function enables you to choose an SQL type support, which defines the type of database connection you obtain.
Features
SQL Engine enables you to choose one of the following options:
· Open SQL – the system returns a Database Interface (DBI) CommonConnection. By choosing this option, you choose to use all functions provided by SAP’s Open SQL for Java – that is, database vendor independence, SQL semantics, portability and syntax checks, SQL tracing mechanisms, statement caches, and table buffering.
If you want to use Open SQL, you need to initialize
the tables in your database in the 
Java
Dictionary.
· Native SQL – the system returns a DBI DirectConnection. It provides only a part of the functions of Open SQL for Java – SQL tracing, and statement caching.
· Vendor SQL – the system returns a standard JDBC connection without using DBI at all
To set the SQL type, you can use:
· Runtime ® Additional tab of JDBC Connector Service in Visual Administrator.
To view this tab, you have to select a DataSource entry from the Resources ® DataSources ® <applicationName>.
·
<sql-engine>
tag
from data-sources.dtd. If you do not use this tag, the system uses
the Open SQL option as a default. For more information about the DTD, see data-sources.dtd.
See also: