SAP Business objects DATA INTEGRATOR Reference Guide
Data Integrator Reference Guide
Data Integrator Reference Guide
Data Integrator 11.0.1
Windows and UNIX operating systems
Copyright
If you find any problems with this documentation, please report them to Business Objects
S.A. in writing at documentation@businessobjects.com.
Copyright © Business Objects S.A. 2004. All rights reserved.
Trademarks
Patents
Business Objects, the Business Objects logo, Crystal Reports, and Crystal Enterprise are
trademarks or registered trademarks of Business Objects SA or its affiliated companies in the
United States and other countries. All other names mentioned herein may be trademarks of
their respective owners.
Business Objects owns the following U.S. patents, which may cover products that are offered
and sold by Business Objects: 5,555,403, 6,247,008 B1, 6,578,027 B2, 6,490,593 and
6,289,352.
2 Data Integrator Reference Guide
Contents
Chapter 1 Introduction 15
Who should read this guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16
Business Objects information resources . . . . . . . . . . . . . . . . . . . . . . . 17
Chapter 2 Data Integrator Objects 21
Object classes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
Reusable objects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
Single-use objects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24
Object options, properties, and attributes . . . . . . . . . . . . . . . . . . . . . . 25
Descriptions of objects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
Annotation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
Batch Job . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29
Catch . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37
Conditional . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43
COBOL copybook file format . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44
Data flow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52
Datastore . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54
Document . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 97
DTD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 98
File format . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109
Function . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 119
Log . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 120
Message function . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125
Outbound message . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 126
Project . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 127
Query transform . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 128
Real-time job . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 129
Script . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 133
Data Integrator Reference Guide 3
Contents
Source . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .134
Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .138
Target . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .142
Template table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .179
Transform . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .181
Try . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 182
While loop . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .183
Work flow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .184
XML file . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .187
XML message . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .190
XML Schema . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .192
XML template . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 208
Chapter 3 Smart Editor 209
Smart editor toolbar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .213
Editor Library pane . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .214
Tabs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .214
Find option . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .215
Editor pane . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .216
Syntax coloring . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .216
Selection list and tool tips . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 216
Right-click menu and toolbar . . . . . . . . . . . . . . . . . . . . . . . . . . . .218
Validation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .218
Chapter 4 Data Types 221
date . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .224
datetime . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .226
decimal . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .227
double . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .228
int . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .229
interval . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 230
long . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .231
numeric . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .235
4 Data Integrator Reference Guide
Contents
real . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 236
time . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 237
timestamp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 238
varchar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 239
Data type processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 240
Date arithmetic . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 240
Type conversion . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 241
Conversion to/from Data Integrator internal data types . . . . . . . 241
Conversion of data types within expressions . . . . . . . . . . . . . . . 252
Conversion among number data types . . . . . . . . . . . . . . . . . . . . 253
Conversion between explicit data types . . . . . . . . . . . . . . . . . . . 255
Chapter 5 Transforms 257
Operation codes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 258
Descriptions of transforms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 259
Address_Enhancement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 261
Case . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 268
Date_Generation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 271
Effective_Date . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 273
Hierarchy_Flattening . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 277
History_Preserving . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 286
Key_Generation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 292
Map_CDC_Operation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 294
Map_Operation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 302
Match_Merge . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 305
Merge . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 313
Name_Parsing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 315
Pivot (Columns to Rows) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 322
Reverse Pivot (Rows to Columns) . . . . . . . . . . . . . . . . . . . . . . . 327
Query . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 330
Row_Generation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 352
SQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 353
Table_Comparison . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 359
Data Integrator Reference Guide 5
Contents
Validation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .366
Chapter 6 Functions and Procedures 375
Functions compared with transforms . . . . . . . . . . . . . . . . . . . . . . . . . 377
Operation of a function . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .377
Arithmetic in date functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .378
Including functions in expressions . . . . . . . . . . . . . . . . . . . . . . . . . . .378
Kinds of functions you can use in Data Integrator . . . . . . . . . . . . . . . .381
Custom functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .382
Database and application functions . . . . . . . . . . . . . . . . . . . . . . .388
Descriptions of built-in functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 388
abs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .395
add_months . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .396
avg . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .397
ceil . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .398
concat_date_time . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .399
count . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .400
current_configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .401
current_system_configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . 402
dataflow_name . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .403
datastore_field_value . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 404
date_diff . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .405
date_part . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 406
day_in_month . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 407
day_in_week . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .408
day_in_year . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 409
db_type . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .410
db_version . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 412
db_database_name . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .414
db_owner . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .415
decode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .416
exec . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 418
extract_from_xml . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .423
6 Data Integrator Reference Guide
Contents
file_exists . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 425
fiscal_day . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 426
floor . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 427
gen_row_num . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 428
get_domain_description . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 429
get_env . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 430
get_error_filename . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 431
get_file_attribute . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 432
get_monitor_filename . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 433
get_trace_filename . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 434
host_name . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 435
ifthenelse . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 436
index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 437
init_cap . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 438
interval_to_char . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 439
is_set_env . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 440
is_valid_date . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 441
is_valid_datetime . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 442
is_valid_decimal . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 443
is_valid_double . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 444
is_valid_int . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 445
is_valid_real . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 446
is_valid_time . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 447
isempty . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 448
isweekend . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 449
job_name . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 450
julian . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 451
julian_to_date . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 452
key_generation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 453
last_date . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 454
length . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 455
literal . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 456
load_to_xml . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 458
Data Integrator Reference Guide 7
Contents
long_to_varchar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .461
lookup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 462
lookup_ext . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .468
lookup_seq . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .477
lower . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 482
lpad . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .483
lpad_ext . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 484
ltrim . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .486
ltrim_blanks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 487
ltrim_blanks_ext . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .488
mail_to . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 489
match_pattern . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .491
match_regex . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .493
max . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .499
min . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .500
month . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .501
num_to_interval . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .502
nvl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 503
print . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .504
pushdown_sql . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .505
quarter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .507
raise_exception . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 508
raise_exception_ext . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .509
rand . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 510
replace_substr . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .511
replace_substr_ext . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .512
repository_name . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .515
round . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 516
rpad . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 517
rpad_ext . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .518
rtrim . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 520
rtrim_blanks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .521
rtrim_blanks_ext . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .522
8 Data Integrator Reference Guide
Contents
set_env . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 523
sleep . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 524
sql . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 525
smtp_to . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 527
substr . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 530
sum . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 531
sysdate . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 532
system_user_name . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 533
systime . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 534
table_attribute . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 535
to_char . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 536
to_date . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 537
to_decimal . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 538
total_rows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 539
trunc . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 540
truncate_table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 541
upper . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 542
varchar_to_long . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 543
week_in_month . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 544
week_in_year . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 545
WL_GetKeyValue . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 546
word . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 547
word_ext . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 548
workflow_name . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 550
year . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 551
About procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 552
Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 552
Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 553
Creating stored procedures in a database . . . . . . . . . . . . . . . . . . . . . 554
Creating stored procedures in Oracle . . . . . . . . . . . . . . . . . . . . . 554
Creating stored procedures in MS SQL Server or Sybase ASE . 555
Creating stored procedure in DB2 . . . . . . . . . . . . . . . . . . . . . . . . 556
Importing metadata for stored procedures . . . . . . . . . . . . . . . . . . . . 557
Data Integrator Reference Guide 9
Contents
Structure of a stored procedure . . . . . . . . . . . . . . . . . . . . . . . . . . . . .558
Calling stored procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 559
In general . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .559
From queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 561
Without the function wizard . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 564
Checking execution status . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 565
Chapter 7 Data Integrator Scripting Language 567
Language syntax . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .568
Syntax for statements in scripts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 568
Syntax for column and table references in expressions . . . . . . . . . . .569
Strings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .569
Quotation marks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .570
Escape characters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .570
Trailing blanks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 570
Variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 571
Variable interpolation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .571
Functions and stored procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . .572
Operators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 572
NULL values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .573
NULL values and empty strings . . . . . . . . . . . . . . . . . . . . . . . . . .573
Debugging and Validation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .574
Keywords . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .576
BEGIN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 576
CATCH . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .576
ELSE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 577
END . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 577
IF . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 577
RETURN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .577
TRY . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 577
WHILE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .577
Sample scripts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .578
Square function . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .578
10 Data Integrator Reference Guide
Contents
RepeatString function . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 578
Chapter 8 Metadata in repository tables and views 581
AL_AUDIT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 583
AL_AUDIT_INFO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 584
Imported metadata . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 584
AL_INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 585
AL_PCOLUMN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 585
AL_PKEY . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 586
ALVW_COLUMNATTR . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 586
ALVW_COLUMNINFO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 587
ALVW_FKREL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 588
ALVW_MAPPING . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 588
Example use case . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 589
Mapping types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 590
How mappings are computed . . . . . . . . . . . . . . . . . . . . . . . . . . . 590
Mapping complexities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 592
Storing nested column-mapping data . . . . . . . . . . . . . . . . . . . . . 593
ALVW_TABLEATTR . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 596
ALVW_TABLEINFO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 596
Internal metadata . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 596
AL_LANG . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 597
AL_ATTR . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 598
AL_USAGE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 598
Example use cases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 599
ALVW_FUNCINFO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 601
ALVW_PARENT_CHILD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 601
Metadata Integrator tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 602
AL_CMS_BV . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 603
AL_CMS_BV_FIELDS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 603
AL_CMS_REPORTS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 604
AL_CMS_REPORTUSAGE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 605
AL_CMS_FOLDER . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 606
Data Integrator Reference Guide 11
Contents
AL_CMS_UNV . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 606
AL_CMS_UNV_OBJ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 607
Operational metadata . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .607
AL_HISTORY . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .607
ALVW_FLOW_STAT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .608
Chapter 9 Locales and Multi-Byte Functionality 609
Locale support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .612
Code page support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .614
Processing with and without UTF-16 Unicode . . . . . . . . . . . . . . .614
Minimizing transcoding in Data Integrator . . . . . . . . . . . . . . . . . .616
Guidelines for setting locales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 617
Job Server locale . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .617
Database, database client, and datastore locales . . . . . . . . . . . .618
File format locales . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 619
XML encodings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .619
Locales Data Integrator automatically sets . . . . . . . . . . . . . . . . .620
Exporting and importing ATLs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 620
Exporting to other repositories . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 621
Multi-byte support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .621
Multi-byte string functions supported in Data Integrator . . . . . . . . . . .621
Numeric data types: assigning constant values . . . . . . . . . . . . . . . . .622
Assigning a value as a numeric directly . . . . . . . . . . . . . . . . . . . . 622
Assigning a value in string format . . . . . . . . . . . . . . . . . . . . . . . .622
BOM Characters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .623
Round-trip conversion . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .624
Column Sizing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .624
Sorting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .624
List of supported locales and encodings . . . . . . . . . . . . . . . . . . . . . . . . . . 625
Languages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .626
Territories . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .626
Code pages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .627
XML encodings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .629
12 Data Integrator Reference Guide
Contents
Supported sorting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 630
Limitations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 630
Chapter 10 Reserved Words 633
Data Integrator Reference Guide 13
Contents
14 Data Integrator Reference Guide
Data Integrator Reference Guide
Introduction
chapter
Introduction
1
About this guide
About this guide
Welcome to the The Data Integrator Reference Guide . This guide provides
detailed information about the objects, data types, transforms, and functions
in the Data Integrator Designer.
This book contains the following chapters:
• Chapter 2: Data Integrator Objects — Describes options, properties, and
• Chapter 3: Smart Editor — Describes the editor that can be used to
• Chapter 4: Data Types — Describes the data types used in Data
• Chapter 5: Transforms — Describes the transforms included with Data
• Chapter 6: Functions and Procedures — Describes the functions
• Chapter 7: Data Integrator Scripting Language — Describes the Data
• Chapter 8: Metadata in repository tables and views — Describes the
• Chapter 9: Locales and Multi-Byte Functionality — Describes how Data
• Chapter 10: Reserved Words — Lists words that have special mean ing in
For source-specific information, such as information pertaining to a particular
back-office application, consult the supplement for that application.
attributes for objects, such as data flows and work flows.
create scripts, expressions, custom functions.
Integrator, and how Data Integrator handles data type conversions.
Integrator and how to use these transforms.
included with Data Integrator and how to use these functions.
Integrator scripting language and how you can use this language to
create scripts, expressions, and custom functions.
repository’s reporting tables and views that you can use to analyze an
Data Integrator application.
Integrator supports the setting of locales and multi-byte code pages for
the Designer, Job Server, and Access Server.
Data Integrator. You cannot use these words in names that you create,
such as names of data flows.
Who should read this guide
This and other Data Integrator product documentation assumes the following:
• You are an application developer, consultant or database administrator
working on data extraction, data warehousing, or data integration.
• You understand your source and target data systems, DBMS, legacy
systems, business intelligence, and messaging concepts.
16 Data Integrator Reference Guide
• You understand your organization’s data needs.
• You are familiar with SQL (Structured Query Language).
• If you are interested in using this product to design real-time processing
you are familiar with:
• DTD and XML Schema formats for XML files
• Publishing Web Services (WSDL, HTTP/S and SOAP p rotocols, etc.)
• You are familiar with Data Integrator installation environments: Microsoft
Windows or UNIX.
Business Objects information resources
Consult the Data Integrator Getting Started Guide for:
• An overview of Data Integrator products and architecture
• Data Integrator installation and configuration information
• A list of product documentation and a suggested reading path
After you install Data Integrator, you can view technical documentation from
many locations. To view documentation in PDF format, you can:
• Select Start > Programs > Data Integrator version > Data Integrator
Documentation
• Release Notes
• Release Summary
• Technical Manuals
• Select one of the following from the Designer’s Help menu:
• Release Notes
• Release Summary
• Technical Manuals
• Select Help from the Data Integrator Administrator
You can also view and download PDF documentation by visiting Business
Objects Customer Support online. To access this Web site, you must have a
valid user name and password. To obtain your user name and password, go
to http://www.techsupport.businessobjects.com and click Register.
and choose:
Introduction
About this guide
1
Data Integrator Reference Guide 17
Introduction
1
About this guide
18 Data Integrator Reference Guide
Introduction
About this guide
1
Data Integrator Reference Guide 19
Introduction
1
About this guide
20 Data Integrator Reference Guide
Data Integrator Reference Guide
Data Integrator Objects
chapter
Data Integrator Objects
2
This chapter contains reference information about general Data Integrator
objects, such as data flows, jobs, and work flows. Topics include:
• Characteristics of objects
• Descriptions of objects
Note: For information about source-specific objects, consult the reference
chapter of the Data Integrator supplement document for that source.
22 Data Integrator Reference Guide
Characteristics of objects
This section discusses common characteristics of all Data Integrator objects.
Specifically, this section discusses:
• Object classes
• Object options, properties, and attributes
Object classes
An object’s class determines how you create and retrieve the object. There
are two classes of objects:
• Reusable objects
• Single-use objects
Reusable objects
After you define and save a reusable object, Data Integrator stores the
definition in the repository. You can then reuse the definition as often as
necessary by creating calls to the definition.
Most objects created in Data Integrator are available for reuse. You access
reusable objects through the object library.
A reusable object has a single definition; all calls to the object refer to that
definition. If you change the definition of the object in one place, and then
save the object, the change is reflected to all other calls to the object.
A data flow, for example, is a reusable object. Multiple jobs, such as a weekly
load job and a daily load job, can call the same data flow. If the data flow is
changed, both jobs call the new version of the data flow.
When you drag and drop an object from the object library, you are creating a
new reference (or call) to the existing object definition.
You can edit reusable objects at any time independent of the current open
project. For example, if you open a new project, you can go to the object
library , open a dat a flow, and edit it. The object will remain “dirty” (that is, your
edited changes will not be saved) until you explicitly save it.
Functions are reusable objects that are not available in the object library . Data
Integrator provides access to these objects through the function wizard
wherever they can be used.
Some objects in the object library are not reusable in all instances:
• Datastores are in the object library because they are a method for
categorizing and accessing external metadata.
Data Integrator Objects
Characteristics of objects
2
Data Integrator Reference Guide 23
Data Integrator Objects
2
Characteristics of objects
• Built-in transforms are “reusable” in that every time you drop a transform,
a new instance of the transform is created.
Saving reusable objects
“Saving” a reusable object in Data Integrator means storing the language that
describes the object to the repository. The description of a reusable object
includes these components:
• Properties of the object
• Options for the object
• Calls this object makes to other objects
• Definition of single-use objects called by this object
If an object contains a call to another reusable object, only the call to the
second object is saved, not changes to that object’s definition.
Data Integrator stores the description even if the object does not validate.
Data Integrator saves objects without prompting you:
• When you import an object into the repository.
• When you finish editing:
• Datastores
• Flat file formats
• XML Schema or DTD formats
Y ou can explicitly save the reusable object currently open in the wo rkspace by
choosing
workspace, the
To save all objects in the repository that have changes, choose
the
Data Integrator also prompts you to save all objects that have changes when
you execute a job and when you exit the Designer.
Save from the Project menu. If a single-use object is open in the
Save command is not available.
Save All from
Project menu.
Single-use objects
Single-use objects appear only as components of other objects. They ope rate
only in the context in which they were created.
Saving single-use objects
“Saving” a single-use object in Data Integrator means storing the language
that describes the object to the repository. The description of a single-use
object can only be saved as part of the reusable object that calls the singleuse object.
Data Integrator stores the description even if the object does not validate.
24 Data Integrator Reference Guide
Object options, properties, and attributes
Each object is associated with a set of options, properties, and attributes:
• Options control the operation of an object. For example, in a datastore,
an option is the name of the database to which the datastore connects.
• Properties document an object. For example, properties include the
name, description of an object, and the date on which it was created.
Properties merely describe an object; they do not affect an object’s
operation.
To view properties, right-click an object and select
• Attributes provide additional information about an object. Attribute values
may also affect an object’s behavior.
To view attributes, double-click an object from an editor and click the
Attributes tab.
Descriptions of objects
This section describes each Data Integrator object and tells you how to
access that object.
The following table lists the names and descriptions of objects available in
Data Integrator:
Data Integrator Objects
Descriptions of objects
Properties.
2
Object Class Description
Annotation Single-use Describes a flow, part of a flow, or a diagram in the workspace.
Catch Single-use Specifies the steps to execute if a given error occurs while a job
is running.
COBOL
copybook file
format
Conditional Single-use Specifies the steps to execute based on the result of a
Batch Job Reusable Defines activities that Data Integrator executes at a given time
Data flow Reusable Specifies the requirements for extracting, transforming, and
Reusable Describes the structure defined in a COBOL copybook file.
condition.
including error, monitor and trace messages.
Jobs can be dropped only in the project tree. The object
created is a direct reference to the object in the object library.
Only one reference to a job can exist in the project tree at one
time.
loading data from sources to targets.
Data Integrator Reference Guide 25
Data Integrator Objects
2
Descriptions of objects
Object Class Description
Datastore Single-use Specifies the connection information Data Integrator needs to
access a database or other data source. Cannot be dropped.
Document Reusable Available in certain adapter datastores, documents are data
structures that can support complicated nested schemas.
DTD Reusable A description of an XML file or message. Indicates the format
an XML document reads or writes. See also: XML Schema
File format Reusable Indicates how flat file data is arranged in a source or target file.
Function Reusable Returns a value.
Log Single-use Records information about a particular execution of a single
job.
Message
function
Outbound
message
Project Single-use Groups jobs for convenient access.
Query transform Single-use Retrieves a data set that satisfies conditions that you specify.
Real-time job Reusable Defines activities that Data Integrator executes on-demand.
Script Single-use Evaluates expressions, calls functions, and assigns values to
Source Single-use An object from which Data Integrator reads data in a data flow.
Table Reusable Indicates an external DBMS table for which metadata has been
Target Single-use An object in which Data Integrator loads extracted and
Reusable Available in certain adapter datastores, message functions can
accommodate XML messages when properly configured.
Reusable Available in certain adapter datastores, outbound messages
are XML-based, hierarchical communications that real-time
jobs can publish to adapters.
Real-time jobs are created in the Designer, then configured and
run as services associated with an Access Server in the
Administrator. Real-time jobs are designed according to data
flow model rules and run as a request-response system.
variables.
imported into Data Integrator, or the target table into which data
is or has been placed.
A table is associated with its datastore; it does not exist
independently of a datastore connection. A table retrieves or
stores data based on the schema of the table definition from
which it was created.
transformed data in a data flow.
26 Data Integrator Reference Guide
Data Integrator Objects
Descriptions of objects
Object Class Description
Template table Reusable A new table you want added to a database.
All datastores except SAP R/3 datastores have a default
template that you can use to create any number of tables in the
datastore.
Data Integrator creates the schema for each instance of a
template table at runtime. The created schema is based on the
data loaded into the template table.
Transform Reusable Performs operations on data sets.
Requires zero or more data sets; produces zero or one data set
(which may be split).
Try Single-use Introduces a try/catch block.
While loop Single-use Repeats a sequence of steps as long as a condition is true.
Work flow Reusable Orders data flows and operations supporting data flows.
XML file Single-use A batch or real-time source or target. As a source, an XML file
translates incoming XML-formatted data into data that D
NTEGRATOR can process. As a target, an XML file translates the
I
data produced by a data flow, including nested data, into an
XML-formatted file.
XML message Single-use A real-time source or target. As sources, XML messages
translate incoming XML-formatted requests into data that a
real-time job can process. As targets, XML messages translate
the result of the real-time job, including hierarchical data, into
an XML-formatted response and sends the messages to the
Access Server.
XML Schema Reusable A description of an XML file or message. Indicates the format
an XML document reads or writes. See also: DTD
XML template Single-use A target that creates an XML file that matches a particular input
schema. No DTD or XML Schema is required.
ATA
2
Data Integrator Reference Guide 27
Data Integrator Objects
2
Descriptions of objects
Annotation
Class
Single-use
Access
Click the annotation icon in the tool palette, then click in the workspace.
Description
Annotations describe a flow, part of a flow, or a diagram in a workspace. An
annotation is associated with the job., work flow, or data flow where it
appears. When you import or export that job, work flow, or data flow, you
import or export associated annotations.
For more information, see “Creating annotations” on page 59 of the Data
Integrator Designer Guide.
Note: An annotation has no options or properties.
28 Data Integrator Reference Guide
Data Integrator Objects
Descriptions of objects
Batch Job
Class
Reusable
Access
• In the object library, click the Jobs tab.
• In the project area, select a project and right-click Batch Job.
Description
Note: For information specific to SAP R/3, see Data Integrator Supplement
for SAP.
A batch job is a set of objects that you can schedule and execute together.
For Data Integrator to execute the steps of any object, the object must be part
of a job.
A batch job can contain the following objects:
• Data flows
• Sources
• Transforms
• Targets
• Work flows
• Scripts
• Conditionals
• Try/catch blocks
• While Loops
Y ou can run b atch jobs such that you can automatically recover from jobs that
do not execute successfully. During automatic recovery, Data Integrator
retrieves the results from steps that were successfully completed in the
previous run and executes all other steps. Specifically, Data Integrator
retrieves results from the following types of steps:
• Work flows
• Data flows
• Script statements
• Custom functions (stateless type only)
• SQL function
• EXEC function
2
Data Integrator Reference Guide 29
Data Integrator Objects
2
Descriptions of objects
• get_env function
• rand function
• sysdate function
• systime function
Batch jobs have the following built-in attributes:
Attribute Description
Name The name of the object. This name appears on the
object in the object library and in the calls to the
object.
Description Your description of the job.
Date created The date when the object was created.
Batch and real-time jobs have properties that determine what information
Data Integrator collects and logs when running the job. You can set the
default properties that apply each time you run the job or you can set
execution (run-time) properties that apply for a particular run. Execution
properties override default properties.
To set default properties, select the job in the project area or the object library,
right-click, and choose
Execution properties are set as you run a job. To set execution properties,
right-click the job in the project area and choose
validates the job and opens the Execution Properties window.
You can set three types of execution properties:
Properties to open the Properties window.
Execute. The Designer
• Parameters
• Trace properties
• Global variables
For an introduction to using global variables as job properties and
selecting them at runtime, see “Setting global variable values” on
page 286 of the Data Integrator Designer Guide.
Parameters
Use parameter options to help capture and diagnose errors using log, View
Data, or recovery options.
Data Integrator writes log information to one of three files (in the
$LINK_DIR\log\Job Server name\repository name directory):
• Monitor log file
• Trace log file
30 Data Integrator Reference Guide
Loading...