Data manipulation

Topic group Related topics

This section describes functions available to data manipulation language (DML) statements in local SQL. It covers

Parameter substitutions in DML statements

Aggregate functions

String functions

Date function

Updatable queries

With some restrictions, local SQL supports the following statements for data manipulation:

SELECT, for retrieving existing data

INSERT, for adding new data to a table

UPDATE, for modifying existing data

DELETE, for removing existing data from a table