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.