IBM i Series

Referenced Lists
810 iSeries Handbook
Database References
Among the many database standard functions that are supported, these features are
included:
• National Language Capability
• Structured Query Language (SQL) standards conformance
• IBM SQL Version 1
• ANSI X3.135.1992
• ISO 9075-1992
• FIPS 127-2 standards
• Embedded static, dynamic, and extended dynamic SQL
• ANSI and ISO-defined SQL procedures
• Large object support up to 15 MB of data
• DATALINK data type
• User-defined types
• User-defined functions
• Declarative referential integrity
• User-accessible logs
• Column-level security
• Data striping across disks
• Stored procedures
• Triggers
• Outer Join
• Alter Table function
• X/Open Call Level Interface to SQL
The X/Open standard CLI is supported on several other database platforms, which makes
SQL application portability to and from the DB2 UDB for iSeries platform even easier.
• SQL Repeatable Read
• Access to data areas and data queues
• Two-phase commit transaction management
• Data replication
• System-wide database catalog
• Multiple-level concurrency control
• National Language Support (NLS)
• High Performance Database Server (Centralized and Distributed Server)
DB2 UDB for iSeries Functions
These DB2 UDB for iSeries functions are available to enhance application performance:
• Advanced SQL optimizer
• SQL Encoded Vector Indexes (EVIs)
• Explain function