“Add User” Stored Procedure inserts a record into the SQL table by using input parameters from Stored Procedure.
Once the stored procedure execution is completed, the Stored Procedure will return error code and error message back to stored procedure output parameters.
 

Stored Procedure syntax: sp_IAM_USERS(<ACTION>,<EmployeeID>,<Username>,<@APP_CODE>,<@ERROR_CODE>,<@ERROR_MESSAGE>)

Input parameters:  <Action>,<EmployeeID>, <Username>
Output parameters: @ERROR_CODE,@ERROR_MESSAGE,@APP_CODE

 
Call the DB2 stored procedure with parameters:

call sp_IAM_USERS(“USERADD”,”01091001”,”jataya”,@APP_CODE,@ERROR_CODE,@ERROR_MESSAGE)

 
If the employeeID “01091001”  already exists in the SQL table, then calling sp_IAM_USERS will return result:

@APP_CODE=”APP1”
@ERROR_CODE=”1”
@ERROR_MESSAGE=”Account already exists.”