Retrieving Data: How to Write Queries A query is a statement that requests data from a database. This section describes how to write queries for a NonStop SQL/MP database. You can specify a query explicitly by using interactive SELECT statements, application-embedded SELECT and CURSOR statements, and report writer selections. You can specify a query implicitly in UPDATE, INSERT, and DELETE statements. A query can use either dynamic or static SQL. Ad hoc queries submitted through an interface such as the NonStop ODBC Server and queries submitted directly through the conversational interface (SQLCI) are likely to be dynamic. NonStop SQL/MP prepares these queries for execution, compiles them, and executes them as soon as they are submitted.
More reviews about the SQL