Using a dynamic command, insert adds a new row to a table or view.
insert [database.[owner.]]{table_name|view_name}[(column_list)]
values (? [, ?]...)
Any valid object in the catalog can be substituted for table_name or view_name.
is a list of one or more columns to which data is to be added. The columns can be in any order, but the incoming data (whether in a values clause or a select clause) is in the same order.
is a keyword that introduces a list of expressions.
specifies a parameter marker passed by the application.
insert titles (title_id, title, type, pub_id, notes, pubdate, contract) values (?, ?, ?, ?, ?, ?, ?)
Any valid object in the catalog can be substituted for table_name, view_name, and so forth.
ASE/CIS passes the insert command to the DirectConnect server as the following series of dynamic SQL commands:
prepare
execute
close
deallocate
The values in the values list are passed as dynamic SQL parameters.
