User`s guide

User’s Guide 125
APPENDIX A
Function Reference
This appendix provides a reference for the Sybase IQ ETL functions.
Note Even if your original data is not coded in UNICODE, and you have
used one of the "u"-functions, the returned data has been converted to
UNICODE and needs to be handled accordingly.
Topic Page
Aggregation functions 126
Bit functions 127
Boolean functions 128
Conversion functions 132
Date and time functions 137
Errorhandling functions 149
File functions 152
Formatting functions 154
Fuzzy search functions 156
Lookup functions 157
Miscellaneous functions 160
Network functions 171
Numeric functions 172
Script functions 177
String functions 177
Operator functions 186
Trigonometric functions 188