SML Statements found within a Transform

Section - TM Language Reference

SML provides a complete language with which  to describe the transformation of data from a source to target data model.  While the majority of these statements will be constructed automatically via the "drag and drop" process of designing the transform, they may also be entered by hand.

SML statements:

• Angle Brackets < > -  indicate that the text between them is to be treated as a literal name.
• Arithmetic
• Assignment := - used to indicate that something is to be taken from the source and used to set, construct or find an item in the target.
• BEGIN... END - The BEGIN ... END block is required within certain structures to group together a set of logically-related statements
• BREAK - may be used to stop iteration of FOR_EACH and REPEAT loops.
• Built-in Functions - are provided for commonly required operations.
• CASE ... END_CASE - provides a structure for controlling conditional processing when a particular test can result in a value other than TRUE or FALSE.
• CATCH_ERROR - The statements inside a CATCH_ERROR block are executed if an error occurs in the transformation.
• Comments - SML supports comments that fit on a single line or run over several lines.
• Conditional Test Operators
• Constants
• Explicit Offsets  - provide a mechanism for explicitly reading values within a path.
• FOR_EACH.... OVER - performs iteration over an aggregate relationship.
• IF ... THEN ... ELSE  - used to conditionally executes a group of statements, depending on the value of an expression. 
• MODIFIERS - change the way identifiers are treated.
• Operators - reserved symbols and operators which provide basic data manipulation functions.
• REPEAT .. TIMES - performs a set of related statements a specific number of times.
• THIS THAT - used to remove ambiguity about references to source (THIS) and target (THAT) data stores
• Variables