
Operating System/400 (5722-SS1)
459
Operating System/400 (5722-SS1)
User-defined Functions
SQL now lets you define your own functions to use within SQL itself. This saves you time in
reusing common building blocks that you develop yourself. User-defined functions are
necessary building blocks to support the database extenders (extensions to support rich text
and multimedia search and manipulation) currently supported on DB2 UDB for iSeries.
Declarative Referential Integrity
Provides SQL database integrity support intrinsic to the database, eliminating the need to
code integrity constraints into each application program. This support ensures database
consistency by preventing conflicting data from being entered into the database.
User-accessible Logs
Journal entries (that is, records of database changes) can be searched and viewed
interactively, and may be retrieved by a user program for further processing or analysis. This
can lead to improved security or database integrity and is also an important component or
open access to the database.
Column-level Security
Access to individual table columns can be controlled for each user. Row-level locking
individual records (such as, records) are locked from simultaneous, conflicting access as
appropriate to the type of processing being done. Using commitment control, the user can
define a group of records all of whose locks are held until the user application declares a
multiple-change transaction complete.
Stored Procedures
Provides the ability to distribute the application workloads between clients and servers. The
ability to split an application program by executing the processing logic on the server and the
presentation logic on the client can provide increased performance over traditional requester
access. These improvements can be dramatic for applications requiring intermediate
processing of data, which can be performed at the server locally, instead of remotely at the
client.
Triggers
Provides for automatic program/procedure execution, based on user specified rules, before
or after database modifications.
Outer Join
The Outer Join function is another SQL standard compliant function that can improve both
query performance and function. Performance is enhanced with a syntax that allows SQL
Содержание i Series
Страница 2: ......
Страница 3: ...IBM iSeries Handbook Version 5 Release 1 Document Number GA19 5486 21B 12 February 2002...
Страница 5: ...Table of Contents...
Страница 6: ...Table of Contents...
Страница 31: ...1 Introduction...
Страница 32: ...Introduction...
Страница 38: ...Introduction 8 iSeries Handbook...
Страница 39: ...9 Advanced Technology...
Страница 40: ...Advanced Technology...
Страница 68: ...iSeries Architecture Fundamental Strength of the iSeries 38 iSeries Handbook...
Страница 69: ...39 Workload and Performance...
Страница 70: ...Workload and Performance...
Страница 82: ...Workload and Performance 52 iSeries Handbook...
Страница 83: ...53 iSeries Direction...
Страница 84: ...iSeries Direction...
Страница 93: ...63 Server Summary...
Страница 94: ...Server Summary...
Страница 120: ...iSeries and AS 400e Servers 90 iSeries Handbook...
Страница 121: ...91 AS 400e Server 250...
Страница 122: ...AS 400e Server 250...
Страница 142: ...iSeries Model 250 Packages and AS 400e Server 250 112 iSeries Handbook...
Страница 143: ...113 iSeries Server 270...
Страница 144: ...iSeries Server 270...
Страница 162: ...iSeries Server 270 132 iSeries Handbook...
Страница 163: ...133 iSeries Dedicated Server for Domino...
Страница 164: ...iSeries Dedicated Server for Domino...
Страница 172: ...iSeries Dedicated Server for Domino 142 iSeries Handbook...
Страница 173: ...143 iSeries Server 820...
Страница 174: ...iSeries Server 820...
Страница 192: ...iSeries Model 820 162 iSeries Handbook...
Страница 193: ...163 iSeries Server 830...
Страница 194: ...iSeries Server 830...
Страница 211: ...181 iSeries Server 840...
Страница 212: ...iSeries Server 840...
Страница 232: ...iSeries Model 840 202 iSeries Handbook...
Страница 233: ...203 Upgrades to iSeries Server 8xx...
Страница 234: ...Upgrades to iSeries Server 8xx...
Страница 253: ...223 iSeries Server SB2...
Страница 254: ...iSeries Server SB2...
Страница 261: ...231 iSeries Server SB3...
Страница 262: ...iSeries Server SB3...
Страница 271: ...241 HSL and Towers...
Страница 272: ...HSL and Towers...
Страница 304: ...Towers and Racks 274 iSeries Handbook...
Страница 305: ...275 I O Processor...
Страница 306: ...I O Processor...
Страница 319: ...289 I O Adapter...
Страница 320: ...I O Adapter...
Страница 352: ...I O Adapters and Controllers 322 iSeries Handbook...
Страница 353: ...323 Internal Storage...
Страница 354: ...Internal Storage...
Страница 381: ...351 Removable Storage...
Страница 382: ...Removable Storage...
Страница 390: ...Removable Storage Media Devices 360 iSeries Handbook...
Страница 420: ...Externally Attached Automated Libraries 390 iSeries Handbook...
Страница 421: ...391 External Disk Storage...
Страница 422: ...External Disk Storage...
Страница 426: ...2105 Enterprise and Versatile Storage Servers 396 iSeries Handbook...
Страница 427: ...397 Peripherals...
Страница 428: ...Peripherals...
Страница 456: ...Peripherals 426 iSeries Handbook...
Страница 457: ...427 Customer Install Features...
Страница 458: ...Customer Install Features...
Страница 470: ...Customer Install Features CIF 440 iSeries Handbook...
Страница 471: ...441 OS 400...
Страница 472: ...OS 400...
Страница 544: ...Operating System 400 5722 SS1 514 iSeries Handbook...
Страница 550: ...Software Terms 520 iSeries Handbook...
Страница 551: ...521 Database...
Страница 552: ...Database...
Страница 575: ...545 TCP...
Страница 576: ...TCP...
Страница 595: ...565 WebSphere...
Страница 596: ...WebSphere...
Страница 627: ...597 Application Development...
Страница 628: ...Application Development...
Страница 661: ...631 Lotus...
Страница 662: ...Lotus...
Страница 689: ...659 Networking...
Страница 690: ...Networking...
Страница 727: ...697 System Management...
Страница 728: ...System Management...
Страница 754: ...IBM Licensed Programs System Management Products Services 724 iSeries Handbook...
Страница 755: ...725 Printing and Document Handling...
Страница 756: ...Printing and Document Handling...
Страница 772: ...IBM Licensed Programs Printing and Document Handling Products 742 iSeries Handbook...
Страница 773: ...743 Earlier Model Summary...
Страница 774: ...Earlier Model Summary...
Страница 831: ...801 Referenced Lists...
Страница 832: ...Referenced Lists...
Страница 863: ...833 Special Notices and Publications...
Страница 864: ...Special Notices and Publications...
Страница 877: ...847 Abbreviations...
Страница 878: ...Abbreviations...
Страница 884: ...854 iSeries Handbook...
Страница 885: ...855 Index...
Страница 886: ...Index...
Страница 904: ......
Страница 905: ...1 5 spine 1 5 1 998 789 1051 pages IBM iSeries Handbook Version 5 Release 1...
Страница 906: ......
Страница 907: ......