Friday, 10 January 2014

DECLARE statement

DECLARE statement

Use the DECLARE statement to define a variable, the data type of the variable and, optionally, its initial value.
You can define three types of variable with the DECLARE statement:
  • External
  • Normal
  • Shared
The following types of broker node can access UDPs(USER DEFINED PROPERTY):
  • Compute node
  • Database node
  • Filter node
  • Nodes that are derived from these node types
Take care when specifying the data type of a UDP, because a CAST is used to change the value to the requested DataType.
Example 1:
DECLARE mycolor EXTERNAL CHARACTER 'blue'; 

Example 2:
DECLARE TODAYSCOLOR EXTERNAL CHARACTER;
SET COLOR = TODAYSCOLOR;
where TODAYSCOLOR is a user-defined property that has a TYPE of CHARACTER and a VALUE set by the Message Flow editor.


No comments:

Post a Comment