PROCESS SQL
ddm-name
<<statement-string>>
|
This document covers the following topics:
For an explanation of the symbols used in the syntax diagram, see Syntax Symbols.
Belongs to Function Group: Database Access and Update
See also the following sections in the Database Management System Interfaces documentation:
PROCESS SQL in the Natural for DB2 part.
PROCESS SQL in the Natural SQL Gateway part.
PROCESS SQL in the Natural for SQL/DS part.
The PROCESS SQL
statement is used to issue SQL statements
to the underlying database.
Syntax Element | Description | ||
---|---|---|---|
ddm-name
|
DDM Name:
The name of a data definition module (DDM) must be specified to
provide the "address" of the database which executes the stored
procedure. For more information, see
|
||
statement-string
|
Statement String:
The statements which can be specified in the
The statement string can cover several statement lines without any continuation character to be specified. Comments at the end of a line as well as entire comment lines are possible. The statement string can also include parameters; see Parameters in Statement String below. |
:U
|
: host-variable
[INDICATOR :host-variable]
[LINIDICATOR :host-variable]
|
||
:G
|
Unlike with the Parameters
described in the section Basic
Syntactical Items, the
host-variables
used in this context
must be prefixed by a colon (:). In addition, they can be preceded by a further
qualifier (:U
or :G
).
See further details on
host-variable
.
Syntax Element Description:
PROCESS SQL DB2_DDM << CONNECT TO :LOCATION >>
PROCESS SQL DB2_DDM << SET :G:LOCATION = CURRENT SERVER >>