Executes a SQL statement that returns data to the application
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.
DBMS QUERYprepares the SQL statement (in general, one that returns rows) by indicating to the database engine where to put return data (if any), and then tells the database to execute the SQL statement.
This command is used for statements, either
SELECTstatements or stored procedures, that return data. For statements that do not return data, use DBMS RUN.
For additional information, refer to Chapter 29, "Reading Information from the Database," in Application Development Guide.
DBMS QUERY SELECT title_id, name, dir_first_name, \
dir_last_name FROM titles