IBM Licensed Programs: Database Accessories
536 iSeries Handbook
Query for AS/400 is an interactive query definition, management, and execution facility
allowing users to extract and analyze data from their databases. Create and modify queries
using a variety of record selection criteria. Programming knowledge is not required. Users
can control the formatting of the extracted data for display upon a workstation or printer or
save the data in a database file.
Query for AS/400 supports two expression operators in the Define Result Field function.
These contain similar function for character and graphic data as the SQL Development Kit.
IBM DB2 Query Manager and SQL Development Kit for AS/400 (5722-ST1)
The DB2 Query Manager and SQL Development Kit for AS/400 provides an interactive query
and report writing interface. It also provides precompilers and tools to assist in writing
Structured Query Language (SQL) application programs in high-level programming
languages.
DB2 Query Manager and SQL Development Kit for AS/400 contain these functions to assist
in writing SQL queries and application programs for the DB2 for OS/400 database manager:
• Query Manager
The Query Manager program is an interactive query and report generator that allows
users to define and run queries accessing DB2 for OS/400 databases. Data edit and
report format capabilities are also provided. Multi-system subquery allows subqueries to
be performed over a distributed environment.
• SQL Development Kit
The SQL Development Kit provides precompilers for processing embedded SQL
statements in the C++, RPG, and COBOL programming languages. Support is provided
for these DB2 for OS/400 functions:
– IBM SQL Version 1, ANSI X3.135.1992, ISO 9075-1992, and FIPS 127-2 SQL
conformance
– Embedded static, dynamic, and extended dynamic SQL
IBM DB2 Query Manager and SQL Development Kit for AS/400
Product number 5722-ST1
Replaces product None
Minimum OS/400 level V5R1
Installation prerequisites None
Related products None
To Next Page
Loading...
Need help?
General
