User`s guide

viii Sybase IQ ETL 4.1
uPow, uPower .............................................................................. 175
uRandom...................................................................................... 175
uRound......................................................................................... 175
uSgn ............................................................................................. 176
uSqrt............................................................................................. 176
uEvaluate...................................................................................... 177
uAsc, uUnicode ............................................................................ 177
uChr, uUniChr............................................................................... 178
uCap............................................................................................. 178
uConcat, uCon.............................................................................. 179
uJoin............................................................................................. 179
uLeft.............................................................................................. 180
uLength, uLen............................................................................... 180
uSubstr, uMid ............................................................................... 180
uLPos ........................................................................................... 181
uLower, uLow ............................................................................... 181
uLStuff .......................................................................................... 182
uLTrim .......................................................................................... 182
uRepeat........................................................................................ 182
uReplace ...................................................................................... 183
uReverse ...................................................................................... 183
uRight ........................................................................................... 184
uRPos........................................................................................... 184
uRStuff.......................................................................................... 184
uRTrim.......................................................................................... 185
uTrim ............................................................................................ 185
uUpper, uUpp ............................................................................... 186
uEQ .............................................................................................. 186
uNE............................................................................................... 186
uGT............................................................................................... 187
uGe............................................................................................... 187
uLT ............................................................................................... 188
uLE ............................................................................................... 188
uAcos............................................................................................ 188
uAsin............................................................................................. 189
uAtan ............................................................................................ 189
uCos ............................................................................................. 189
uSin .............................................................................................. 190
uTan ............................................................................................. 190
APPENDIX B Sybase ETL Server...................................................................... 191
GRID architecture......................................................................... 191
Communication...................................................................... 192
Using the server..................................................................... 192