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 (PSLMST) 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:
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.