1"use strict";(self.webpackChunkerpl_docusaurus=self.webpackChunkerpl_docusaurus||[]).push([[642],{8663:(e,n,r)=>{r.r(n),r.d(n,{assets:()=>o,contentTitle:()=>c,default:()=>f,frontMatter:()=>t,metadata:()=>i,toc:()=>l});const i=JSON.parse('{"id":"references/pragma","title":"Pragma Functions","description":"Reference documentation for SAP RFC Pragma functions in ERPL","source":"@site/docs/references/pragma.md","sourceDirName":"references","slug":"/references/pragma","permalink":"/docs/references/pragma","draft":false,"unlisted":false,"editUrl":"https://github.com/datazoode/erpl-landingpage/tree/main/docs/references/pragma.md","tags":[],"version":"current","sidebarPosition":1,"frontMatter":{"sidebar_position":1,"title":"Pragma Functions","description":"Reference documentation for SAP RFC Pragma functions in ERPL"},"sidebar":"docs","previous":{"title":"troubleshooting","permalink":"/docs/reference/troubleshooting"},"next":{"title":"sap_rfc_ping","permalink":"/docs/references/pragma/sap_rfc_ping"}}');var s=r(74848),a=r(28453);const t={sidebar_position:1,title:"Pragma Functions",description:"Reference documentation for SAP RFC Pragma functions in ERPL"},c="Pragma Functions",o={},l=[{value:"Available Functions",id:"available-functions",level:2},{value:"Configuration Management",id:"configuration-management",level:3},{value:"Trace and Debugging",id:"trace-and-debugging",level:3},{value:"Connection and Utility",id:"connection-and-utility",level:3},{value:"Usage Examples",id:"usage-examples",level:2}];function d(e){const n={a:"a",code:"code",h1:"h1",h2:"h2",h3:"h3",header:"header",li:"li",p:"p",pre:"pre",strong:"strong",ul:"ul",...(0,a.R)(),...e.components};return(0,s.jsxs)(s.Fragment,{children:[(0,s.jsx)(n.header,{children:(0,s.jsx)(n.h1,{id:"pragma-functions",children:"Pragma Functions"})}),"\n",(0,s.jsx)(n.p,{children:"Pragma functions are special SQL commands for configuring and managing the ERPL extension runtime behavior."}),"\n",(0,s.jsx)(n.h2,{id:"available-functions",children:"Available Functions"}),"\n",(0,s.jsx)(n.h3,{id:"configuration-management",children:"Configuration Management"}),"\n",(0,s.jsxs)(n.ul,{children:["\n",(0,s.jsxs)(n.li,{children:[(0,s.jsx)(n.strong,{children:(0,s.jsx)(n.a,{href:"/docs/references/pragma/sap_rfc_set_ini_path",children:"sap_rfc_set_ini_path"})})," - Specifies the path to the INI configuration file."]}),"\n",(0,s.jsxs)(n.li,{children:[(0,s.jsx)(n.strong,{children:(0,s.jsx)(n.a,{href:"/docs/references/pragma/sap_rfc_reload_ini_file",children:"sap_rfc_reload_ini_file"})})," - Reloads the INI configuration file without restarting DuckDB."]}),"\n"]}),"\n",(0,s.jsx)(n.h3,{id:"trace-and-debugging",children:"Trace and Debugging"}),"\n",(0,s.jsxs)(n.ul,{children:["\n",(0,s.jsxs)(n.li,{children:[(0,s.jsx)(n.strong,{children:(0,s.jsx)(n.a,{href:"/docs/references/pragma/sap_rfc_set_trace_level",children:"sap_rfc_set_trace_level"})})," - Sets the trace level for debugging and analysis purposes."]}),"\n",(0,s.jsxs)(n.li,{children:[(0,s.jsx)(n.strong,{children:(0,s.jsx)(n.a,{href:"/docs/references/pragma/sap_rfc_set_trace_dir",children:"sap_rfc_set_trace_dir"})})," - Specifies the directory where trace files should be stored."]}),"\n",(0,s.jsxs)(n.li,{children:[(0,s.jsx)(n.strong,{children:(0,s.jsx)(n.a,{href:"/docs/references/pragma/sap_rfc_set_maximum_trace_file_size",children:"sap_rfc_set_maximum_trace_file_size"})})," - Sets the maximum size for trace files."]}),"\n",(0,s.jsxs)(n.li,{children:[(0,s.jsx)(n.strong,{children:(0,s.jsx)(n.a,{href:"/docs/references/pragma/sap_rfc_set_maximum_stored_trace_files",children:"sap_rfc_set_maximum_stored_trace_files"})})," - Defines the maximum number of trace files to keep."]}),"\n"]}),"\n",(0,s.jsx)(n.h3,{id:"connection-and-utility",children:"Connection and Utility"}),"\n",(0,s.jsxs)(n.ul,{children:["\n",(0,s.jsxs)(n.li,{children:[(0,s.jsx)(n.strong,{children:(0,s.jsx)(n.a,{href:"/docs/references/pragma/sap_rfc_ping",children:"sap_rfc_ping"})})," - Checks the connectivity to the SAP system."]}),"\n"]}),"\n",(0,s.jsxs)(n.p,{children:["To inspect a function module's interface, use the table function ",(0,s.jsx)(n.a,{href:"/docs/reference/erpl-functions#sap_rfc_describe_function",children:(0,s.jsx)(n.code,{children:"sap_rfc_describe_function('FUNC_NAME')"})}),"."]}),"\n",(0,s.jsx)(n.h2,{id:"usage-examples",children:"Usage Examples"}),"\n",(0,s.jsx)(n.pre,{children:(0,s.jsx)(n.code,{className:"language-sql",children:'-- Set the trace level to verbose\nPRAGMA sap_rfc_set_trace_level(2);\n\n-- Check SAP connectivity\nPRAGMA sap_rfc_ping;\n\n-- Set the INI configuration file path\nPRAGMA sap_rfc_set_ini_path("/path/to/config.ini");\n'})}),"\n",(0,s.jsx)(n.p,{children:"For detailed documentation on each function, see the individual function pages linked above."})]})}function f(e={}){const{wrapper:n}={...(0,a.R)(),...e.components};return n?(0,s.jsx)(n,{...e,children:(0,s.jsx)(d,{...e})}):d(e)}},28453:(e,n,r)=>{r.d(n,{R:()=>t,x:()=>c});var i=r(96540);const s={},a=i.createContext(s);function t(e){const n=i.useContext(a);return i.useMemo(function(){return"function"==typeof e?e(n):{...n,...e}},[n,e])}function c(e){let n;return n=e.disableParentContext?"function"==typeof e.components?e.components(s):e.components||s:t(e.components),i.createElement(a.Provider,{value:n},e.children)}}}]);
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.