Executes a SQL statement
DBMS [ WITH CONNECTION
- Name of connection to associate with the statement. If the clause is not used, Panther issues the statement on the default connection.
- SQL statement to be sent to the database engine. The syntax of the statement can be the format needed by your database engine.
This command is not recommended. For SQL statements that return data, use DBMS QUERY. For SQL statements that do not return data (such as,
DELETE), use DBMS RUN.
DBMS SQLsends the specified statement to the database engine for execution after colon expansion is performed. If a connection is not specified, Panther uses the default cursor on the default connection.
SQLstatementcan be in the format needed by your database engine. This allows you to access all the features of your database engine.
DBMS SQL SELECT title_id, name, dir_first_name, \
dir_last_name FROM titlesDBMS SQL INSERT INTO actors \
(actor_id, last_name, first_name) VALUES \
(:+actor_id, :+last_name, :+first_name)