insert-createdata.sql

CREATE COMPUTE MODULE CreateData_Compute
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
DECLARE Source CHARACTER 'Production' ;
DECLARE DBSchema CHARACTER 'DB2ADMIN';
DECLARE Table CHARACTER 'EMPLOYEE';

SET OutputRoot = InputRoot;

DECLARE EMPNO1 REFERENCE TO InputRoot.JSON.Data.EMPNO;
DECLARE FIRSTNME1 REFERENCE TO InputRoot.JSON.Data.FIRSTNME;
DECLARE LASTNAME1 REFERENCE TO InputRoot.JSON.Data.LASTNAME;
DECLARE JOB1 REFERENCE TO InputRoot.JSON.Data.JOB;
DECLARE EDLEVEL1 REFERENCE TO InputRoot.JSON.Data.EDLEVEL;

INSERT INTO Database.EMPLOYEE (EMPNO, FIRSTNME, LASTNAME, JOB, EDLEVEL)
VALUES (EMPNO1, FIRSTNME1, LASTNAME1, JOB1, EDLEVEL1);

-- Set the Repsonse Here
-- you can modify the initial message, or create a new object
CREATE FIELD OutputRoot.JSON.Data.SUCCESS TYPE NameValue Value '';
SET OutputRoot.JSON.Data.SUCCESS = 'Details of Success Are Here';

PROPAGATE;

RETURN TRUE;
END;

END MODULE;