User`s guide

Index
204 Sybase IQ ETL 4.1
adding to a project 24
data formats
converting 5
data provider
adding to a project 22
data sink
adding to a project 23
setting properties 24
Data Splitter 109
data transformation projects
creating 3, 4
database connection
connecting to SQLite database 75
entering parameters 71
datatypes
converting 5
date and time functions
format of time strings 137
uDate 140
uDateTime 141
uDay 141
uDayOfYear 142
uHour 142
uIsoWeek 143
uJuliandate 144
uMinute 144
uMonth 145
uMonthName 145
uMonthNameShort 145
uQuarter 142
uSeconds 146
uTimeDiffMs 146
uWeek 147
uWeekday 147
uWeekdayName 148
uWeekdayNameShort 148
uYear 149
DB Bulk Load Sybase IQ 119
DB Data Provider Full Load 81
DB Data Provider Index Load 83
DB Data Sink Delete 115
DB Data Sink Insert 110
DB Data Sink Update 113
DB Lookup 101
DB Lookup Dynamic 104
DB Staging 107
Design section
creating queries 47
Development desktop 15
generating SELECT commands 46
destination components
DB Bulk Load Sybase IQ 119
DB Data Sink Delete 115
DB Data Sink Insert 110
DB Data Sink Update 113
Text Data Sink 116
Development desktop
Component Store 16
Content Explorer 45
customizing preferences 17
example of 9
generating SELECT commands 46
layout 9
opening Content Explorer 46
the Design section 15
the Navigator 10
the Properties section 14
E
error log 49
errorhandling functions
uError 149
uErrortext 150
uInfo 150
uTrace 151
uTracelevel 151
uWarning 150
ETL Server application
command line parameters 195
GRID architecture 191
GRID engine as a Windows System Service 193
INI file settings 196
overview 191
stopping a server 193
using the server 192
execution properties
resetting 28
execution.log 49