Previous Topic: Data Manipulation with SQLNext Topic: Retrieving Data

Data Manipulation Operations

When SQL is used in a host language program, you will need to perform data manipulation. There are several ways that the program can take advantage of SQL DML in CA IDMS.

SQL DML Statements

Use the following SQL statements in data manipulation operations:

SQL data manipulation statements provide the following capabilities:

Consequently, you have several options for performing each type of data manipulation.