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
The PROCESS SQL statement is used to issue SQL statements
to the underlying database.
| Syntax Element | Description | ||
|---|---|---|---|
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
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:
With Entire Access, you can also specify the following as statement-string:
SET SQLOPTION option =
value
SQLCONNECT option =
value
SQLDISCONNECT
These options are only possible with Entire Access.
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 ...
