Queries and reports

 

You can use SQL, the Open Query File (OPNQRYF) command, the Create Query (QQQQRY) API, Open Database Connectivity (ODBC), or the IBM^® Query for iSeries™ licensed program to create and run queries.

One of the most common tasks that you perform with your database is to retrieve information. The system provides several methods to create and run queries and reports.

You can use an SQL statement to retrieve information. This SQL statement is called a query. The query searches the tables stored in your database to find the answer to the question that you posed with your SQL statement. The answer is expressed as a set of rows, which is referred to as the result set. After a query has been run, you can also create a report to display the data provided in your result set.

In addition to using SQL, you can use other functions and products to create and run queries and reports. See the following manuals for detailed information.

• Query for iSeries Use

  

• DB2 Universal Database™ for iSeries Query Management Programming

  

• DB2 Universal Database for iSeries Query Manager Use

  

In addition, the iSeries Navigator interface provides SQL Assist, which can be used to create SQL statements. SQL Assist can help you build SQL SELECT, INSERT, UPDATE, and DELETE statements.

• V5R3 changes to Query for iSeries
  In V5R3, the Query for iSeries Use manual was not updated, but numerous functional updates were made to the Query for iSeries licensed program.

 

Parent topic:

Administration

 

Related concepts

Building SQL statements with SQL Assist
SQL programming