{"id":1670,"date":"2011-09-26T03:45:58","date_gmt":"2011-09-26T08:45:58","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/docs\/?page_id=1670"},"modified":"2021-09-30T09:46:12","modified_gmt":"2021-09-30T14:46:12","slug":"sample-external-object-sql-source-code","status":"publish","type":"ht_kb","link":"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/sample-external-object-sql-source-code","title":{"rendered":"Sample External Object (SQL) Source Code"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">Sample Source Code<\/h3>\n\n\n\n<p><code><br>\nCREATE procedure MRCWORKLIB.DELDETAIL(<br>\n&nbsp;inout orderno decimal(6,0))<br>\nLANGUAGE SQL<br>\nIS DETERMINISTIC<br>\nMODIFIES SQL DATA<br>\nBEGIN<br>\nDELETE FROM MRCWORKLIB.ORDDET WHERE ORDNUM = orderno;<br>\nEND<br>\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sample Source Code CREATE procedure MRCWORKLIB.DELDETAIL( &nbsp;inout orderno decimal(6,0)) LANGUAGE SQL IS DETERMINISTIC MODIFIES SQL DATA BEGIN DELETE FROM MRCWORKLIB.ORDDET WHERE ORDNUM = orderno; END<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[],"ht-kb-tag":[],"class_list":["post-1670","ht_kb","type-ht_kb","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/1670","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/comments?post=1670"}],"version-history":[{"count":3,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/1670\/revisions"}],"predecessor-version":[{"id":11085,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/1670\/revisions\/11085"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/media?parent=1670"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-category?post=1670"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-tag?post=1670"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}