Executes an SQL statement that does not return any select sets
DBMS [WITH CONNECTION
- Name of connection to associate with the statement. If the clause is not used, Panther uses the default connection.
- SQL statement (
CREATE TABLE, etc.) to be sent to the database engine. The syntax of the statement can be specific to database engine.
SQLstatementon the assumption that no data will be returned by submitting the SQL to the database for immediate execution.
If, however, a data selection SQL statement is executed (one which returns data from the database), the statement will be executed a second time in order that the selected data can be fetched. For this reason, use the
QUERYstatement when selected data may be returned.
DBMS RUN INSERT INTO actors \
(actor_id, last_name, first_name) VALUES \
(:+actor_id, :+last_name, :+first_name)