Supported SQL statements

Devart ODBC Driver for ASE supports a wide range of SQL statements required for most database operations. For the full syntax and a complete list of SQL statements, see the SAP ASE documentation.

Data Definition Language (DDL) statements

DDL statements define and manage schema objects.

The supported DDL statements include:

• ALTER
• CREATE
• DROP
• TRUNCATE

Data Manipulation Language (DML) statements

DML statements access and modify data in existing schema objects.

The supported DML statements include:

• DELETE
• EXEC
• INSERT
• SELECT
• TRANSFER
• UPDATE

Transaction Control statements

Transaction control statements manage changes made by DML operations.

The supported transaction control statements include:

• BEGIN
• COMMIT
• LOCK
• ROLLBACK
• SAVE