Extended Systems OneBridge 4.1 Guide de l'utilisateur Page 66
- Page / 222
- Table des matières
- DEPANNAGE
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
Customizing SQL and transformation rules
52 Sybase IQ ETL 4.1
Using expressions and procedures
An expression is a combination of identifiers and operators that can calculate
a single value. A simple expression can be a variable, a constant, an attribute,
or a scalar function. Operators can be used to join two or more simple
expressions into a complex expression.
Examples of expressions are:
'Miller'
uConcat("Time ", "goes by")
(uMid(SA_ORDERDATE, 1, 10) >= '1998-01-01')
[uTracelevel(3)]
A procedure is a programming unit that includes expressions, statements, and
control structures. A procedure can be written in JavaScript.
Examples of procedures are:
if (IN.PR_PRICE < 250)
OUT.PR_GROUP2 = 'low end' ;
else {
if (IN.PR_PRICE < 1000)
OUT.PR_GROUP2 = 'mid range';
else
OUT.PR_GROUP2 = 'high end';
}
Including variables
A variable is a symbolic name for a value. There are two basic properties of a
variable:
•Scope
• Datatype
The scope of a variable decides in which scope of the environment the variable
can be referenced.
There are:
• Port variables
• Component variables
- 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
Produits connexes et manuels pour Serveurs Extended Systems OneBridge 4.1
(88 pages)© 2020, manymanuals.fr. Tous droits réservés | 0.066 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels