INSERT statement

Start of changeThe INSERT statement inserts a row into a database table.End of change

SYNTAX

Start of changeA single row is inserted into the table identified by TableReference. The ColumnName list identifies those columns in the target table that are to be given specific values. These values are determined by the expressions within the VALUES clause (the first expression gives the value of the first named column, and so on). The number of expressions in the VALUES clause must be the same as the number of named columns. Any columns present in the table but not mentioned in the list are given their default values.End of change

Start of change

Handling errors

It is possible for errors to occur during insert operations. For example, the database may not be operational, or the table may have constraints defined which the new row would violate. In these cases, an exception is thrown (unless the node has its throw exception on database error property set to FALSE). These exceptions set appropriate SQL code, state, native error, and error text values and can be dealt with by error handlers (see the DECLARE HANDLER statement).

For further information about handling database errors, see Capturing database state.

End of change
Start of change

Examples

The following example assumes that the dataSource property of the Database node has been configured, and that the database it identifies has a table called TABLE1 with columns A, B, and C.

Given a message with the following generic XML body:
<A>
 <B>1</B>
 <C>2</C>
 <D>3</D>
</A>
End of change
Related concepts
ESQL overview
Related tasks
Developing ESQL
Capturing database state
Related reference
Syntax diagrams: available types
ESQL statements