Sample External Object (SQL) Source Code

Sample Source Code


CREATE procedure MRCWORKLIB.DELDETAIL(
 inout orderno decimal(6,0))
LANGUAGE SQL
IS DETERMINISTIC
MODIFIES SQL DATA
BEGIN
DELETE FROM MRCWORKLIB.ORDDET WHERE ORDNUM = orderno;
END