Integrate Software AG Products Using Digital Event Services : MashZone NextGen Help : Appendix : Legacy Presto components : MashZone NextGen Analytics : RAQL Extension to EMML Statements for Mashups : <loadfrom>
<loadfrom>
Loads a dataset from one named In-Memory Store into the specified variable. Data is streamed and may only load a specific set of rows from the dataset based on a time period specified.
Important:  
The semantics of this statement have changed significantly in this release fromMashZone NextGen version 3.6. The version attribute identifies which semantics are used.
For information on 3.6 semantics and the available attributes, see<loadfrom> forMashZone NextGen3.6.
For examples of this statement see Load Data from the MashZone NextGen Analytics In-Memory Stores.
Can Contain
Empty
Allowed In
mashup | catch | else | elseif | for | foreach | if | macro | operation | sequence | try | while
Attributes
Name
Required
Description
version
The version of RAQL that is used in this statement. This version affects what attributes are required and the meaning of some attributes in <loadfrom>.
Possible values are:
*1.0 = the initial version of RAQL released in MashZone NextGen 3.6. See <loadfrom> forMashZone NextGen3.6 for information on the available attributes when this version is in effect.
*2.0 = the default. This is the current version of RAQL.
cache
yes
The name of the In-Memory Store where the dataset to load resides.
Note:  
Store names can be a literal value or you can assign them dynamically using mashup expressions. See Dynamic Mashup Expressions for more information.
For dynamic In-Memory Stores, this name is a simple string. For declared In-Memory Stores, this name is in the form data-source-name.store-name. See Declared Versus Dynamic In-Memory Stores for more information.
variable
yes
The name of the variable to hold the dataset or specific rows to retrieve. This variable must have been explicitly declared previously in the mashup.
period
Defines an optional time period used to retrieve specific rows in the dataset based on their timestamp. Valid time periods include:
*ns = the last n seconds
*nm = the last n minutes
*nh = the last n hours
*nd = the last n days
*nw = the last n weeks
*n = with no period specified, this defaults to the last n minutes
fetchsize
The numbers of rows to request from the In-Memory Store at one time during loading. This can be used to fine tune performance with very large datasets or datasets with a large number of columns per row.
Copyright © 2017 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback