table_name

is the table to which data will be added.

(column_list)

a list of one or more columns for the specified table.  The columns can be in any order, but the incoming data must be in the same order.  Note that the parentheses must be entered as a part of the statement.

The column_list is only necessary when some, but not all, of the columns in the table are to receive data.  The column_list determines the order in which values are entered.  If a column_list is not specified, all of the columns in the table are assumed to be receiving data.  In this case, the order of the columns is assumed to be the same as used when the table was created.

VALUES

specifies the field or constant values for the indicated columns.

(\\constant_expression\\)

The value list must match the explicit or implicit column_list.  Note that the parentheses must be entered as a part of the statement.  Use of the Ready statement will allow values to be placed in the fields of the data set.  Each name must be followed with the designator and the designator extension ":R".  The explicit values list is not then required.

select_str_exp

is a quoted literal, a character or an alphabetic field, a function, or a concatenation of any of the preceding that evaluates to a string that represents an SQL SELECT statement used to re­trieve the values to be inserted.  This string can be built dynamically from within the Process Module.  The select_list of the SQL SELECT statement must match the explicit or implicit column_list.

HUSH

shuts off warning, error, auxiliary, and SQL messages for the execution of that statement only.  The text of the error message can be found in the system function @ERROR_MESSAGE.