Show TOC

 Adjusting Queries

Use

In some situations, differences in the definition of individual fields may occur between a query and the associated InfoSet.

Example Example

Suppose you have created a query using an InfoSet and have executed it frequently in the past. Your system administrator then modifies the InfoSet by changing the type of field to be used in the query. The next time you want to use the query, you receive a message informing you that differences exist between the query and the InfoSet.

End of the example.

Prerequisites

You are in the initial screen of Queries component.

Procedure

If differences occur between queries and InfoSets, you should terminate the processing and perform a comparison between the query and the InfoSet. This is possible only if you are authorized to change queries.

To adjust, proceed as follows:

  1. Select the function Start of the navigation path Query Next navigation step Additional Functions Next navigation step Adjust Next navigation step . End of the navigation path

  2. You then see a list of all the fields defined differently, along with information about how the field definition has changed and where the field is used in the query.

    The system gives you an automatic adjustment option for individual fields.

    At the end of the list, there are some notes telling you what to look out for in an automatic adjustment and what you must do if you want to carry out the adjustment yourself.

  3. The system gives you an automatic adjustment option for individual fields.

  4. Activate the control box Automatic Adjustment .

  5. Click on the button Autom. Adjustment .

The differences between the InfoSet and the query are corrected by the system.

Caution Caution

Differences between queries and InfoSets can also occur after transports.

End of the caution.