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 XML
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:
With Entire Access, you can also specify the following as statement-string:
These options are only possible with Entire Access, and are described in the section Accessing Data in an SQL Database (in the Programming Guide).
PROCESS SQL ADABAS_D_DDM << LOCK TABLE EMPLOYEES IN SHARE MODE >>
The called procedure computes the sum of two numbers.
... COMPUTE #N1 = 1 COMPUTE #N2 = 2 COMPUTE #SUM = 0 ... PROCESS SQL ADABAS_D_DDM << DBPROCEDURE DEMO.SUM (:#N1, :#N2, :G:#SUM) >> ... WRITE #N1 '+' #N2 ' =' #SUM ...