LIC007 - Extract Database to CSV File

Objectives

To extract a CSV file from a physical file, with selection criteria. You will create a transformation map and use it in a processing sequence to do the following:

• Extract employee data from the Personnel file (xEmployee) into a CSV file

• Select records based on department code

• Input department code as a run time parameter to the processing sequence

• Input the output CSV file name as a run time parameter

Steps

To achieve these objectives you will complete the following:

• Step 1. Create Transformation Map

• Step 2. Define Transformation Map

• Step 3. Define an SQL Where condition and input parameter

• Step 4. Prepare Transformation Map

• Step 5. Create Processing Sequence

• Step 6. Run the Processing Sequence

• Step 7. Run Composer CL Command (Optional)

• Step 8. Run Processing Sequence from a shortcut (optional)

• Summary

This exercise uses files from the LANSA Personnel Demonstration System.

On an IBM i server, the files are in the LANSA Composer partition library.  In an installation using default names, the library name will be LICLICLIB.

On a Windows server, the files are in the designated LANSA Composer database, in schema or collection name LC_DTA.

Before You Begin

• In order to complete this tutorial, you should complete the preceding tutorials.