Difference between revisions of "Statement"
(→{{GVESB}} Configuration) |
(→{{GVESB}} Configuration) |
||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 38: | Line 38: | ||
The attribute's value cannot be null. | The attribute's value cannot be null. | ||
|- | |- | ||
| − | | id || optional || The attribute's value cannot be null. | + | | id || optional || Statement identifier. Default is 0. It is used as value of row/@id attribute: |
| + | * Select: identifies the statement from which have been extracted the marked rows. | ||
| + | * Update: identifies the statement to be used to process the input row parameters. | ||
| + | The attribute's value cannot be null. | ||
|- | |- | ||
| keys || optional || Only useful in DBOSelect. | | keys || optional || Only useful in DBOSelect. | ||
| Line 46: | Line 49: | ||
specifying the attribute keys = "2", the result would be: | specifying the attribute keys = "2", the result would be: | ||
<syntaxhighlight lang="XML"><RowSet> | <syntaxhighlight lang="XML"><RowSet> | ||
| − | <data key_2="GreenVulcano"> | + | <data key_2="GreenVulcano"> |
| − | <row><col>19</col> <col>pippo</col> </row> | + | <row><col>19</col><col>pippo</col></row> |
| − | <row> <col>25</col> <col>pluto</col> </row> | + | <row><col>25</col><col>pluto</col></row> |
| − | + | </data> | |
</RowSet> | </RowSet> | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Can specify multiple keys separated by commas. | Can specify multiple keys separated by commas. | ||
| + | |||
| + | '''The select NEEDS to have an ORDER BY rule with THE SAME fields used in the attribute, and in the same order''' | ||
| + | |||
The attribute's value cannot be null. | The attribute's value cannot be null. | ||
|} | |} | ||
Does not contain subelements. | Does not contain subelements. | ||
Latest revision as of 20:16, 6 April 2017
Description
This element defines the statement to be evaluated.
Can contains placeholders that will be replaced at runtime.
GreenVulcano® ESB Configuration
The element statement can be used by:
- CallDescriptor
- DBOFlatSelect
- DBOInsert
- DBOInsertOrUpdate
- DBOMultiFlatSelect
- DBOSelect
- DBOThreadSelect
- DBOUpdate
- DBOUpdateOrInsert
- Sheet
Its attributes are:
| Attribute | Type | Description |
|---|---|---|
| type | required | Must be:
The attribute's admitted values are:
The attribute's value cannot be null. |
| id | optional | Statement identifier. Default is 0. It is used as value of row/@id attribute:
The attribute's value cannot be null. |
| keys | optional | Only useful in DBOSelect.
Specifies the index of select output on which group the results. The corresponding values are specified as attributes of 'data' element within the 'RowSet' element. For example, in the select: SELECT id,company_code,name FROM employees specifying the attribute keys = "2", the result would be: <RowSet>
<data key_2="GreenVulcano">
<row><col>19</col><col>pippo</col></row>
<row><col>25</col><col>pluto</col></row>
</data>
</RowSet>
Can specify multiple keys separated by commas. The select NEEDS to have an ORDER BY rule with THE SAME fields used in the attribute, and in the same order The attribute's value cannot be null. |
Does not contain subelements.
