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.

Name

Description

Resources

Online Training CoursesOur 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 VideosChoose from videos cover ECL concepts, the SORT and JOIN functions or take a tour of our ECL IDE.Choose a video
How To Video LibraryFind 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 SheetA simple introduction to ECL — so you can master it with easeGuide
ECL Language ReferenceLearn 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.Guide
ECL Programmers GuideTry 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 ReferenceLearn about utility functions for string handling, date manipulation and more.Guide
ECL Best PracticesTips, 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.

Guide

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

Guide

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