6. QUEL and EQUEL Statements : Append Statement--Add a Table Row : Description
 
Share this page                  
Description
The append statement adds a row to the specified table. The columns of the row contain the values assigned in the columnname = expression clauses.
To reduce processing overhead for frequently repeated appends, specify the repeat option. Repeat directs the DBMS Server to save an execution plan after the append is first executed. In repeat append statements, you must flag variables if their values change (or can possibly change) each time the append is executed. If the variable appears on the right side of an equal sign (=), it must be preceded by an "at" sign (@). The @ flag tells the EQUEL preprocessor that the value of the variable must be checked each time the query is executed.