Specifications

CHAPTER 1 Working with InfoMaker
Users Guide 49
Data retrieval options
The data retrieval settings shown in Table 1-11 specify rows retrieved and
maximum time on the client, not the server.
Table 1-11: Query Governor data retrieval options
Using a shared InfoMaker initialization file
In some organizations, Query Governor options are specified in a shared
InfoMaker initialization file. For information about using a shared
initialization file, see Connecting to Your Database.
Accessing the Query Governor
The Query Governor button is not in the PowerBar when you install
InfoMaker.
❖ To access the Query Governor from the PowerBar:
1 Customize the PowerBar to add the Query Governor button.
For information about customizing toolbars, see “Customizing toolbars”
on page 31.
2 Click the Query Governor button in the PowerBar.
Allow SELECT DISTINCT
statements
Usually a SELECT statement retrieves all rows
satisfying the
SELECT statement. If SELECT
DISTINCT is specified, duplicate rows are not
retrieved. Retrieval time is often much longer when
DISTINCT is specified.
Data selection options Description
Data retrieval options Description
Specify the maximum
number of rows retrieved
With no maximum set, all rows are retrieved.
Specifying a maximum number limits retrieval and
means shorter retrieval times
Specify the maximum time
for retrieval
With no maximum set, retrieval time is not limited.
Specifying a maximum time limits retrieval time