Difference between revisions of "Statement"

From GreenVulcano Wiki
Jump to: navigation, search
({{GVESB}} Configuration)
({{GVESB}} Configuration)
Line 42: Line 42:
 
* Update: identifies the statement to be used to process the input row parameters.
 
* Update: identifies the statement to be used to process the input row parameters.
 
The attribute's value cannot be null.
 
The attribute's value cannot be null.
Incremental IDs are required if DBO uses a transformation, while same IDs (usually the default one) is required for each statement when not using a transformation.
 
 
|-
 
|-
 
| keys || optional || Only useful in DBOSelect.
 
| keys || optional || Only useful in DBOSelect.

Revision as of 11:19, 5 April 2016

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:

Its attributes are:

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

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.