The exercises in this tutorial cover the key functions provided by LANSA Client. In order to show you how to use the functions efficiently, they have been split into separate exercises that are interrelated. That is, the results of one exercise may be used in the next exercise.

The exercises in this file are:

• LCE020 – Configure a LANSA Client Environment. This exercise is optional as the environment may already exist.
• LCE120 - Query a Single file
• LCE130 - More Query Basics
• LCE210 - Update Data
• LCE230 - Join Query
• LCE231 - Join Query, include Unmatched Records
• LCE240 - Linked Queries
• LCE250 - Field Conditions
• LCE260 - Group, Summary and Sort Options
• LCE270 - Top-10 and Bottom-10 Query
• LCE280 - Sharing Data with Other Applications
• LCE310 - Charting in your Query
• LCE430 - Build & Execute a Generated Application

Before You Begin

Before you can use the exercises, you will need to get the PC ready. Here's a checklist:

• Has LANSA Client been installed on your PC?
• Have you access to the files used for the Exercises?
  Instructions for setting up these files is in Set up the Tutorial files.
• Is the Exercise partition, which comes with the host-based programs for LANSA Client, available to your PC?
  If you are using a standalone PC, then you will most likely have the necessary files available to you. If the LANSA Client Exercise is not in the list of hosts to link to, ask your system administrator to create a LANSA Client Environment file for you. You can also create one yourself as described in LCE020 – Configure a LANSA Client Environment.
• Is the communications software successfully connecting your PC to the host?
• Is Windows started?

If you can answer Yes to all of these questions, you are ready to start using the exercise.