5486OpS.fm Draft Document for Review October 18, 2004
524 IBM Eserver i5 and iSeries System Handbook
enhanced in V5R2 to improve DB2 UDB compatibility. Most significant is
support for nested compound statements. They enable the user to bundle
related statements together into their own execution block within an SQL
procedure, trigger, or function.
– Removal of the
Order By restriction that required any column used to
order/sort query results to be included in the results. Statement 3 is
supported with V5R2.
– SQL procedures, functions, and triggers no longer require licensed
program product 5722-ST1 to be installed on the iSeries. Interactive SQL
and embedded SQL require 5722-ST1 to function on the iSeries server.
SQL Repeatable Read
A standard compliant isolation level, Repeatable Read support, is included in
MQSeries for iSeries, a separately-licensed program, 5722-MQ1.
Journaling and SQL DDL operation journaling (V5R1)
Open standards-based interoperability
Support for client/server environments is greatly enhanced in DB2 UDB for
iSeries by incorporating popular database standards and transmission protocols,
such as support for:
ANSI X3.135.1999, ISO 9075-1999, and FIPS 127-2 SQL
The Open Group’s Distributed Relational Database Architecture™ (DRDA®)
Distributed Unit of Work - Application Directed
Microsoft's ODBC
Apple's Data Access Language (DAL)
XML
JDBC
Object Link Embedded (OLE) DB and ADO
U.S. Government C2 security
UCS-2 (Unicode or ISO 10646)
Euro character support
Stored procedures
Tr igg e rs
Join operators
Enhanced SQL query support
To Next Page
Loading...
Need help?
General