3.1 Steps to Create a Query

These are the steps you will follow to create most queries.

1.  Start with a new Query window by selecting the New command in the File menu by using this toolbar icon. The Query window's contents are described in detail in 3.2 What is in the Query Window?

2.  Choose your query's Primary File. How to do this is described in 3.3 The Files to Select From.

3.  Select the fields you want in your query from your primary file and any other files.

4.  Consider whether you can improve your query by adding sort and selection criteria or by specify grouping and summary totals. Refer to 3.1.1 Enhance your Query for some suggestions.

5.  Specify where you want your query's output to go.

6.  Specify any special output requirements, such as the number of records to be retrieved.

7.  Check that your query will perform as efficiently as possible by answering the questions in 3.11 Performance Considerations. Make any necessary changes.

8.  Save your query at this point. You can run your query without first saving it, but this is not recommended.

9.  Run your query.

10. Check that the results meet your requirements.

11. Change the summarizing, grouping or sorting criteria if you need to.

12. Chart your results, if required.

13. Save your chart and query, if required.

The steps are the same to create any type of query. For linked queries, you just need to create more than one query and add a step which links the queries together in the required hierarchy.

Detailed instructions for creating a simple query, join query or a linked query are included in The LANSA Client Tutorial.

 

Further Information

3.1.1 Enhance your Query