Accessing the Query Governor  How your InfoMaker environment is managed

Chapter 1: Working with InfoMaker

Using the Query Governor

When you select and retrieve data, the default Query Governor options limit you in the following ways:

You can do this

You cannot do this

Join an unlimited number of tables

Specify cross products

Retrieve an unlimited number of rows

Specify outer joins

Retrieve for an unlimited time

Use SELECT DISTINCT statements

You can change the Query Governor default options at any time by selecting or deselecting the options in the Query Governor dialog box. If you are in the Select painter when you change a data selection option, the change is not enabled until you leave the Select painter and open it again.

StepsTo use the Query Governor:

  1. Access the Query Governor dialog box as described above and select options:

    The sample shows the Query Governor dialog box. It displays check boxes for Data Selection Options. First is Specify maximum number of tables in a join, which has a spin control for selecting a number. Next are Allow cross products, Allow outer joins, and Allow SELECT DISTINCT statements. Beneath are Data Retrieval Options, which include check boxes for Specify maximum number of rows retrieved and Specify maximum time for a retrieval. Both options have spin controls.



Copyright © 2012. Sybase Inc. All rights reserved. How your InfoMaker environment is managed

View this document as PDF