IBM Licensed Programs: Database Accessories536 iSeries HandbookQuery for AS/400 is an interactive query definition, management, and execution facilityallowing users to extract and analyze data from their databases. Create and modify queriesusing a variety of record selection criteria. Programming knowledge is not required. Userscan control the formatting of the extracted data for display upon a workstation or printer orsave 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 queryand report writing interface. It also provides precompilers and tools to assist in writingStructured Query Language (SQL) application programs in high-level programminglanguages.DB2 Query Manager and SQL Development Kit for AS/400 contain these functions to assistin writing SQL queries and application programs for the DB2 for OS/400 database manager:• Query ManagerThe Query Manager program is an interactive query and report generator that allowsusers to define and run queries accessing DB2 for OS/400 databases. Data edit andreport format capabilities are also provided. Multi-system subquery allows subqueries tobe performed over a distributed environment.• SQL Development KitThe SQL Development Kit provides precompilers for processing embedded SQLstatements in the C++, RPG, and COBOL programming languages. Support is providedfor these DB2 for OS/400 functions:– IBM SQL Version 1, ANSI X3.135.1992, ISO 9075-1992, and FIPS 127-2 SQLconformance– Embedded static, dynamic, and extended dynamic SQLIBM DB2 Query Manager and SQL Development Kit for AS/400Product number 5722-ST1Replaces product NoneMinimum OS/400 level V5R1Installation prerequisites NoneRelated products None
