Show TOC

 Adjusting InfoSets

Use

In certain cases, for example, when you upgrade to a higher release, the technical properties of fields in the database tables may change. Changes can affect

  • the field type

  • the field length

  • the output length of the field

  • the use of the field as a currency amount or as a quantity field

If you are using any of these changed fields in an InfoSet, and you choose from the InfoSet: Initial Screen one of the functions Change, Display , Description, or Check , the system tells you that the InfoSet is no longer valid. You decide whether you want to adjust your InfoSet or not.

If you are using any of these changed fields in an InfoSet, and choose Generate, you get to the Log Display dialog box. The system shows you the differences between the fields in the InfoSet and the fields in the data dictionary.

We recommend that you adjust your InfoSet to include the changes that have been made to the technical properties of the fields.

Procedure

  1. In the InfoSet: Initial Screen , choose InfoSet Additional Functions Adjust .

  2. This takes you to the Log Display dialog box. The system shows you errors ( ) and warnings ( ) in the same way as when it is checking or generating an InfoSet. There is an additional Adjust pushbutton on the pushbutton toolbar.

  3. Choose Adjust .

  4. The information from the data dictionary is copied over into the InfoSet.

  5. Choose Generate .

Note Note

We recommend that once you have adjusted the InfoSet, you also adjust all the queries belonging to this InfoSet. This ensures that the technical properties that have been changed are also copied over to the query definitions.

End of the note.