Mass Employee Salary Update

LANSA

Mass Employee Salary Update
Email Document Handling SystemTo Execute this ExampleThe Things that Make Up this Example



This MS-Excel spread sheet allows you to enter up to 190 employee number / updated salary pair details down and across the spreadsheet.

When the document is emailed to the email inbox the employee number and salary details are extracted and passed to RDML function SET208S running on your iSeries server. SET208S then attempt to update each specified employee to have the salary specified. Details of the success (or failure) of each salary update are then emailed back to you.

To try this out locate SET208S.XLS on your system (usually in the current partition’s SOURCE directory) and open it.