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
|
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 ...
