Page History
...
| Note |
|---|
| Note: Some of the file formats to which you can save a query's results may cause the field name to be truncated. For example, the DBF format will only allow 10 character field names (i.e. column headings) and they must only consist of alphanumeric characters. LANSA Client will ensure that the names of all the fields within a file are unique. |
Default Join Type
Specify the Join Type to be used as the default for all new joins in your query.
...
- All Records (Left Outer Join).
Records from the primary file will be shown even if there are no matching records in the secondary joined file. For example, list customers with and customers without orders. - Matched Records (Inner Join).
Records from the primary file will only be shown if matching records in a secondary joined file are found. For example, list only customers with orders. - Unmatched Records (Exception Join).
Records from the primary file will only be listed if there are no matching records in the secondary joined file. For example, list only customers who have not placed any orders.
Save the Environment
Press the Save button to save the changes you have made using the LANSA Client Administrator.
All the options you have selected for this LANSA Client environment are written to the LC32.LCX file which is saved in your LANSA Client folder.
| Note |
|---|
| Note: The Save button is only enabled if there are unsaved changes. |
Exit from the LANSA Client Administrator
Select the Exit button. If you have modified the configuration and have not saved the changes, you will be prompted to do so.
| Note |
|---|
| Note: Close, then open LANSA Client to "pick up" the new defaults. |
...