User`s guide

Contents
vi
Sybase IQ ETL 4.1
Project component ................................................................ 121
Synchronizer component....................................................... 122
Multi-Project component........................................................ 123
Finish component.................................................................. 124
Error component.................................................................... 124
APPENDIX A Function Reference ..................................................................... 125
uAvg............................................................................................. 126
uMax ............................................................................................ 126
uMin ............................................................................................. 126
uBitAnd......................................................................................... 127
uBitOr........................................................................................... 127
uBitXOr......................................................................................... 128
uBitNot ......................................................................................... 128
uIsAscending................................................................................ 128
ulsBoolean ................................................................................... 129
ulsDate......................................................................................... 129
ulsDescending.............................................................................. 130
ulsInteger ..................................................................................... 130
ulsFloat......................................................................................... 131
ulsNull .......................................................................................... 131
ulsNumber.................................................................................... 131
uNot.............................................................................................. 132
uBase64Decode........................................................................... 132
uBase64Encode........................................................................... 133
uConvertDate ............................................................................... 133
uFromHex .................................................................................... 135
uToHex......................................................................................... 135
uHexDecode ................................................................................ 135
uHexEncode................................................................................. 136
uToUnicode.................................................................................. 136
uURIDecode................................................................................. 136
uURIEncode................................................................................. 137
uDate............................................................................................ 140
uDateTime.................................................................................... 141
uDay............................................................................................. 141
uDayOfYear ................................................................................. 142
uHour ........................................................................................... 142
uQuarter....................................................................................... 142
uIsoWeek ..................................................................................... 143
uJuliandate................................................................................... 144
uMinute ........................................................................................ 144
uMonth ......................................................................................... 145
uMonthName................................................................................ 145