
IBM Licensed Programs: Database Accessories
530
iSeries Handbook
SQL dialects, protocols, operating systems, data types, error codes, and functional
differences are all transparent to the application. Similarly, client workstations attached to
DB2 DataJoiner only need one client interface to DataJoiner and all other supported data
sources are then available. This eliminates the need for each workstation to have client code
for each data source and is very efficient and cost effective.
One way DataJoiner provides data transparency is with compensation. DataJoiner can
provide functions not available at a data source, enriching the native SQL of the data source.
For example, a client can submit a query using DataJoiner to a data source. If that function is
not supported (such as Recursive SQL) at the data source, but is supported by DataJoiner,
the query can complete successfully. DataJoiner compensates by simulating the function,
and, therefore, preserving transparent access.
Features
DB2 DataJoiner offers extensive support for nontraditional and traditional applications to fully
integrate the database architecture:
• Large Objects (LOBs): Large object support allows multimedia objects, such as
documents, video clips, images, and sound recordings, to be stored in any data source
(which support LOBs, like DB2 UDB) and manipulated like other database objects.
The size of any one LOB can range up to 2 GB.
• Global User-Defined Types (UDTs): Global UDTs allow users to define new data
types across multi-vendor data sources, which are represented in the DB2 DataJoiner
database using built-in types. For example, a user can define two currency types:
CDOLLAR data type for Canadian dollars and USDOLLAR data type for U.S. dollars.
UDTs, like built-in types, can be used for columns of tables as well as function
parameters, including user-defined functions (UDFs). For example, a user can define a
data type such as ANGLE (which varies between 1 and 360) and a set of UDFs to act on
it, such as SINE, COSINE, and TANGENT.
• Global User-Defined Functions (UDFs): Application developers often want to create
their own suite of functions specific to their application or domain. Global UDFs make
this possible, expanding the scope of DB2 DataJoiner to include customized business
or scientific functions that span multi-vendor data.
For example, a retail store could define a PRICE data type for tracking the cost of items it
sells. This store might also want to define a SALES_TAX function, which would use a
given price value as input, compute the applicable sales tax, and return this data to the
application.
• Recursive Global SQL Queries: DataJoiner supports not only multi-vendor
bills-of-material queries but also the more powerful forms of recursive queries such as
path expressions. Examples of queries that become possible with recursion are:
Summary of Contents for i Series
Page 2: ......
Page 3: ...IBM iSeries Handbook Version 5 Release 1 Document Number GA19 5486 21B 12 February 2002...
Page 5: ...Table of Contents...
Page 6: ...Table of Contents...
Page 31: ...1 Introduction...
Page 32: ...Introduction...
Page 38: ...Introduction 8 iSeries Handbook...
Page 39: ...9 Advanced Technology...
Page 40: ...Advanced Technology...
Page 68: ...iSeries Architecture Fundamental Strength of the iSeries 38 iSeries Handbook...
Page 69: ...39 Workload and Performance...
Page 70: ...Workload and Performance...
Page 82: ...Workload and Performance 52 iSeries Handbook...
Page 83: ...53 iSeries Direction...
Page 84: ...iSeries Direction...
Page 93: ...63 Server Summary...
Page 94: ...Server Summary...
Page 120: ...iSeries and AS 400e Servers 90 iSeries Handbook...
Page 121: ...91 AS 400e Server 250...
Page 122: ...AS 400e Server 250...
Page 142: ...iSeries Model 250 Packages and AS 400e Server 250 112 iSeries Handbook...
Page 143: ...113 iSeries Server 270...
Page 144: ...iSeries Server 270...
Page 162: ...iSeries Server 270 132 iSeries Handbook...
Page 163: ...133 iSeries Dedicated Server for Domino...
Page 164: ...iSeries Dedicated Server for Domino...
Page 172: ...iSeries Dedicated Server for Domino 142 iSeries Handbook...
Page 173: ...143 iSeries Server 820...
Page 174: ...iSeries Server 820...
Page 192: ...iSeries Model 820 162 iSeries Handbook...
Page 193: ...163 iSeries Server 830...
Page 194: ...iSeries Server 830...
Page 211: ...181 iSeries Server 840...
Page 212: ...iSeries Server 840...
Page 232: ...iSeries Model 840 202 iSeries Handbook...
Page 233: ...203 Upgrades to iSeries Server 8xx...
Page 234: ...Upgrades to iSeries Server 8xx...
Page 253: ...223 iSeries Server SB2...
Page 254: ...iSeries Server SB2...
Page 261: ...231 iSeries Server SB3...
Page 262: ...iSeries Server SB3...
Page 271: ...241 HSL and Towers...
Page 272: ...HSL and Towers...
Page 304: ...Towers and Racks 274 iSeries Handbook...
Page 305: ...275 I O Processor...
Page 306: ...I O Processor...
Page 319: ...289 I O Adapter...
Page 320: ...I O Adapter...
Page 352: ...I O Adapters and Controllers 322 iSeries Handbook...
Page 353: ...323 Internal Storage...
Page 354: ...Internal Storage...
Page 381: ...351 Removable Storage...
Page 382: ...Removable Storage...
Page 390: ...Removable Storage Media Devices 360 iSeries Handbook...
Page 420: ...Externally Attached Automated Libraries 390 iSeries Handbook...
Page 421: ...391 External Disk Storage...
Page 422: ...External Disk Storage...
Page 426: ...2105 Enterprise and Versatile Storage Servers 396 iSeries Handbook...
Page 427: ...397 Peripherals...
Page 428: ...Peripherals...
Page 456: ...Peripherals 426 iSeries Handbook...
Page 457: ...427 Customer Install Features...
Page 458: ...Customer Install Features...
Page 470: ...Customer Install Features CIF 440 iSeries Handbook...
Page 471: ...441 OS 400...
Page 472: ...OS 400...
Page 544: ...Operating System 400 5722 SS1 514 iSeries Handbook...
Page 550: ...Software Terms 520 iSeries Handbook...
Page 551: ...521 Database...
Page 552: ...Database...
Page 575: ...545 TCP...
Page 576: ...TCP...
Page 595: ...565 WebSphere...
Page 596: ...WebSphere...
Page 627: ...597 Application Development...
Page 628: ...Application Development...
Page 661: ...631 Lotus...
Page 662: ...Lotus...
Page 689: ...659 Networking...
Page 690: ...Networking...
Page 727: ...697 System Management...
Page 728: ...System Management...
Page 754: ...IBM Licensed Programs System Management Products Services 724 iSeries Handbook...
Page 755: ...725 Printing and Document Handling...
Page 756: ...Printing and Document Handling...
Page 772: ...IBM Licensed Programs Printing and Document Handling Products 742 iSeries Handbook...
Page 773: ...743 Earlier Model Summary...
Page 774: ...Earlier Model Summary...
Page 831: ...801 Referenced Lists...
Page 832: ...Referenced Lists...
Page 863: ...833 Special Notices and Publications...
Page 864: ...Special Notices and Publications...
Page 877: ...847 Abbreviations...
Page 878: ...Abbreviations...
Page 884: ...854 iSeries Handbook...
Page 885: ...855 Index...
Page 886: ...Index...
Page 904: ......
Page 905: ...1 5 spine 1 5 1 998 789 1051 pages IBM iSeries Handbook Version 5 Release 1...
Page 906: ......
Page 907: ......