IBM Licensed Programs: Database Accessories 537
IBM Licensed Programs: Database Accessories
– 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.
Query Management Facility for Windows for AS/400 Version 7 (5697-G24)
Query Management Facility (QMF) for Windows is a multipurpose, scalable enterprise query
environment for business reporting, data sharing, server resource protection, robust
application development, and native connectivity to DB2 for AS/400.
As a general-purpose query environment for DB2 datamarts, data warehouses, and
enterprise operational data, QMF for Windows is, in many ways, more powerful and more
versatile than special-purpose database front ends and single-user query tools. This is
because QMF for Windows is designed for multi-user, production level data access where the
broadest base of business operations must be satisfied.
QMF for Windows strategically excels at the most commonly required data access and
reporting functions, providing a range of capabilities fundamental to corporate-wide
Query Management Facility (QMF) for Windows for AS/400 Version 7
Product number 5697-G24
Replaces product QMF for Windows for AS/400 (5697-G04)
Minimum OS/400 level Microsoft Windows (on the IXS) or client based
Installation prerequisites None
Related products None
To Next Page
Loading...
Need help?
General
