Index

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

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

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

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

Q

QSTRING, QSTRING
QSTRING string constants, String
QSTRING value type, QSTRING
query library, MODULE Structure, BUILD
quicksort, Sorting Algorithms
QUOTE, CSV Files, OUTPUT CSV Files

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