Step 2. Create a CSV file with Column Headings to Send
INT004 - Using the LANSA User Agent
In this step, you will create the file containing the data to be sent using the LANSA User Agent. The file contains a list of employee numbers and the new salaries for those employees.
1. Start the editor in Windows.
2. Enter the following comma separated data:
EMPNO,SALARY,STARTDTER,DEPTMENT,SECTION
A1004,53400,910521,ADM,01
A1005,53500,950102,ADM,01
A1006,53600,891201,MKT,02
Ensure that the employee identifiers in the EMPNO column (A1004, A1005 and A1006) exist in file PSLMST in the partition where the server side RDML function will execute. (If the data does not exist in PSLMST file, substitute employee identifiers that do exist.) Enter the rest of the data as shown.
3. Using the File menu, select the Save As option using these options:
|
Save in |
locate the project directory which you created in Step 1. For example: C:\Program Files\LANSA\Integrator\Studio\workspace\iii Training\solutions\SendCSVFile\ |
|
File Name |
iii_employee_new_salary.csv |
|
Save as Type |
All Files |