Extended Systems OneBridge 4.1 Betriebsanweisung Seite 21
- Seite / 222
- Inhaltsverzeichnis
- FEHLERBEHEBUNG
- LESEZEICHEN
Bewertet. / 5. Basierend auf Kundenbewertungen
CHAPTER 1 Sybase IQ ETL
User’s Guide 7
• Implements most of SQL92.
• A complete database is stored in a single disk file.
• Database files can be freely shared between machines with different byte
orders.
• Supports databases up to 2 terabytes (241 bytes) in size.
• Sizes of strings and BLOBs limited only by available memory.
• Small code footprint: less than 30K lines of C code, less than 250KB code
space (gcc on i486).
• Faster than popular client/server database engines for most common
operations.
• Easy-to-use API.
• TCL bindings included. Bindings for many other languages available
separately.
• Well-commented source code with over 95% test coverage.
• Self-contained: no external dependencies.
• Sources are in the public domain and can be used for any purpose.
More information about SQLite can be found
at www.sqlite.org.
- Sybase IQ ETL 1
- DC00608-01-0410-01 2
- October 2006 2
- Contents 3
- User’s Guide vii 7
- User’s Guide ix 9
- Sybase IQ ETL 4.1 10
- About This Book 11
- Sybase IQ ETL 4.1 12
- About This Book 13
- If you need help 14
- Projects and jobs 16
- Component concepts 16
- Running a project 17
- Customizing a project 17
- Understanding repositories 18
- CHAPTER 1 Sybase IQ ETL 19
- Unicode support 20
- Expressions 20
- Internal database 20
- 8 Sybase IQ ETL 4.1 22
- Sybase IQ ETL Development 23
- Using the Navigator 24
- Administering the repository 25
- Administering user accounts 27
- Using the Properties section 28
- Using the Design section 29
- Adding components 30
- Customizing preferences 31
- User’s Guide 19 33
- 20 Sybase IQ ETL 4.1 34
- Getting Started 35
- Creating your first project 36
- Adding a data sink 37
- Adding a data calculator 38
- Simulating the project 39
- 26 Sybase IQ ETL 4.1 40
- Projects and Jobs 41
- Managing projects 42
- User’s Guide 29 43
- ❖ To simulate a project 43
- Viewing current mappings 45
- Managing port attributes 46
- Viewing a simulation flow 46
- User’s Guide 33 47
- User’s Guide 35 49
- Managing jobs 50
- Executing a job 51
- Cancelling job execution 52
- Creating Jobs 52
- Building a migration template 54
- User’s Guide 41 55
- Managing a migration template 57
- 44 Sybase IQ ETL 4.1 58
- Advanced Concepts and Tools 59
- Opening Content Explorer 60
- Using the Design area 60
- Creating queries 61
- Content Explorer 62
- User’s Guide 49 63
- Evaluate property is 65
- Including variables 66
- Using functions 67
- Using Square Bracket Notation 68
- Entering SQL statements 68
- Entering queries 69
- Validating queries 69
- Query designer 69
- SELECT * FROM 70
- PRODUCT [uTracelevel(5)] 70
- User’s Guide 57 71
- Features 71
- Edit and Debug mode 72
- User’s Guide 59 73
- ❖ To step through the code 73
- ❖ To step to a Breakpoint 73
- Special JavaScript features 74
- Analyzing performance data 77
- Example reports 79
- Project execution history 80
- User’s Guide 67 81
- 68 Sybase IQ ETL 4.1 82
- Components 83
- Setting required properties 84
- Setting up a component 85
- Overview 86
- Creating a SQLite table 89
- Evaluating SBN expressions 91
- Encrypting properties 91
- Modifying components 92
- Data blocks and visualization 92
- Managing port structures 93
- DB Data Provider Index Load 97
- Text Data Provider 99
- Properties 100
- CHAPTER 6 Components 101
- XML via SQL Data Provider 102
- Optional properties 103
- Source components 104
- Transformation components 107
- Character Mapper 113
- Using Lookup components 115
- Required properties 116
- DB Lookup Dynamic component 118
- Staging components 121
- Processing components 123
- Destination components 124
- DB Data Sink Update component 127
- DB Data Sink Delete component 129
- Text Data Sink 130
- Job components 135
- Synchronizer component 136
- Multi-Project component 137
- Finish component 138
- Error component 138
- Function Reference 139
- Aggregation functions 140
- Bit functions 141
- Boolean functions 142
- Sybase IQ ETL 4.1 144
- 1 if the parameter is null 145
- Conversion functions 146
- Date and time functions 151
- now modifier 154
- Errorhandling functions 163
- File functions 166
- Formatting functions 168
- Fuzzy search functions 170
- Lookup functions 171
- IF construct: 172
- Miscellaneous functions 174
- 166 Sybase IQ ETL 4.1 180
- 168 Sybase IQ ETL 4.1 182
- 170 Sybase IQ ETL 4.1 184
- Network functions 185
- Numeric functions 186
- Script functions 191
- String functions 191
- Operator functions 200
- Trigonometric functions 202
- Sybase ETL Server 205
- Communication 206
- Using the server 206
- GRID Engine Server 206
- Stop a server 207
- Install as a System Service 207
- Troubleshooting 208
- Command line parameters 209
- INI file settings 210
- Default.ini 211
- GridNode.ini 211
- 198 Sybase IQ ETL 4.1 212
- Queuing and Executing 213
- Process Calls 213
- Configuring ProcessQ calls 214
- 202 Sybase IQ ETL 4.1 216
- 204 Sybase IQ ETL 4.1 218
- 206 Sybase IQ ETL 4.1 220
- 208 Sybase IQ ETL 4.1 222
Verwandte Produkte und Handbücher für Server Extended Systems OneBridge 4.1
(88 Seiten)© 2020, manymanuals.de. Alle Rechte vorbehalten. | 0.049 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Kommentare zu diesen Handbüchern