I'm new to ECL, how do I get started?

There are a number of resources you can use to get started, including online training courses, videos, tutorials and guides, to help you learn the basics. When you're ready, there are other resources available to help you extend your knowledge of the ECL language.







Online Training Courses

Our beginner courses are free and are a prerequisite for taking some subsequent courses. Find out the learning track for your needs and see the course content.

Choose a course

Training Videos

Choose from videos cover ECL concepts, the SORT and JOIN functions or take a tour of our ECL IDE.

Choose a video

How To Video Library

Find out how to get started quickly on our cloud native platform, use the ECL Command Line and learn some tips and tricks for using some of the more in demand ECL Language features.

Go to the How To Video Library

ECL Cheat Sheet

A simple introduction to ECL — so you can master it with ease


ECL Language Reference

Learn all you need to know about the ECL language starting with the basics. ECL was designed specifically for the processing of large quantities of data fast and efficiently. Every query you write can be leveraged by other queries which means that the language extends itself as you use it. This guide also contains details about reserved words, special structures, built-in functions and actions, workflow services, template language and using external services.


ECL Programmers Guide

Try out some ECL language features. Download some example code and use your chosen development environment (for example our ECL IDE) to see how a sample of the most commonly used ECL language features work.  Learn about ECL programming concepts, working with super files, using Roxie and embedded languages and datastores.

Guide (English)

Guide (Chinese)

Code files

ECL Standard Library Reference

Learn about utility functions for string handling, date manipulation and more.


ECL Best Practices

Tips, tricks and best practices for coding in ECL. Learn about syntax, including naming conventions, indentation and how to avoid syntax errors cause by 'lost parentheses'. Find out why SET definitions are more practical than multiple OR conditions and learn how to translate your ECL idea into ECL code. Our Developer Forum Tips and Tricks area is also a great place to find out about other ways our users have found to solve their challenges using ECL.


Go to our Developer Forum

Client Tools

Learn how to master the following command line features:

  • ECL command line interface syntax

  • ECL Compiler as a stand-alone option for the compiler

  • DFUPlus - Used to facilitate the automation of data file spray, despray, and other common file handling tasks

  • ESDL command syntax


All pages in this wiki are subject to our site usage guidelines.