Difference between revisions of "Statement"
(→{{GVESB}} Configuration) |
(→{{GVESB}} Configuration) |
||
| Line 18: | Line 18: | ||
* [[DBOUpdateOrInsert]] | * [[DBOUpdateOrInsert]] | ||
* [[Excel-call#Sheet|Sheet]] | * [[Excel-call#Sheet|Sheet]] | ||
| + | |||
| + | Its attributes are: | ||
| + | {|class="gvtable" | ||
| + | ! Attribute !! Type !! Description | ||
| + | |- | ||
| + | | type || required || Must be: | ||
| + | * DBOSelect : select | ||
| + | * DBOInsert : insert | ||
| + | * DBOUpdate : update | ||
| + | * DBOInsertOrUpdate : insert|update | ||
| + | * DBOUpdateOrInsert : insert|update | ||
| + | * DBOCallSP : callsp | ||
| + | * Excel Sheet : select | ||
| + | The attribute's admitted values are: | ||
| + | * select | ||
| + | * insert | ||
| + | * update | ||
| + | * callsp | ||
| + | The attribute's value cannot be null. | ||
| + | |- | ||
| + | | id || optional || 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: | ||
| + | <syntaxhighlight lang="XML"><RowSet> | ||
| + | <data key_2="GreenVulcano"> | ||
| + | <row><col>19</col> <col>pippo</col> </row> | ||
| + | <row> <col>25</col> <col>pluto</col> </row> | ||
| + | </data> | ||
| + | </RowSet> | ||
| + | </syntaxhighlight> | ||
| + | Can specify multiple keys separated by commas. | ||
| + | The attribute's value cannot be null. | ||
| + | |} | ||
| + | |||
| + | Does not contain subelements. | ||
Revision as of 13:28, 12 November 2012
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 | 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 attribute's value cannot be null. |
Does not contain subelements.
