IBM AS/400e

IBM Licensed Programs: Database Products 539
IBM Licensed Programs: Database Products
– IBM SQL Version 1, ANSI X3.135.1992, ISO 9075-1992, and FIPS 127-2 SQL
conformance
– Embedded static, dynamic, and extended dynamic SQL
– Declarative referential integrity
– Stored procedures
– Triggers
– Two-phase commit transaction management
– Explain function
– Long names supported for SQL objects
– Multisystem subquery
– ALIAS support
– Host variables for Large Object (LOB) data types
– Scalar subselect in the UPDATE statement
– ALIAS use for database files or members
A significant advantage of the DB2 for OS/400 database manager along with Query Manager
and SQL Development Kit is that DB2 for OS/400 SQL objects are compatible with OS/400
objects.
The interactive SQL program allows users and programmers to enter SQL statements and
queries interactively. Full syntax prompting is available to assist in defining SQL statements.
IBM DB2 Intelligent Miner for Data for AS/400 V6R1, 5733-IM1
IBM DB2 Intelligent Miner for Data for AS/400 enables knowledge workers to identify and
extract high-value business intelligence from large amounts of enterprise data. Version 6
Release 1 (V6R1) offers new analysis and data exploration options to enhance core data
mining capability, while making critical data more accessible to those who need it most.
Business analysts and managers are empowered to make better informed decisions to
improve customer relations, maximize profits, and reduce the risk of fraud and abuse.
DB2 Intelligent Miner for Data for AS/400 V6R1 places increased focus on bringing the value
of data mining to more business intelligence users. Enhancements include integration with
warehouse and business intelligence tools. Integrated business intelligence offerings
leverage product enhancements to deliver end-to-end mining solutions to the business
analyst:
• SAP Business Warehouse: Joint SAP and IBM technology pilots are underway to
enable SAP users to use Intelligent Miner to mine data sourced from their SAP
Business Warehouse. Generated models are applied and ported back to the
warehouse. As both data and metadata are imported and exported, users define data
once.