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:
NDB - PROCESS SQL in the Natural for DB2 part.
PROCESS SQL in the Natural for SQL/DS part.
The PROCESS SQL
statement is used to issue SQL statements
to the underlying database.
ddm-name | The name of a DDM must be specified to provide the "address" of the database which executes the stored procedure. For more information see ddm-name. | ||
---|---|---|---|
statement-string |
The statements which can be specified in the
statement-string are the same statements which can
be issued with the SQL statement
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 below. |
:U
|
: host-variable [INDICATOR :host-variable]
[LINIDICATOR :host-variable]
|
||
:G
|
Unlike with the parameter
described, in this context host-variables 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 >>