SQL Programming Manual for TAL

NonStop SQL Statements and Directives
HP NonStop SQL Programming Manual for TAL—527887-001
3-5
Locating Information About SQL Statements and
Directives
INSERT SQLRM+SQL/TAL Inserts rows into a table or view.
OPEN SQLRM+SQL/TAL Opens a cursor.
SELECT SQLRM+SQL/TAL Retrieves data from tables and views.
UPDATE SQLRM+SQL/TAL Updates values in columns of a table or
view.
Dynamic NonStop SQLRM Statements
DECLARE CURSOR SQLRM+TAL Defines a cursor.
DESCRIBE SQLRM+TAL Returns information about output variables
for a prepared statement.
DESCRIBE INPUT SQLRM+TAL Returns information about input variables
for a prepared statement.
EXECUTE SQLRM+TAL Executes a prepared SQL statement.
EXECUTE IMMEDIATE SQLRM+TAL Executes an SQL statement contained in a
host variable.
PREPARE SQLRM+TAL Compiles a DDL, DML, or DCL statement.
RELEASE SQLRM+TAL Deallocates memory for a dynamic SQL
statement referred to through a host
variable.
* SQLRM Described only in the SQL/MP Reference Manual
SQL/TAL Described only in this manual
SQLRM+SQL/TAL Described in both, this manual and the SQL/MP Reference Manual
Transaction Control Statements
BEGIN WORK SQLRM Starts a TMF transaction.
COMMIT WORK SQLRM Commits all database changes made
during the current TMF transaction and
frees resources.
ROLLBACK WORK SQLRM Backs out the current TMF transaction and
frees resources.
Data Declaration Directives
BEGIN DECLARE
SECTION
SQLRM+TAL Designates the beginning of host variable
declarations.
END DECLARE
SECTION
SQLRM+TAL Designates the end of host variable
declarations.
INCLUDE SQLCA SQLRM+TAL= Declares the SQLRM communication area
to receive run-time status information.
INCLUDE SQLDA SQLRM+TAL= Declares the SQL descriptor area to hold
information about input and output
variables for dynamic SQL statements.
Table 3-1. Summary of NonStop SQL Statements and Directives (page 2 of 3)
Statement or Directive Manual * Description