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.
Related Statement: REQUEST
DOCUMENT
Belongs to Function Group: Internet and Parsing
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 >>