Summary

LANSA Composer

Summary

LIC007 - Extract Database to CSV File

  • You have created a transformation map to extract records from a physical file, into a CSV format file.
  • You defined an SQL Where condition and input parameter for the transformation map.
  • You defined a processing sequence to run the transformation map, with two input parameters for department code and output file name and used the CONCAT activity to create the output path and file name information for the transformation.
  • Optionally, you have used the COMPOSER command on the IBM i to execute your processing sequence directly on the IBM i server.
  • Optionally, you have created a processing sequence shortcut on the desktop and run it.