User`s guide

User’s Guide 203
A
aggregation functions
uAVg 126
uMax 126
uMin 126
architecture
GRID 191
IQ ETL 1
B
bit functions
uBitAnd 127
uBitNot 128
uBitOr 127
uBitXOr 128
boolean functions
ulsAscending 128
ulsBoolean 129
ulsDate 129
ulsDescending 130
ulsFloat 131
ulsInteger 130
ulsNull 131
ulsNumber 131
uNot 132
C
Character Mapper 99
client user session
closing 11
command line parameters for ETL Server 195
Component Store
Development desktop 16
grouping components 16
components
adding a component 16
adding component variables 76
allowing dynamic expressions 15
applying component variables 14
Component Store 16
deleting a component 16
editing component variables 14
encrypting properties 15, 77
entering database connection parameters 71
evaluating SBN expressions 77
grouping components 16
port structure and mapping 3
providing descriptions 76
removing a component variable 15
setting required properties 70
setting up a component 71
stepping record-by-record 2
variables and ports 3
Content Explorer 45
creating queries 47
generating SELECT statements 46
modifying default setting of a join 48
opening 46
conversion functions
uBase64Decode 132
uBase64Encode 133
uConvertDate 133
uFromHex 135
uHexDecode 135
uHexEncode 136
uToHex 135
uToUnicode 136
uURIDecode 136
uURIEncode 137
D
Data Calculator 93
data calculator
Index