Queries

Queries

Within InterSystems SQL, you view and modify data within tables by means of queries. Roughly speaking, queries come in two flavors: those that retrieve data (SELECT statements), and those that modify data (INSERT, UPDATE, and DELETE statements).

You can use SQL queries in a number of ways:

• Using Embedded SQL within ObjectScript.

• Using Dynamic SQL within ObjectScript.

• Calling a stored procedure created using CREATE PROCEDURE or CREATE QUERY.

• Using a class query. For further details, refer to Defining and Using Class Queries.

• Using the ODBC or JDBC interfaces from a variety of other environments.

SELECT queries are described in Querying the Database.

Queries are part of InterSystems IRIS objects or ObjectScript routines.