IBM AS/400e, User Handbook Manual

Page: 521 / 834

Operating System/400, 5769-SS1
491
Operating System/400, 5769-SS1
Refer to “IBM Licensed Programs: Application Development Products” on page 641 for more
information on products available for application development.
Year 2000 Support
The Year 2000 problem exists because the practice of using only two digits in system and
application programs yields incorrect results on arithmetic operations, comparisons, or the
sorting of date fields for years outside the range 1900 to 1999. With Year 2000 enablers,
OS/400 is an operationally safe environment for further application enabling. The enablers
also facilitate the making of existing customer programs Year 2000 safe. OS/400 V3R7 and
later handle dates and date fields for the Year 2000 and beyond.
For further information on this topic, visit the Web site:
http://www.software.ibm.com/year2000/
Database Support
The integrated database, DB2 for OS/400, provides stability and compatibility of previous
releases of the AS/400 database with the standards-based technology required for a
heterogeneous computing environment. DB2 for OS/400 provides compliance in the area of
standards compliance coupled with advanced function, distributed capabilities, and
performance. DB2 for OS/400 provides support for:
• Structured Query Language (SQL) standards conformance. Supplies the industry
standard database access language conforming to the IBM SQL Version 1, ANSI
X3.135.1992, ISO 9075-1992, and FIPS 127-2 standards. Support is provided for
embedded static, dynamic, and extended dynamic SQL, together with IBM's
Distributed Relational Database Architecture (DRDA), Microsoft's Open Database
Connection (ODBC), and Apple's Data Access Language (DAL). A Call Level Interface
(CLI) server mode is also provided that allows developers to write applications that do
database serving for multiple users.
• Encoded Vector Indexes (EVI) can be created using SQL. EVIs cannot be used to
order records, but in many cases, they can improve query performance.
• Declarative referential integrity preventing conflicting data from being entered in the
database.
• Stored procedures allowing the distribution of application workloads between a client
and an application server.
• Triggers that cause automatic program execution before and after database
modifications.
• Two-phase commit transaction management to allow access to multiple
heterogeneous databases simultaneously.
• Data replication automatically in distributed DB2 family environment.