INT003 - Using the LANSA User Agent

Objectives:

• To learn how to use the LANSA User Agent to send and receive a CSV (comma separated values) file from a PC to a LANSA function running on an IBM i or Windows Server.

• To learn how to upload data from an Excel spreadsheet to an IBM i or Windows Server.

• To create a server side RDML function that receives the CSV or Excel file sent by the LANSA User Agent, reads the data and processes it, and sends back a response to the LANSA User Agent.

• To show how the LANSA User Agent can be executed in batch mode.

To achieve these objectives, you will complete the following:

Concepts

Step 1. Create a User Agent Solution and edit Host Properties file

Step 2. Create a CSV file with Column Headings to Send

Step 3. Create a Server Function iiiFN03

Step 4. JSMDirect Service Configuration

Step 5. Test iiiFN03 function

Step 6. Ignore the Column Headings

Step 7. Using a CSV without Column Headings

Step 8. Sending an Excel spreadsheet. Optional

Step 9. Invoke User Agent in Batch Mode. Optional

Summary