Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.
CREATE PROCEDURE DB2INST1.EMP_MULTIPLE_XML (IN DOC XML) RESULT SETS 1 LANGUAGE SQL SPECIFIC EMP_MULTIPLE_XML BEGIN DECLARE CSR1 CURSOR FOR select emp.empno, emp.firstnme, emp.lastname, emp.workdept from DB2INST1.EMPLOYEE emp where emp.empno in (select x."EMPNO" from XMLTABLE('$d/employee' PASSING DOC AS "d" COLUMNS "EMPNO" CHAR(6) PATH 'empno') AS X); OPEN CSR1; RETURN; CLOSE CSR1; END
Join the community of 500,000 technology professionals and ask your questions.