Creating queries
A query is a request for information from a data
source. To request information from a relational data source you can
construct a query in a standard fashion by using Structured Query
Language (SQL) statements. Or, if you are not familiar with SQL, you
can construct a query graphically by using the Query Builder editor.
Query types QMF provides multiple ways to query data. What you can do with queries and the query results can vary depending on the type of query you run.Query interfaces QMF provides robust querying capabilities. You can create new queries using the query building editors or import existing queries. Imported queries can be edited as needed.Creating visual queries using the SQL editor SQL Query editor. The SQL Query editor allows you to build visual queries.Creating visual queries using the Prompted Query editor Prompted Query editor. The Prompted Query editor prompts you for the information it needs to build the SQL statement.Creating visual queries in the Query Builder editor Query Builder editor to create visual queries. You supply table, join, column, sort, and row information and the editor constructs the SQL statements.Creating visual queries using the Draw Query wizard Draw Query wizard to create a query object automatically based on the query type and tables that you specify. This menu option is the same as the DRAW command in QMF for CICS/TSO. Working with prompts in queries Creating OLAP queries Analytical queries and associated transformations Working with Cloudant queries QMF for Workstation and QMF for WebSphere you can create Cloudant queries to retrieve data from Cloudant databases.Profiling queries Publishing objects to QMF Vision QMF Vision Objects folder to work with them in QMF Vision .Working with database tables a default editor, the Table Editor , the Table Viewer or the Visual Query Editor .Managing data in Cloudant databases QMF , you can view the JSON documents that a Cloudant database contains, edit or remove them, and add new documents.