Page History

This transformation map needs to support the selection of employees by department code to be inserted into the CSV text file. In this step, you will complete the transformation map by adding an SQL Where Condition, and an input parameter linking the file XEMPLOYEE to the output text file via the SQL Where Condition.

1. Insert an SQL Where Condition using the Insert / SQL-WHERE Condition menu option.
   Image Modified
2. Link the XEMPLOYEE file to the table element of the SQL-Where, this will open the SQL-Where properties dialog:
   Image Modified

3. When connecting to IBM i define the selection as

 
Code Block

4. XDEPTMENT

5. =

6. :Department_In
   

   When Connecting to WindowsDefine the selection as

Code Block xDepartmentCode 

7. xDepartmentCode =

8. :Department_In 

   (Note the colon - and lack of space - before Department_In.) This will define an input parameter – see the example below.

   Note
   title Note
   XDEPARTMENTCODE is the name of the department code field in the file XEMPLOYEE, which the transformation is reading.

   Image Modified

9. Click the OK button to save these changes. Your map window should now look like the following:
   Image Modified
10. Use the Function / Insert Input menu option to define an Input parameter.
    Image Modified

11. Define a string input called Department_In  and click OK.

    Note
    You can also define a default value and use this in Mapforce to produce sample output. Specify a design time execution value of 1700

    Image Modified

12. Link the Input function to the SQL-WHERE Condition and link the SQL_Where result output to the text file Rows, as shown below.
    Image Modified
13. Use the Image Modified Save icon to save your transformation map. Note that the messages area at the bottom left of Mapforce should look like the following:
    Image Modified

14. Select Output tab. Provided you specified a default value in the Input parameter, this will show the employees which will be selected. 
    

    Note
    title Note
    This view has been scrolled to the right, to show the Department Description column which has been retrieved from the related table XDEPARTMENTS.

    
    Image Modified

15. Close Mapforce.