ECL Programmers Guide ECLProgrammers 6.4.4 1

• ECL Programmers Guide
• Table of Contents
• ECL Programming Concepts
  • Attribute Creation
    • Similarities and Differences
    • “Atomic” Programming
    • Growing Solutions
    • “Ugly” ECL is Possible, Too
    • Easy Optimization
  • Creating Example Data
    • Getting Code Files
    • Generating Files
    • Some Constants
    • The RECORD Structures
    • Starting Point Data
    • Generating Parent Records
    • Generating Child Records
    • Create the Nested Child Dataset Records
    • Write Files to Disk
    • Defining the Files
  • Cross-Tab Reports
    • A Simple CrossTab
    • A More Complex Example
    • A Statistical Example
  • Efficient Value Type Usage
    • Numeric Data Type Selection
      • Integer Data
      • Floating Point Data
    • String Data Type Selection
      • STRING vs. VARSTRING
      • STRING vs. QSTRING
      • Fixed Length vs. Variable Length Strings
    • User-Defined Data Types
      • RECORD Structure
      • TYPE Structure
      • TypeDef Attributes
  • Using the GROUP Function
    • GROUP vs. SORT
    • Performance Considerations
  • Automated ECL
    • Using Text Files
  • Job “Failure”
  • Non-Random RANDOM
  • Working with XML Data
    • Simple XML Data Handling
    • Complex XML Data Handling
    • Input with Complex XML Formats
    • Piping to Third-Party Tools
  • Working with BLOBs
    • Spraying BLOB Data
    • Working with BLOB Data
    • Despraying BLOB Data
  • Using ECL Keys (INDEX Files)
    • Simple FETCH
    • Full-keyed JOIN
    • Half-keyed JOIN
    • Payload INDEXes
    • Computed Fields in Payload Keys
    • Computed Fields in Search Keys
    • Using an INDEX like a DATASET
• Working With SuperFiles
  • SuperFile Overview
    • SuperFile Existence Functions
    • SuperFile Inquiry Functions
    • SuperFile Maintenance Functions
    • SuperFile Transactions
    • Other Useful Functions
  • Creating and Maintaining SuperFiles
    • Creating Data
    • A Simple Example
    • Nesting SuperFiles
    • Nested SuperFile Example
    • Data Consolidation
    • Getting SuperFile Components
  • Indexing into SuperFiles
    • SuperFiles vs. SuperKeys
    • There is a Problem
    • And the Solution Is ...
  • Using SuperKeys
    • Building SuperKeys
    • Creating a SuperKey
    • Using a SuperKey
    • Maintaining SuperKeys
• Working With Roxie
  • Roxie Overview
    • Thor
    • Roxie
    • hThor
    • How to Structure Roxie Queries
    • Testing Queries
    • Deploying Queries to Roxie
  • SOAP-enabling Queries
    • The ECL Key to SOAP
    • Putting It All Together
  • Complex Roxie Query Techniques
    • Key Selection Based on Input
    • Keyed Joins
    • Limiting Output
  • SOAPCALL from Thor to Roxie
    • One Record Input, Record Set Return
    • Record Set Input, Record Set Return
    • Performance Considerations: PARALLEL
    • Performance Considerations: MERGE
    • A Real World Example
  • Controlling Roxie Queries
    • How Graphs Execute
    • ALLNODES vs. THISNODE
    • LOCAL vs. NOLOCAL
    • NOROOT Indexes
  • Query Libraries
    • Library INTERFACE Definition
    • Library MODULE Definitions
    • Building an External library
    • Using a Query Library
      • Internal Libraries
      • External Libraries
    • Query Library Tips
    • Restrictions
    • Notes on the implementation
    • Suggested Structure
      • Naming Conventions
      • Use an INTERFACE to define parameters
      • Hide the LIBRARY
      • Use MODULE Inheritance
  • Smart Stepping
    • Overview
    • Trailing Field Sorts
    • N-ary JOINs
• Getting Things Done
  • Cartesian Product of Two Datasets
  • Records Containing Any of a Set of Words
  • Simple Random Samples
  • Hex String to Decimal String
  • File Layout Resolution at Compile Time
    • Using LOOKUP on a DATASET
    • Using LOOKUP in a RECORDOF function
    • Additional Details
• Embedded Languages and Data stores
  • Code Signing, Embedded languages, and Security
    • ECLCC Configuration Settings
    • Code Signing