• Created by user-cd56b, last updated by user-ff8ce on Aug 28, 2023 3 minute read

The LANSA Composer tutorials are designed to introduce the basic elements of the LANSA Composer application.

This section covers some topics to read before you start:

How do I use the Tutorials?

LANSA Composer Server objects required for the Tutorials

Resetting Tutorial Data

Before you begin

In the first six exercises of the tutorials, you will create a Composer Processing Sequence that will perform the following steps for each Trading Partner:

  • Find xml files in the "Inbound Tutorial" directory linked to the Trading Partner
  • Read each xml file and update a database table with its data
  • Send an acknowledgement email to the trading partner.

The following tutorials are included in this chapter:

LIC001 - Introduce Composer Client & Validate Environment

LIC002 - Create a Processing Sequence

LIC003 - Create a Transformation Map

LIC004 - Add the Transformation to the Processing Sequence

LIC005 - Set up a Trading Partner

LIC006 - Add Email Acknowledgement to Processing Sequence

LIC007 - Extract Database to CSV File

LIC008 - Processing via Email

LIC009 - Handle multiple requests via an email attachment

LIC010 - Calling a Processing Sequence

LIC011 - Email notification service

In addition, there are tutorials for specific features, such as:
JSM Binding Script Tutorials
and others for smaller steps you might need to perform, such as:
TXD001 - Run a Simple Transaction Document Processing Demonstration.

How do I use the Tutorials?

It is recommended that you complete the tutorials in sequence. The objects created in the earlier tutorials are reused and extended in the following tutorials.

If the tutorials have been used previously, you should reset the tutorial data, as described in Resetting Tutorial Data.

Some sections of the tutorials will vary according to the server you are using. The examples given in these exercises are for an IBM i server. If you are using a Windows server, you will have to use appropriate values for a Windows server. The sections which will vary are:

  • Setting up an ODBC connection within Altova MapForce for the database connection.
  • Setting up a Database configuration. This is defining a JDBC connection on your server.
  • Ensuring the database tables used in your Transformation are under commitment control.

LANSA Composer Server objects required for the Tutorials

The objects required for the tutorials are installed with the LANSA Composer server software.

The tutorial objects you need are listed below:

  • Database tables:
    Tutorial order header and line tables:

    TUTORDH
TUTORDL

    For exercises 7, 8,and 9 you will also require the LANSA Personnel Demonstration system database tables installed, including tables with names XEMPLOYEE, XDEPARTMENTS, and others.

    On an IBM i server,  the database tables are supplied and installed as *FILE objects in your partition data library (for example, LICLICLIB).

    On a Windows server, the database tables are supplied and installed in the database in which LANSA Composer was installed, in schema or collection named LC_DTA.

  • Flat files installed into a directory on your server:

    TUTorder.dtd
TUTorder.xml
Ack.txt
TUT_01_SKEL.txt

  • Activities:

    TUT_01_AT
TUT_02_AT

  • Processing Sequence:

    TUT_01_P1
TUT_01_P2
FSTUTSEQ (example of the completed Processing Sequence)
  • System setting
    The Tutorial Files system setting should be set to the directory location where the flat files are installed.

  • LANSA system variable

    *AUTOALP10BATCHNO

Resetting Tutorial Data

If the tutorials have been used previously, it is recommended that you clear the previous results as follows:

  • Delete from the tutorial directory flat files:

    iii_TUT_01_P1.txt
iii_TUT_01_P2.txt

Note

There may be several of these files where iii represents the initials entered by a person who has previously used the tutorials.
  • Do NOT delete TUT_01_SKEL.txt

Before you begin

To complete these tutorials, you must have completed the following:

  • Installed, configured and licensed LANSA Composer on your server.
  • Installed and configured LANSA Composer Client on your Microsoft Windows PC, including Altova MapForce and the Java Development Kit (JDK).
  • Obtained a valid server user ID and password to use with LANSA Composer.
  • Obtained and applied a valid MapForce licence.

It is recommended that you complete the tutorials that are provided with MapForce to familiarize yourself with the mapping environment.

Your Feedback

Your feedback regarding these tutorials will help us improve the overall quality of the LANSA documentation and training. Please email your comments to lansatraining@LANSA.com.au

  • No labels