PROCESS SQL
ddm-name
<<statement-string>>
|
This document covers the following topics:
For explanations of the symbols used in the syntax diagram, see Syntax Symbols.
Belongs to Function Group: Database Access and Update
See also PROCESS SQL in the Natural for DB2 part of the Database Management System Interfaces documentation.
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 >>