DB2 - SQL statements - data change - www.cadcobol.com.br
Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com
DB2 - SQL statements - data change
SQL Statement
Purpose
DELETE
Deletes one or more rows from a table.
INSERT
Inserts one or more rows into a table.
MERGE
Updates a target (a table or view) using data from a source (result of a table reference).
TRUNCATE
Deletes all rows from a table.
UPDATE
Updates the values of one or more columns in one or more rows of a table.
© Copyright IBM Corp.