ADELIA |
|
|
|
|
(I/B) |
|
|
|
|
Section for use
All
Syntax
END_SQL
Description
This instruction marks the end of an SQL instruction within an Adelia program.
An SQL instruction in an Adelia program must be placed between the BEGIN_SQL and END_SQL instructions.
Every line of the SQL instruction must begin with the character +.
Only one SQL instruction may be specified between the BEGIN_SQL and END_SQL instructions.
Every END_SQL instruction must have a corresponding BEGIN_SQL instruction.
For more details on SQL instructions, see Subfile Loading Control.
Example
BEGIN_SQL |
|
+DECLARE C1 CURSOR FOR |
: SQL instruction to select customer |
+SELECT CCUSCO, CCUSNA |
: code and name from CUSTOM file |
+FROM CUSTOM |
: for all records where payment code |
+WHERE CPAYCO = :W_PAYMENT_CODE |
: is equal to a work field |
+ORDER BY CCUSNA |
: (W_PAYMENT_CODE) : (sort by customer name) |
END_SQL |
|
See also the list of 4GL instructions by topic