ESQL Executable Statements

The ESQL constructs that result in the execution of instructions on a specified database at runtime are called the ESQL executable statements. The executable statements form the body of an ESQL program and are used to access the database. The following example shows a sample ESQL executable statement:

EXEC SQL

UPDATE orders

SET qty = qty + 1000

WHERE order_no = 1244 ;

The above SQL statement adds 1000 units to the existing quantity for the row in the orders table, having order number 1244.