Progress
Embedded SQL-92
Guide and Reference


ESQL Executable Statements

The ESQL constructs that result in the execution of instructions on a specified database at run time are called ESQL executable statements. The executable statements form the body of an ESQL program and are used to access the database.

EXAMPLE

The following example shows an UPDATE executable statement. This UPDATE statement adds 1000 units to the existing quantity (qty) for the row in the orders table where order number (order_no) equals 1244.

EXEC SQL
    UPDATE orders
    SET qty = qty + 1000
    WHERE order_no = 1244 ; 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095