IBM Licensed Programs: Database Accessories
540 iSeries Handbook
• Run more than one query at a time in the foreground or background
• Query more than one DB2 for AS/400 database server at a time
• Limit size of the query results
• View resource limits in effect
• Access information about queries, such as remarks and tracking
• Use the QMF for Windows interface or your favorite application interface
• Integrate with Excel, Visual Basic, PowerBuilder (all OLE 2.0 compliant applications)
using simple application macros or developer environments such as Visual Age for
Basic or Visual Basic
Developer benefits
• Eliminate database gateways, middleware, or ODBC drivers
• Integrate with any Windows OLE 2.0 automation client application
• Call on QMF for Windows services with its API
• Use HELP for supplied sample API code as templates
• Bring industrial strength to ordinary desktop languages
• Leverage skills of the desktop development community
• Query in native DB2 syntax (the server's SQL)
• Get the reliability, performance, and security of DB2
• Let QMF for Windows automatically manage DB2 resources (threads, conversations,
states) in the background
• Use performance enhancing technologies, such as static SQL, directly in your
Windows applications
• Shield users from the complexity of connections
• Retrieve QMF for Windows objects stored on servers and launch than from within
Windows applications
• Eliminate manual export and import procedures from the host to PC
Administrator benefits
• Protect DB2 from runaway queries and novice users with robust governing
• Use existing DB2 security
• Safely store Windows user resource limits at the DB2 database server
• Supports different limits for different users, groups, and schedules
• Temporarily suspend a user's limits
• Use many governing criteria, including:
To Next Page
Loading...
