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.