Data Manipulation with SQL › Data Manipulation Operations

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:

• SELECT—To retrieve data
• INSERT—To add data
• UPDATE—To modify data
• DELETE—To delete data
• CALL—To invoke an SQL invoked procedure or table procedure.

SQL data manipulation statements provide the following capabilities:

• One statement can manipulate data in many rows
• One statement can perform both computation and data manipulation
• One statement can retrieve data from many tables

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