Programming Guide

QUERY

Executes a SQL statement that returns data to the application

Synopsis

DBMS [ WITH CONNECTION connection ] QUERY SQLstatement

Arguments

WITH CONNECTION connection
Name of connection to associate with the statement. If the clause is not used, Prolifics issues the statement on the default connection.

SQLstatement
SQL statement to be sent to the database engine. The syntax of the statement can be the format needed by your database engine.

Description

DBMS QUERY prepares 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 SQL SELECT statements 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.

Example

DBMS QUERY SELECT title_id, name, dir_first_name, \ 
	dir_last_name FROM titles

See Also

DBMS RUN