Programming Guide

RUN

Executes an SQL statement that does not return any select sets

Synopsis

DBMS [WITH CONNECTION connection] RUN SQLstatement

Arguments

WITH CONNECTION connection
Name of connection to associate with the statement. If the clause is not used, Panther uses the default connection.

SQLstatement
SQL statement (INSERT, UPDATE, DELETE, CREATE TABLE, etc.) to be sent to the database engine. The syntax of the statement can be specific to database engine.

Description

DBMS RUN executes SQLstatement on 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 QUERY statement when selected data may be returned.

Example

DBMS RUN INSERT INTO actors \
	(actor_id, last_name, first_name) VALUES \
	(:+actor_id, :+last_name, :+first_name)

See Also

QUERY