Extended Systems OneBridge 4.1 Guida Utente Pagina 148
- Pagina / 222
- Indice
- RISOLUZIONE PROBLEMI
- SEGNALIBRI
Valutato. / 5. Basato su recensioni clienti
uConvertDate
134 Sybase IQ ETL 4.1
Table 6-1: Date Conversion identifiers
Syntax string uConvertDate(datestring, inputformat [,
outputformat])
Parameters
string datestring
The string to convert.
string inputformat
The date and time format of the input string.
string outputformat
(optional) The desired output format. If omitted, the default format is y-M-
D H:N:S.
Examples To convert date strings into a different formats:
uConvertDate("2005-06-27 00:00:00","y-M-D H:N:S","D
mY") // returns "27 JUN 05"
uConvertDate("27 JUN 05", "D m Y") // returns "2005-06-
27 00:00:00"
Identifier Description
Y Year 2-digits (06)
y Year 4-digits (2006)
C Century (20)
M Month (03)
m Month (JUN)
DDay (12)
H Hour (00..23)
h Hour (01..12)
NMinutes
S Seconds
s Hundreths of seconds
t Thousandth of seconds
AAM/PM
d Day of week (5)
D Day of week (Friday)
E Day of year (001..366)
G Week of year (01..52)
F Week of month (1..6)
- 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
Prodotti e manuali riguardandi Server Extended Systems OneBridge 4.1
(88 pagine)© 2020, manymanuals.it. Tutti i diritti riservati | 0.062 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commenti su questo manuale