8.2.4 File Overrides

The ability to override specific Files and/or Libraries on the server when performing queries is available in LANSA V14. This allows Client to tell the server that when querying particular files, the server is actually to reference data from an alternative table on the server.

The File Override Dialog provides an interface for creating one or more sets of File and Library overrides, and choosing which set to activate. This is typically something an administrator would do, as it requires technical knowledge of database table and owner names on the server.

This is the dialog when first opened, before any data is entered:

The File Override Sets list has just one entry, No Active File Override. To add your own overrides, you must first create a set. This is done by typing a unique name for the set in the field to the right of the Add… button, then clicking Add…

The new entry is added to the list, and when selected it will be the active set of overrides for all LANSA Client queries, as well as allowing you to add, edit and delete specific file and library overrides.

In the image following, the Example1 set has been selected, then the Add Override button clicked. A new dialog opens providing fields specifying the File and Library to be overridden on the server when queries are performed. Clicking OK adds the new entry to the Active Set Contents list. Note that you do not need to enter values for all four fields; if you merely wish to override a file's table and leave the library unchanged, the Library and Table Owner fields can be left blank. In the same way, you can override a Library with a new Table Owner, leaving the File entries blank. This change would therefore affect all Files that use that Library.

In this way multiple file and library overrides can be added. To Edit or Delete an existing entry in the Active Set Control list, click on the appropriate row in the list and then click the Edit Override or Delete Override button.

To delete an entire set of overrides, choose its entry in the File Override Sets list and click the Delete… button.

The screen capture following shows that two sets have been created, and that the active one contains three overrides:

When you are finished, make sure the set that you want active is selected in the File Override Sets list, then click OK.

Your changes will be written to a file stored in your Client directory (typically C:\Program Files\LANSA Client V12) called fileovrr.lcd. This file can then be copied to the Client directory on other computers as needed.