Symbols
- #APPEND, #APPEND
- #BREAK, #LOOP / #BREAK
- #CONSTANT, #CONSTANT
- #DECLARE, #DECLARE
- #DEMANGLE, #DEMANGLE
- #ELSE, #IF
- #ELSEIF, #IF
- #END, #LOOP / #BREAK
- #ERROR, #ERROR
- #EXPAND, #EXPAND
- #EXPORT, #EXPORT
- #EXPORTXML, #EXPORTXML
- #FOR, #FOR
- #GETDATATYPE, #GETDATATYPE
- #IF, #IF
- #IFDEFINED, #IFDEFINED
- #INMODULE, #INMODULE
- #ISDEFINED, #ISDEFINED
- #LOOP, #LOOP / #BREAK
- #MANGLE, #MANGLE
- #ONWARNING, #ONWARNING
- #OPTION, #OPTION
- #SET, #SET
- #STORED, #STORED
- #TEXT, #TEXT
- #UNIQUENAME, #UNIQUENAME
- #WARNING, #WARNING
- #WEBSERVICE, #WEBSERVICE
- #WORKUNIT, BUILD a Query Library, #WORKUNIT
- .ECL files, Definition Visibility
- .SO, External Service Implementation
- __COMPRESSED__, THOR/FLAT Files
- __CONTAINERIZED__, Compile Time Constants
- __ECL_LEGACY_MODE__, Compile Time Constants
- __ECL_VERSION_MAJOR__, Compile Time Constants
- __ECL_VERSION_MINOR__, Compile Time Constants
- __ECL_VERSION__, Compile Time Constants
- __OS__, Compile Time Constants
- __PLATFORM__, Compile Time Constants
- __STAND_ALONE__, Compile Time Constants
- __TARGET_PLATFORM__, Compile Time Constants
A
- ABS, ABS
- ABS function, ABS
- ACOS, ACOS
- ACOS function, ACOS
- Actions as Definitions, Actions as Definitions
- Addition, Arithmetic Operators
- AFTER, APPLY
- AGGREGATE, AGGREGATE
- AGGREGATE function, AGGREGATE
- ALL, ALL, DEDUP, GROUP, Options, OUTPUT, Named OUTPUT, PARSE Text Data, XMLENCODE
- ALL keyword, ALL
- ALLNODES, ALLNODES
- ALLNODES function, ALLNODES
- AND, BETWEEN Operator, Field Inheritance
- AND NOT, Field Inheritance
- ANY, Passing Typeless Parameters
- APPLY, APPLY
- APPLY function, APPLY
- arguments, Function Definitions (Parameter Passing)
- arithmetic operators, Arithmetic Operators
- AS, IMPORT
- ASCII, CSV Files, ASCII, OUTPUT CSV Files
- ASCII function, ASCII
- ASIN, ASIN
- ASIN function, ASIN
- ASSERT, ASSERT
- ASSERT function, ASSERT
- ASSTRING, ASSTRING
- ASSTRING function, ASSTRING
- ATAN, ATAN
- ATAN function, ATAN, ATAN2
- ATAN2, ATAN2
- ATAN2 function, ATAN2
- ATMOST, Options, PARSE Text Data
- AVE, AVE
- AVE function, AVE
B
- BEFORE, APPLY
- BEGINC++, BEGINC++ Structure
- BEGINC++ Structure, BEGINC++ Structure
- BEST, DEDUP, PARSE Text Data, TOPN
- BETWEEN, BETWEEN Operator
- Between Operator, BETWEEN Operator
- BIG_ENDIAN, INTEGER
- Binary values, Numeric
- Bitshift Left, Bitshift Operators
- Bitshift operators, Bitshift Operators
- Bitshift Right, Bitshift Operators
- Bitwise AND, Bitwise Operators
- Bitwise Exclusive OR, Bitwise Operators
- Bitwise NOT, Bitwise Operators
- Bitwise operators, Bitwise Operators
- Bitwise OR, Bitwise Operators
- BLOB in INDEX, Field Modifiers
- Boolean, Basic Definition Types
- BOOLEAN, BOOLEAN, GETISVALID
- Boolean AND, Logical Operators
- Boolean Definition, Boolean Definitions, Recordset Filtering
- Boolean NOT, Logical Operators
- Boolean OR, Logical Operators
- BOOLEAN value type, BOOLEAN
- BUILD, BUILD
- BUILD action, INDEX, Payload INDEX
C
- CASE, CASE, PARSE Text Data
- CASE function, CASE
- casting operator, Explicit Casting
- Casting Rules, Casting Rules
- CATCH, CATCH
- CATCH Function, CATCH
- Character Sets, Set Ordering and Indexing
- CHECKPOINT, CHECKPOINT
- CHECKPOINT workflow service, CHECKPOINT
- Child Dataset, Child DATASETs
- child dataset records, Child DATASETs
- CHOOSE, CHOOSE
- CHOOSE function, CHOOSE
- CHOOSEN, DATASET, Child DATASETs, CHOOSEN
- CHOOSEN function, CHOOSEN
- CHOOSESETS, CHOOSESETS
- CHOOSESETS function, CHOOSESETS
- CLUSTER, Index BUILD Options, OUTPUT Thor/Flat Files, OUTPUT CSV Files, OUTPUT XML Files, OUTPUT JSON Files, PERSIST
- CLUSTERSIZE, CLUSTERSIZE
- COMBINE, COMBINE
- COMBINE function, COMBINE
- comparison operator, Comparison Operators, UNICODEORDER
- COMPRESSED, THOR/FLAT Files, INDEX, OUTPUT Thor/Flat Files
- COMPRESSION, Index BUILD Options
- Concatenation, String Operators, Child DATASETs
- CONST, Function Definitions (Parameter Passing), ASSERT, CONST
- CONST Function, CONST
- Constant set, Set Definitions
- constant values, Set Definitions, In-line DATASETs
- constants, String, Compile Time Constants
- CORRELATION, CORRELATION
- CORRELATION function, CORRELATION
- COS, COS
- COS function, COS
- COSH, COSH
- COSH function, COSH
- COUNT, DATASET, Child DATASETs, COUNT, LIMIT, ROWDIFF, WHEN
- COUNT function, COUNT
- COUNTER, Child DATASETs, SKIP, TRANSFORM Functions, DENORMALIZE TRANSFORM Function Requirements, GRAPH, Join Types: Two Datasets, LOOP, TRANSFORM Function Requirements - PROJECT
- COVARIANCE, COVARIANCE
- COVARIANCE function, COVARIANCE
- CPU pinning, Available options
- CRON, CRON
- CRON function, CRON
- CSV, CSV Files, PIPE Files, OUTPUT, OUTPUT CSV Files, OUTPUT PIPE Files, PIPE
- CSV Files, CSV Files, OUTPUT CSV Files
D
- DATA, DATA
- Data string, String
- DATA value type, DATA
- Dataset, Record Set Definitions
- DATASET, DATASET, CSV Files, DATASET as a Parameter Type, Temporary SuperFiles, Index BUILD Options, SOAPCALL
- DATASET declaration, File Scope, Temporary SuperFiles
- DATASET parameter, Passing DATASET Parameters
- DATASET parameters, DATASET
- DECIMAL, DECIMAL
- DECIMAL value type, DECIMAL
- Decimal values, Numeric
- DEDUP, Index BUILD Options, DEDUP, MERGE, MERGEJOIN
- DEDUP function, DEDUP, Complex Record Set Conditions, ROLLUP
- DEFAULT, Field Modifiers
- DEFINE, DEFINE
- DEFINE function, DEFINE
- Definition Name, Definition Name Rules
- Definition Operator, Definitions
- Definition Types, Basic Definition Types
- Definition Visibility, Definition Visibility, Definition Visibility Rules
- Definitions as Actions, Definitions as Actions
- DENORMALIZE, DENORMALIZE
- DENORMALIZE function, DENORMALIZE
- DEPRECATED, DEPRECATED
- DEPRECATED workflow service, DEPRECATED
- DESCEND, RANK, RANKED
- DICTIONARY, DICTIONARY
- DICTIONARY parameter, Passing DICTIONARY Parameters
- DISTINCT statement in SQL, DEDUP
- DISTRIBUTE, Index BUILD Options, DISTRIBUTE
- DISTRIBUTE function, DISTRIBUTE
- DISTRIBUTED, INDEX, Index BUILD Options, DISTRIBUTED
- DISTRIBUTED function, DISTRIBUTED
- DISTRIBUTION, DISTRIBUTION
- DISTRIBUTION action, WORKUNIT
- DISTRIBUTION function, DISTRIBUTION
- Division, Arithmetic Operators
- Division by zero, Arithmetic Operators
- dot syntax, Imported Definitions
- Dynamic Files, Dynamic Files
E
- EBCDIC, CSV Files, EBCDIC, OUTPUT CSV Files
- EBCDIC function, EBCDIC
- ECL, Overview
- ECL definition, Definitions
- ECL IDE, String
- ECL keywords, Reserved Words
- EMBED, EMBED Structure
- EMBED Structure, EMBED Structure
- ENCODING, SOAPCALL
- ENCRYPT, THOR/FLAT Files, CSV Files, XML Files, JSON Files, OUTPUT Thor/Flat Files, OUTPUT CSV Files, OUTPUT XML Files, OUTPUT JSON Files
- ENDC++, BEGINC++ Structure
- ENDEMBED, EMBED Structure
- ENDMACRO, MACRO Structure
- ENTH, CHOOSESETS, ENTH
- ENTH function, ENTH
- ENUM, ENUM
- ENUM datatype, ENUM
- Equivalence, Comparison Operators, ParsePattern Definitions
- Equivalence Comparison, Comparison Operators
- ERROR, ERROR
- ERROR function, ERROR, FAIL
- ESCAPE, CSV Files
- EVALUATE, EVALUATE action
- EVALUATE action, EVALUATE action
- EVALUATE function, EVALUATE function
- EVENT, EVENT
- EVENT function, EVENT
- EVENTEXTRA, EVENTEXTRA
- EVENTEXTRA function, EVENTEXTRA
- EVENTNAME, EVENTNAME
- EXCEPT, EXCEPT
- EXCEPT keyword, EXCEPT
- EXCLUSIVE, CHOOSESETS
- EXISTS, EXISTS
- EXISTS function, EXISTS
- EXP, EXP
- EXP function, EXP, LN
- EXPIRE, Index BUILD Options, KEYDIFF, KEYPATCH, OUTPUT Thor/Flat Files, OUTPUT CSV Files, OUTPUT XML Files, OUTPUT JSON Files, PERSIST
- Explicit Casting, Explicit Casting
- EXPORT, "Global", LOAD, EXPORT
- EXPORTed, Imported Definitions
- EXPORTed Definitions, Imported Definitions
- Expression, Definitions
- Expressions, Expressions and Operators
- Expressions and Operators, Expressions and Operators
- Expressions as Actions, Expressions as Actions
- EXTEND, OUTPUT, Named OUTPUT
- Extended PARSE, Extended PARSE Examples
- Extended PARSE Examples, Extended PARSE Examples
- External Service, External Service Implementation
- external system services, External Service Implementation
F
- FAIL, ASSERT, CATCH, FAIL
- FAIL action, ERROR, FAIL
- FAILCODE, FAILCODE
- FAILCODE function, FAILCODE
- FAILMESSAGE, CATCH, FAILMESSAGE, HTTPCALL, SOAPCALL
- FAILMESSAGE function, FAILMESSAGE
- FAILURE, FAILURE
- FAILURE workflow service, FAILCODE, FAILURE
- FALSE, BOOLEAN, TRUE and FALSE
- FALSE keyword, TRUE and FALSE
- FETCH, FETCH
- FETCH function, FETCH
- FEW, AGGREGATE, Index BUILD Options, CHOOSEN, GLOBAL, Options, SORT, TABLE, GLOBAL - Service, STORED - Workflow Service
- field sequence, #WEBSERVICE
- File Scope, File Scope
- FILEPOSITION, Index BUILD Options
- Filters, Recordset Filtering
- FIRST, INDEX, Index BUILD Options, PARSE Text Data
- FLAT, THOR/FLAT Files
- Flat Files, OUTPUT Thor/Flat Files
- floating point, REAL
- FOLD, Keywords
- Foreign files, Foreign Files
- FORMAT, OUTPUT CSV Files
- FORWARD, MODULE Structure
- forward reference, Definitions versus Actions, ParsePattern Definitions, DEFINE
- FROM, IMPORT
- FROMJSON, FROMJSON
- FROMJSON function, FROMJSON
- FROMUNICODE, FROMUNICODE
- FROMUNICODE function, FROMUNICODE
- FROMXML, FROMXML
- FROMXML function, FROMXML
- FULL ONLY, Join Types: Two Datasets
- FULL OUTER, Join Types: Two Datasets
- FUNCTION, FUNCTION Structure
- FUNCTION Structure, FUNCTION Structure
- FUNCTIONMACRO, FUNCTIONMACRO Structure
- FUNCTIONMACRO Structure, FUNCTIONMACRO Structure
- Functions, Function Definitions (Parameter Passing)
G
- GETENV, GETENV
- GETENV function, GETENV
- GETISVALID, GETISVALID
- GLOBAL, GLOBAL, GLOBAL - Service
- GLOBAL function, GLOBAL
- GLOBAL workflow service, GLOBAL, GLOBAL - Service
- GRAPH, GRAPH
- GRAPH function, GRAPH
- Greater or Equal, Comparison Operators
- Greater Than, Comparison Operators
- GROUP, GROUP keyword, COMBINE, DENORMALIZE, PIPE, ROLLUP
- Group, GROUP
- GROUP function, GROUP, UNGROUP
- GROUP keyword, GROUP keyword, VARIANCE
- GROUPED, DATASET, DATASET as a Parameter Type, Options
H
- HASH, DEDUP, HASH, Options
- HASH function, HASH
- HASH32 function, HASH32
- HASH64, HASH32, HASH64
- HASH64 function, HASH64
- HASHCRC, HASHCRC
- HASHCRC function, HASHCRC
- HASHMD5, HASHMD5
- HASHMD5 function, HASHMD5
- HAVING, HAVING
- HAVING function, HAVING
- HEADING, CSV Files, OUTPUT CSV Files, OUTPUT XML Files, OUTPUT JSON Files, SOAPCALL
- heapsort, Sorting Algorithms
- Hexadecimal, String, Numeric
- HPCC, Overview
- hthor, Sorting Algorithms
- HTTPCALL, HTTPCALL
- HTTPCALL Function, HTTPCALL
- HTTPCALL Options, HTTPCALL
- HTTPHEADER, HTTPCALL, SOAPCALL
I
- IF, IF
- IF function, IF
- IFBLOCK, RECORD Structure
- IFF, IFF
- IFF function, IFF
- Implicit Casting, Implicit Casting
- Implicit Dataset, Implicit Dataset Relationality
- Implicit Dataset Relationality, Implicit Dataset Relationality
- IMPORT, IMPORT
- IMPORT AS, IMPORT
- IMPORT FROM, IMPORT
- IMPORTed, Imported Definitions
- IN, IN Operator
- In Line Dataset, In-line DATASETs
- IN Operator, IN Operator
- in-line a set of data, In-line DATASETs
- In-Line Dataset, In-line DATASETs
- INCLUDE, Keywords
- INDEPENDENT, INDEPENDENT
- INDEPENDENT workflow service, INDEPENDENT
- INDEX, INDEX
- INDEX declaration, INDEX
- Indexing, Set Ordering and Indexing
- Inline TRANSFORMs, Inline TRANSFORMs, Shorthand Inline TRANSFORMs
- INNER, Join Types:
- insertionsort, Sorting Algorithms
- INTEGER, Numeric, INTEGER, PHYSICALLENGTH, Passing Set Parameters to a Service
- Integer Division, Arithmetic Operators
- INTEGER value type, INTEGER
- INTERFACE, INTERFACE Structure
- interface, STORED
- INTERFACE Structure, INTERFACE Structure
- INTERNAL, LIBRARY
- INTFORMAT, INTFORMAT
- INTFORMAT function, INTFORMAT
- ISVALID, ISVALID
- ISVALID function, ISVALID
- ITERATE, ITERATE
- ITERATE function, ITERATE
J
- JOIN, JOIN, JOIN Set of Datasets
- JOIN function, JOIN, JOIN Set of Datasets
- JOIN Set, JOIN Set of Datasets
- JOIN setofdatasets, TRANSFORM Function Requirements - JOIN setofdatasets
- Join Types, Join Types:
- joincondition, KEYED and WILD, Matching Logic - JOIN
- JOINED, SORT
- joinflags, Options
- JOINS FULL OUTER, Join Logic
- JSON, JSON Files, OUTPUT, OUTPUT JSON Files
- JSON Files, OUTPUT JSON Files
K
- KEEP, DEDUP, Options, PARSE Text Data
- KEYDIFF, KEYDIFF
- KEYDIFF function, KEYDIFF
- KEYED, KEYED and WILD, AVE, CORRELATION, COUNT, COVARIANCE, EXISTS, Options, LIMIT, MIN, PROJECT, SUM, TABLE, VARIANCE
- Keyed JOIN, Keyed Joins
- KEYED Keyword, KEYED and WILD
- KEYPATCH, KEYPATCH
- KEYPATCH action, KEYDIFF
- KEYPATCH function, KEYPATCH
- KEYUNICODE, KEYUNICODE
- KEYUNICODE function, KEYUNICODE
L
- Landing Zone files, Landing Zone Files
- LAST, CHOOSESETS
- LEFT, LEFT and RIGHT, DENORMALIZE TRANSFORM Function Requirements, NORMALIZE
- LEFT ONLY, Join Types: Two Datasets, Join Types:
- LEFT OUTER, Join Types: Two Datasets, Join Types:
- LENGTH, DATASET, Child DATASETs, LENGTH
- LENGTH function, LENGTH
- Less or Equal, Comparison Operators
- Less Than, Comparison Operators
- LIBRARY, MODULE Structure, LIBRARY
- LIBRARY function, BUILD a Query Library, LIBRARY
- LIKELY, LIKELY and UNLIKELY
- LIMIT, Options, LIMIT
- LIMIT function, LIMIT
- LINKCOUNTED, DATASET, DATASET as a Parameter Type
- LITERAL, SOAPCALL
- LITTLE_ENDIAN, INTEGER
- LN, LN
- LN function, EXP, LN
- LOAD, LOAD
- LOADXML, LOADXML
- LOADXML function, LOADXML
- LOCAL, Local, AGGREGATE, Index BUILD Options, COMBINE, DEDUP, DENORMALIZE, ENTH, FETCH, GROUP, ITERATE, Options, LOCAL, MERGE, PROCESS, PROJECT, ROLLUP, SORT, TABLE, TOPN
- LOCAL function, INDEX, LOCAL
- LOCALE, RECORD Structure
- LOG, LOG, SOAPCALL
- LOG function, LOG
- LOGICAL Filenames, Scope and Logical Filenames
- Logical graphs, Available options
- logical operators, Logical Operators, Field Inheritance
- LOOKUP, Options
- LOOP, LOOP
- LOOP function, GRAPH, LOOP
- loopbody, LOOP
- loopcondition, LOOP
- loopcount, LOOP
- loopfilter, LOOP
- LZW, INDEX, Index BUILD Options
M
- MACRO, MACRO Structure
- MACRO Structure, MACRO Structure
- MANY, AGGREGATE, GLOBAL, Options, PARSE Text Data, TABLE
- MAP, MAP
- MAP function, MAP
- MATCHED, NLP RECORD and TRANSFORM Functions, PARSE Text Data
- MATCHED ALL, PARSE Text Data
- MATCHLENGTH, NLP RECORD and TRANSFORM Functions
- MATCHPOSITION, NLP RECORD and TRANSFORM Functions
- MATCHROW, NLP RECORD and TRANSFORM Functions
- MATCHTEXT, NLP RECORD and TRANSFORM Functions
- MATCHUNICODE, NLP RECORD and TRANSFORM Functions
- MAX, PARSE Text Data, SIZEOF
- MAX function, MAX
- MAXCOUNT, Field Modifiers
- MAXLENGTH, RECORD Structure, Field Modifiers, CSV Files, INDEX, MAXLENGTH, Index BUILD Options, PARSE
- memory exhausted, Options
- MERGE, Index BUILD Options, MERGE, SOAPCALL, TABLE
- MERGE function, MERGE
- MERGEJOIN, MERGEJOIN
- MERGEJOIN function, JOIN Set of Datasets, MERGEJOIN
- MIN, MIN, PARSE Text Data
- MIN function, MIN
- MODULE, MODULE Structure
- MODULE Structure, MODULE Structure
- Modulus Division, Arithmetic Operators
- MOFN, Join Types:
- MULTIPLE, PERSIST
- Multiplication, Arithmetic Operators
N
- N-ary merge/join, GRAPH
- Name, Definitions
- NAMED, Passing NAMED Parameters, DISTRIBUTION, OUTPUT, Named OUTPUT, OUTPUT Scalar Values
- NAMED OUTPUT, Named OUTPUT
- Named Output Dataset, Named Output DATASETs
- NAMESPACE, SOAPCALL
- Natural Language Parsing, Parsing Support
- Nested child datasets, Implicit Dataset Relationality
- NOCASE, PARSE Text Data, REGEXFIND, REGEXFINDSET, REGEXREPLACE
- NOFOLD, NOFOLD, Keywords
- NOFOLD function, NOFOLD
- NOLOCAL, NOLOCAL
- NOLOCAL function, NOLOCAL
- non-procedural language, Definitions versus Actions
- NONEMPTY, NONEMPTY
- NONEMPTY function, NONEMPTY
- NORMALIZE, NORMALIZE
- NORMALIZE function, NORMALIZE
- NOROOT, XML Files, JSON Files, Index BUILD Options
- NOSCAN, PARSE Text Data
- NOSORT, DENORMALIZE, Options
- Not Equal, Comparison Operators
- NOT MATCHED, PARSE Text Data
- NOT MATCHED ONLY, PARSE Text Data
- NOTHOR, NOTHOR
- NOTHOR action, NOTHOR
- NOTIFY, NOTIFY
- NOTIFY function, NOTIFY
- NOTRIM, CSV Files, SOAPCALL
- NOXPATH, OUTPUT
O
- ONCE, ONCE, Keywords
- ONCE workflow service, ONCE
- ONFAIL, CATCH, HTTPCALL, LIMIT, SOAPCALL
- ONWARNING, ONWARNING
- ONWARNING workflow service, ONWARNING
- Operators, Expressions and Operators
- OPT, THOR/FLAT Files, INDEX, KEYED and WILD, OUTPUT XML Files, OUTPUT JSON Files, PROJECT - Module
- OR, Field Inheritance
- ORDERED, ORDERED
- ORDERED action, ORDERED
- OUTPUT, OUTPUT, OUTPUT Thor/Flat Files, OUTPUT CSV Files, OUTPUT XML Files, OUTPUT JSON Files, Named OUTPUT, OUTPUT Scalar Values, PIPE
- OUTPUT - CSV Files, OUTPUT CSV Files
- OUTPUT - JSON Files, OUTPUT JSON Files
- OUTPUT - NAMED Files, Named OUTPUT
- OUTPUT - XML Files, OUTPUT XML Files
- OUTPUT action, OUTPUT
- OUTPUT Pipe Files, OUTPUT PIPE Files
- OUTPUT Scalar Values, OUTPUT Scalar Values
- OUTPUT Thor/Flat Files, OUTPUT Thor/Flat Files
- OUTPUT Workunit Files, OUTPUT Workunit Files
- OVERWRITE, Index BUILD Options, KEYDIFF, KEYPATCH, OUTPUT Thor/Flat Files, OUTPUT CSV Files, OUTPUT XML Files, OUTPUT JSON Files
P
- PACKED, RECORD Structure
- packed decimal, DECIMAL
- packed hexadecimal, DATA
- PARALLEL, PARALLEL, PROJECT, SOAPCALL
- PARALLEL action, OUTPUT Scalar Values
- PARALLEL function, PARALLEL
- Parameter Passing, Function Definitions (Parameter Passing)
- parameters, Definitions
- PARSE, PARSE, PARSE Text Data
- PARSE Examples, Extended PARSE Examples
- PARSE function, NLP RECORD and TRANSFORM Functions, PARSE
- PARSE Text, PARSE Text Data
- PARSE XML, PARSE XML Data
- PARTITION LEFT, Options
- PARTITION RIGHT, Options
- Passing a DATASET parameter, DATASET as a Parameter Type
- Passing Set Parameters, Passing Set Parameters to a Service
- PATTERN, PARSE Pattern Value Types
- Perl regular expression, REGEXFIND, REGEXFINDSET, REGEXREPLACE
- PERSIST, SOAPCALL, PERSIST
- PERSIST workflow service, PERSIST
- PHYSICALLENGTH, PHYSICALLENGTH
- Pipe, PIPE Files
- PIPE, OUTPUT, OUTPUT PIPE Files, PIPE
- PIPE Files, PIPE Files
- PIPE function, PIPE Files, PIPE
- Pool memory exhausted, Options
- POWER, POWER
- POWER function, POWER
- PREFETCH, PROJECT
- PRELOAD, THOR/FLAT Files, PRELOAD
- PRELOAD function, PRELOAD
- PRIORITY, PRIORITY
- PRIORITY workflow service, PRIORITY
- PROCESS, PROCESS
- PROCESS function, PROCESS
- processor affinity, Available options
- PROJECT, PROJECT, PROJECT - Module
- PROJECT function, PROJECT
- PULL, PULL
- PULL function, PULL
- PURE, Keywords
R
- RANDOM, RANDOM
- RANDOM function, RANDOM
- RANGE, RANGE
- RANGE function, RANGE
- RANK, RANK
- RANK function, RANK
- RANKED, RANKED
- RANKED function, RANKED
- REAL, REAL, Passing Set Parameters to a Service
- REAL data type, REAL
- REALFORMAT, REALFORMAT
- REALFORMAT Function, REALFORMAT
- RECORD, RECORD Structure
- record matching, Matching Logic
- Record Matching Logic, Matching Logic
- Record Set, Basic Definition Types, Record Set Definitions, Recordset Filtering, Record Set Operators
- Record Set Definition, Record Set Definitions
- Record Set Operators, Record Set Operators
- RECORD structure, Record Set Operators, RECORD Structure, XML Files, JSON Files, In-line DATASETs, TYPE Structure, NLP RECORD and TRANSFORM Functions, XML Parsing RECORD and TRANSFORM Functions, SELF, Transformation Attribute Definitions, PARSE Text Data, PROJECT, TABLE, VARIANCE
- RECORD Structure, RECORD Structure
- RECORDOF, RECORDOF
- RECORDOF datatype, RECORDOF
- RECOVERY, RECOVERY
- RECOVERY workflow service, RECOVERY
- recstruct, ROW Form 1
- REFRESH, PERSIST
- regex, REGEXFIND, REGEXFINDSET, REGEXREPLACE
- REGEXFIND, REGEXFIND
- REGEXFIND function, REGEXFIND
- REGEXFINDSET, REGEXFINDSET
- REGEXFINDSET function, REGEXFINDSET
- REGEXREPLACE, REGEXREPLACE
- REGEXREPLACE function, REGEXREPLACE
- REGROUP, REGROUP
- REGROUP function, REGROUP
- regular expression, PARSE Pattern Value Types
- REJECTED, REJECTED
- REJECTED function, REJECTED, WHICH
- Relationality, Implicit Dataset Relationality
- REPEAT, OUTPUT PIPE Files, PIPE
- Reserved Words, Reserved Words
- resultrec, ROW Form 2
- RETRY, HTTPCALL, SOAPCALL
- RETURN, Scope Resolution Operator, FUNCTION Structure, FUNCTIONMACRO Structure
- RIGHT, LEFT and RIGHT, DENORMALIZE TRANSFORM Function Requirements
- RIGHT ONLY, Join Types: Two Datasets
- RIGHT OUTER, Join Types: Two Datasets
- RIGHT1, AGGREGATE
- RIGHT2, AGGREGATE
- ROLLUP, ROLLUP
- ROLLUP function, ROLLUP, SORT
- ROUND, ROUND
- ROUND function, ROUND
- ROUNDUP, ROUNDUP
- ROUNDUP function, ROUNDUP
- ROW, INDEX, Index BUILD Options, ROW
- ROW function, LIBRARY Modules, ROW
- ROWDIFF, ROWDIFF
- ROWDIFF function, ROWDIFF
- ROWS(LEFT), ROWS(LEFT) and ROWS(RIGHT)
- ROWS(RIGHT), ROWS(LEFT) and ROWS(RIGHT)
- ROWSET, GRAPH
- ROWSET(LEFT), GRAPH
- Roxie, LOCAL, Sorting Algorithms
- Roxie CPU pinning, Available options
- Roxie processor affinity, Available options
- RULE, PARSE Pattern Value Types
- runtime constants, Compile Time Constants
- runtime expressions, Compile Time Constants
S
- SAMPLE, SAMPLE
- SAMPLE function, SAMPLE
- Scalar OUTPUT, OUTPUT Scalar Values
- SCAN, PARSE Text Data
- SCAN ALL, PARSE Text Data
- Scope, Definitions
- SCOPE, Scope and Logical Filenames
- SELF, SELF, TRANSFORM Structure
- SELF keyword, SELF
- SEPARATOR, CSV Files, OUTPUT CSV Files
- SEQUENTIAL, SEQUENTIAL
- SEQUENTIAL function, SEQUENTIAL
- Service Function Keywords, Keywords
- SERVICE Structure, APPLY, SERVICE Structure, SERVICE Structure - external
- SERVICE structure, Passing Set Parameters to a Service
- Set, Basic Definition Types
- SET, Function Definitions (Parameter Passing), SET
- Set Definition, Set Definitions
- SET function, Set Definitions, SET
- SET OF, SET OF
- SET OF value type, SET OF
- Set Operators, Set Operators
- Set Ordering, Set Ordering and Indexing
- SET parameters, SET Parameters
- Set Parameters, Passing Set Parameters to a Service
- Sets can contain definitions and expressions, Set Definitions
- SHARED, Module, SHARED
- Shared Object, External Service Implementation
- SIN, SIN
- SIN function, SIN
- SINGLE, OUTPUT CSV Files, PERSIST
- Single Row Dataset, Single-row DATASET Expressions
- Single-Row Dataset, Single-row DATASET Expressions
- SINH, SINH
- SINH function, SINH
- SIZEOF, SIZEOF
- SIZEOF function, SIZEOF
- SKEW, Index BUILD Options, DISTRIBUTE, Options, SORT, TABLE
- SKIP, SKIP, TRANSFORM Structure, CATCH, Options, LIMIT, PARSE Text Data
- SMART, Options
- SOAPACTION, SOAPCALL
- SOAPCALL, XPATH Support, SOAPCALL, SOAPCALL Function
- SOAPCALL Action, SOAPCALL Action
- SOAPCALL Function, SOAPCALL, SOAPCALL Function
- SOAPCALL Options, SOAPCALL
- SORT, SORT
- sort algorithms, Sorting Algorithms
- SORT function, SORT
- SORTED, INDEX, Index BUILD Options, JOIN, JOIN Set of Datasets, MERGE, MERGEJOIN, SORTED
- SORTED function, SORTED
- SQRT, SQRT
- SQRT function, SQRT
- square brackets, Optional Items, Set Definitions, Function Definitions (Parameter Passing), SET OF
- STABLE, SORT
- STEPPED, STEPPED
- STEPPED function, STEPPED
- STORE, STORE
- STORED, STORED, STORED - Workflow Service
- STORED function, STORED
- STORED workflow service, STORED - Workflow Service
- STREAMED, DATASET, DATASET as a Parameter Type
- String, Set Ordering and Indexing
- STRING, STRING
- string constants, String
- string operator, String Operators
- string slice, Set Ordering and Indexing
- STRING value type, STRING
- STRINGn, Passing Set Parameters to a Service
- substring, Set Ordering and Indexing
- Subtraction, Arithmetic Operators
- SUCCESS, SUCCESS
- SUCCESS workflow service, SUCCESS
- SUM, SUM
- SUM function, SUM
- SuperFile, Temporary SuperFiles
- system constants, Compile Time Constants
T
- TABLE, Fields in Datasets, TABLE
- TABLE function, Scope Resolution Operator
- TABLE Function, TABLE
- TAN, TAN
- TAN Function, TAN
- TANH, TANH
- TANH Function, TANH
- Template Language, Template Language Overview
- Temporary SuperFile, Temporary SuperFiles
- TERMINATOR, CSV Files, OUTPUT CSV Files
- THISNODE, THISNODE
- THISNODE Function, THISNODE
- THOR, THOR/FLAT Files, OUTPUT, OUTPUT Workunit Files
- Thor, Sorting Algorithms
- THRESHOLD, Index BUILD Options, Options, SORT, TABLE
- TIMELIMIT, HTTPCALL, SOAPCALL
- TIMEOUT, HTTPCALL, SOAPCALL
- TOJSON, TOJSON
- TOJSON function, TOJSON
- TOKEN, PARSE Pattern Value Types
- Tomita parsing, PARSE Text Data
- TOPN, TOPN
- TOPN Function, TOPN
- TOUNICODE, TOUNICODE
- TOUNICODE Function, TOUNICODE
- TOXML, TOXML
- TOXML function, TOXML
- TRACE, TRACE
- traceEnabled, TRACE
- traceLimit, TRACE
- TRANSFER, TRANSFER
- TRANSFER Function, TRANSFER
- TRANSFORM, TRANSFORM Structure
- transform function, FETCH TRANSFORM Function Requirements, TRANSFORM Function Requirements - ITERATE, TRANSFORM Function Requirements - JOIN
- TRANSFORM Function, TRANSFORM Function Requirements - PROCESS, TRANSFORM Function Requirements - PROJECT
- TRANSFORM Function Requirements, TRANSFORM Function Requirements - PROCESS, TRANSFORM Function Requirements - PROJECT
- Transform Requirement Process, TRANSFORM Function Requirements - PROCESS
- Transform Requirement Project, TRANSFORM Function Requirements - PROJECT
- Transform Requirements, TRANSFORM Function Requirements - PROCESS, TRANSFORM Function Requirements - PROJECT
- TRANSFORM structure, SELF, SKIP, TRANSFORM Structure, FAILCODE, FAILMESSAGE, ROW Form 1
- Treating DICTIONARY as a DATASET, DATASET from DICTIONARY
- TRIM, HTTPCALL, OUTPUT XML Files, OUTPUT JSON Files, SOAPCALL, TRIM
- TRIM Function, TRIM
- TRIM OPT, OUTPUT XML Files, OUTPUT JSON Files
- TRUE, BOOLEAN, TRUE and FALSE
- TRUE keyword, TRUE and FALSE
- TRUNCATE, TRUNCATE
- TRUNCATE Function, TRUNCATE
- TYPE, TYPE Structure
- Type Casting, Type Casting
- TYPE structure, RECORD Structure, TYPE Structure
- Type Transfer, Type Transfer
- TypeDef, Basic Definition Types
- TypeDef Definition, TypeDef Definitions
- TYPEOF, TYPEOF
- TYPEOF data type, TYPEOF
U
- UDECIMALn, DECIMAL
- UNGROUP, UNGROUP
- UNGROUP Function, UNGROUP
- UNICODE, UNICODE, CSV Files, OUTPUT CSV Files
- Unicode string, String
- UNICODE value type, UNICODE
- UNICODEORDER, UNICODEORDER
- UNICODEORDER function, UNICODEORDER
- UNLIKELY, LIKELY and UNLIKELY
- UNORDERED, Options, UNORDERED
- UNORDERED function, UNORDERED
- UNSIGNED, INTEGER, DECIMAL
- UNSIGNED value type, INTEGER
- Unsigned values, Numeric
- UNSORTED, THOR/FLAT Files, TABLE
- UNSTABLE, SORT
- UPDATE, Index BUILD Options, OUTPUT Thor/Flat Files, OUTPUT CSV Files, OUTPUT XML Files, OUTPUT JSON Files
- USE, PARSE Text Data
- UTF-8, String
- UTF8, UTF8
- UTF8 string, String
- UTF8 value type, UTF8
V
- valid identifier, Definition Name Rules
- Value, Basic Definition Types
- Value Definition, Value Definitions
- Value Type, Definitions
- Value Types, Function Definitions (Parameter Passing), Value Types
- VARIANCE, VARIANCE
- VARSTRING, VARSTRING
- VARSTRING string constants, String
- VARSTRING value type, VARSTRING
- VARUNICODE, VARUNICODE
- VARUNICODE value type, VARUNICODE
- Virtual, Field Modifiers
- VIRTUAL, MODULE Structure
- VIRTUAL EXPORT, EXPORT
- Virtual fileposition, Field Modifiers
- Virtual localfileposition, Field Modifiers
- Virtual logicalfilename, Field Modifiers
- VIRTUAL SHARED, SHARED
W
- WAIT, WAIT
- WAIT Function, WAIT
- WHEN, WHEN, WHEN
- WHEN Function, WHEN
- WHEN workflow service, CRON, EVENT, WHEN
- WHICH, WHICH
- WHICH function, REJECTED
- WHICH Function, WHICH
- WHITESPACE, TRIM
- WHOLE, PARSE Text Data
- WIDTH, Index BUILD Options
- WILD, KEYED and WILD
- WILD index filter, KEYED and WILD
- WILD Keyword, KEYED and WILD
- WORKUNIT, DATASET, WORKUNIT
- Workunit, Named Output DATASETs
- WORKUNIT Function, WORKUNIT
- Workunit OUTPUT, OUTPUT Workunit Files
- WUID, WORKUNIT
X
- XML, XML Files, PIPE Files, OUTPUT, OUTPUT XML Files, OUTPUT PIPE Files, PARSE, PIPE
- XML Files, OUTPUT XML Files
- XMLDECODE, XMLDECODE
- XMLDECODE Function, XMLDECODE
- XMLDEFAULT, Field Modifiers
- XMLENCODE, XMLENCODE
- XMLENCODE Function, XMLENCODE
- XMLPROJECT, XML Parsing RECORD and TRANSFORM Functions
- XMLTEXT, XML Parsing RECORD and TRANSFORM Functions
- XMLUNICODE, XML Parsing RECORD and TRANSFORM Functions
- XOR Operator, An XOR Operator
- XPATH, Field Modifiers, HTTPCALL, SOAPCALL
- XPATH support, XPATH Support