Introduction to CA IDMS Data Manipulation Language › Programming in the CA IDMS Environment › SQL DML

SQL DML

You can use SQL DML to access the same databases you access using navigational DML. Additionally, you can use SQL DML to access databases that have been defined using SQL DDL.

Using SQL DML, you do not have to be familiar with database structure and your programs do not have to include database navigation logic.

You can perform the following functions using SQL DML statements:

• Select rows
• Update rows
• Delete rows
• Insert rows

Note:

• For more information about SQL DML statements, see the CA IDMS SQL Reference Guide.
• For information about embedding SQL statements in application programs, see the CA IDMS SQL Programming Guide.