
Operating System/400 (5722-SS1)
457
Operating System/400 (5722-SS1)
server mode is also provided that allows developers to write applications that perform
database serving for multiple users.
Distributed Database Support
OS/400 supports distributed relational database, SQL, and a wide range of data types,
including date and time. This support allows read and write access from an iSeries server to
another iSeries server or to any other DB2 family member. The CPI for database is
Structured Query Language (SQL). Customer investment in data is protected by this
distributed support, which allows data connectivity across platforms. Interactive access to
distributed database is possible using the prompted facilities of interactive SQL (ISQL). Both
are available in the separate licensed program DB2 Query Manager and SQL Development
Kit for iSeries (5722-ST1). Distributed file access between an iSeries server, CICS, PCs,
System/36, and System/38 is also available using Distributed Data Management, included in
OS/400. This support allows access to remote files by applications using file and database
interfaces.
Existing DB2 UDB for iSeries SQL applications, including applications using iSeries Client
Access SQL interfaces, can be easily modified with this API to perform database requests on
other databases. The data is returned to the application for processing as if it had come from
DB2 UDB for iSeries. With this support, the programmer's interface is the same whether
Distributed Relational Database Architecture (DRDA) or the SQL Client Integration API is
used.
Database SQL Portability
DB2 UDB for iSeries adds Java to the list of languages in which stored procedures can be
written. Stored procedures are an efficient method of performing SQL processing across a
network since one procedure can run multiple statements and logic to control statement flow
with minimal network traffic. Stored procedures written in Java are methods in Java classes.
Once a stored procedure is created and registered, and the Java classes are placed in the
correct file location, they can be called from any language that can execute SQL statements.
This includes running from remote systems with ODBC or DRDA. DB2 UDB for iSeries
performs the necessary setup to enable a Java virtual machine to run the methods, and
performs the conversion between SQL types and Java objects. DB2 CLI, the call level
interface for running SQL statements from ILE programming languages, is now more
compatible with the ODBC standard. This makes porting applications written to the popular
ODBC standard much easier.
Access Paths
Access paths may be defined for files to allow access in either keyed or arrival sequence
order. Access paths are maintained when a change to the data occurs, allowing multiple
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: ......