Part X. CTL2 - CloverETL Transformation Language

Table of Contents

63. Overview
64. Language Reference
Program Structure
Comments
Import
Data Types in CTL2
byte
cbyte
date
decimal
integer
long
number (double)
string
list
map
record
Literals
Variables
Dictionary in CTL2
Operators
Arithmetic Operators
Relational Operators
Logical Operators
Assignment Operator
Ternary Operator
Conditional fail expression
Simple Statement and Block of Statements
Control Statements
Conditional Statements
Iteration Statements
Jump Statements
Error Handling
Functions
Message Function
Conditional Fail Expression
Accessing Data Records and Fields
Mapping
Parameters
Regular Expressions
65. CTL Debugging
Debug Perspective
Importing and Exporting Breakpoints
Exporting Breakpoints
Importing Breakpoints
Inspecting Variables and Expressions
Inspect Action
Expressions View and Watch Action
Examples
Basic Example
Using Hit Count
Conditional Breakpoint
Detecting Changes of the Value
66. Functions Reference
Conversion Functions
Date Functions
Mathematical Functions
String Functions
Mapping Functions
Container Functions
Record Functions (dynamic field access)
Miscellaneous Functions
Lookup Table Functions
Sequence Functions
Subgraph functions
Data Service HTTP Library functions
Custom CTL Functions
List of All CTL2 Functions
CTL2 Appendix - List of National-specific Characters