{"id":1670,"date":"2011-09-26T03:45:58","date_gmt":"2011-09-26T08:45:58","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/legacy\/?page_id=1670"},"modified":"2011-12-22T16:44:11","modified_gmt":"2011-12-22T22:44:11","slug":"sample-external-object-sql-source-code","status":"publish","type":"page","link":"https:\/\/www.mrc-productivity.com\/legacy\/external-objects-udf\/sample-external-object-sql-source-code","title":{"rendered":"Sample External Object (SQL) Source Code"},"content":{"rendered":"<p><!-- Begin Content --><\/p>\n<h1>Sample External Object (SQL) Source Code<\/h1>\n<p>&nbsp;<\/p>\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<p><!-- End Content --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sample External Object (SQL) Source Code &nbsp; 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,"featured_media":0,"parent":1652,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1670","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/1670","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/comments?post=1670"}],"version-history":[{"count":1,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/1670\/revisions"}],"predecessor-version":[{"id":3444,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/1670\/revisions\/3444"}],"up":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/1652"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/media?parent=1670"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}