<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML+RDFa 1.0//EN" "http://www.w3.org/MarkUp/DTD/xhtml-rdfa-1.dtd"> <html lang="en" itemscope="itemscope" itemtype="http://schema.org/WebPage" itemid="http://docs.openlinksw.com/virtuoso/functions.rss/" xmlns:n0="http://www.w3.org/2000/xmlns/" n0:og="http://ogp.me/ns#" n0:fb="http://ogp.me/ns/fb#" n0:xhv="http://www.w3.org/1999/xhtml/vocab#" xmlns:xh="http://www.w3.org/1999/xhtml" xmlns:addthis="http://www.addthis.com/help/api-spec"> <head> <meta charset="UTF-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <title itemprop="name">OpenLink Software: Product Documentation</title> <link rel="STYLESHEET" href="/skin/docs-v3/css/opl-style.css" /> <link rel="apple-touch-icon" sizes="180x180" href="/apple-touch-icon.png" /> <link rel="icon" type="image/png" href="/favicon-32x32.png" sizes="32x32" /> <link rel="icon" type="image/png" href="/favicon-16x16.png" sizes="16x16" /> <link rel="manifest" href="/manifest.json" /> <link rel="mask-icon" href="/safari-pinned-tab.svg" color="#5bbad5" /> <meta name="theme-color" content="#ffffff" /> <link href="/virtuoso/feeds/rss/" type="application/rss+xml" rel="alternate" title="OpenLink Software: RSS Feed: virtdocs" /> <link href="/virtuoso/feeds/atom/" type="application/atom+xml" rel="alternate" title="OpenLink Software: Atom Feed: virtdocs" /> <link href="/virtuoso/feeds/json/" type="application/feed+json" rel="alternate" title="OpenLink Software: JSON Feed: virtdocs" /> <script type="application/ld+json"> { "@context": "http://schema.org/", "@type": "WebSite", "url": "http://docs.openlinksw.com/virtuoso/functions.rss/", "potentialAction": { "@type": "SearchAction", "name": "Website Search", "target": "/search/?q={search_term_string}", "query-input": "required name=search_term_string" } } </script><style type="text/css"> body * { font-display: swap; } div#repaint { position: absolute; width: 100%; height: 100%; left: 0; top: 0; background-color: white; z-index: 1000; } </style><script type="text/javascript"> function embedToData(id, encodeURI=1) { var fieldnames = $("#" + id).xpath("*//div[contains(@class,'header') and contains(@class,'field')]").map(function(idx, x) { return x.innerHTML }).toArray(); var rows = $.xpath("#"+id, "div[contains(@class,'results')]/div"); var norows=rows.length; var nocols=fieldnames.length; var data=[]; for(r=0; r<norows; r++) { data[r]={}; for(c=0; c<nocols; c++) { data[r][fieldnames[c]]=rows[r].children[c].innerHTML; if(!encodeURI) { data[r][fieldnames[c]]=rows[r].children[c].innerText.trim(); } } } return data; } function embedToDataCSV(id, encodeURI=1) { var fieldnames = $("#" + id).xpath("*//div[contains(@class,'header') and contains(@class,'field')]").map(function(idx, x) { return x.innerHTML }).toArray(); var rows = $.xpath("#"+id, "div[contains(@class,'results')]/div"); var norows=rows.length; var nocols=fieldnames.length; var data=[]; for(r=0; r<norows; r++) { data[r]=[]; for(c=0; c<nocols; c++) { data[r][c]=rows[r].children[c].innerHTML; if(!encodeURI) { data[r][c]=rows[r].children[c].innerText.trim(); } } } var obj=Object(); obj.data=data; obj.dims=[ nocols, norows ]; obj.fieldnames=fieldnames; return obj; } </script> </head> <body onload=""> <div class="gridcontainer"> <header class="masthead"> <ul> <li> <a href="//www.openlinksw.com/"><img src="/skin/docs-v3/images/logo.png" alt="OpenLink Software logo" /> </a> </li> <li> <a href="//www.openlinksw.com/" title="Corporate Homepage"> OpenLink Software</a> </li> <li> <a href="//docs.openlinksw.com" title="Product Documentation">Documentation</a> </li> <li> <a href="//community.openlinksw.com" title="Community Discussion Forum">Community Forum</a> </li> <li> <a href="//support.openlinksw.com" title="Customer Support Portal">Support</a> </li> <li> <a href="//shop.openlinksw.com" title="OpenLink Shop">Shop</a> </li> <li> <a href="//virtuoso.openlinksw.com" title="Virtuoso Universal Server product home">Virtuoso</a> </li> <li> <a href="//uda.openlinksw.com" title="Universal Data Access Drivers products">UDA</a> </li> </ul> <div id="search"> <form id="searchform" name="searchform" action="/search.vsp" method="post"><input type="text" name="q" size="24" id="new_search_txt" accesskey="/" value="search..." onclick="javascript:this.value=''" /> <svg onclick="javascript:document.searchform.submit()" viewBox="0 0 24 24" fill="currentColor" width="1em" height="1em" class="x1lliihq x1heor9g xxk0z11 xvy4d1p" role="img" aria-label="Search"><path fill-rule="evenodd" clip-rule="evenodd" d="M16.618 18.032a9 9 0 1 1 1.414-1.414l3.675 3.675a1 1 0 0 1-1.414 1.414l-3.675-3.675zM18 11a7 7 0 1 1-14 0 7 7 0 0 1 14 0z"></path> </svg> </form> </div> </header> <div class="leftmargin"> <div class="navfootertop"></div> <div class="hamburger" onclick="toggleMenu()"> <div class="bar"></div> <div class="bar"></div> <div class="bar"></div> </div> <div class="menu" id="menu"> <ul> <li class="menupoint"> <a href="/">Documentation Home</a> </li> <li class="menupoint expandable"> <a id="menuuda" onclick="toggleSubmenu(this)">Universal Data Access (UDA) Documentation <br /> - ODBC, JDBC, ADO.NET, OLEDB </a> <ul class="submenu"> <li> <a href="http://wikis.openlinksw.com/UdaWikiWeb/UDAInstallConfig">Installation Guide</a> </li> <li> <a onclick="toggleSubmenu(this)">Enterprise Edition (Multi-Tier) Manual</a> <ul class="submenu"> <li> <a href="/uda/mt/mt/">OpenLink ODBC Driver (Multi-Tier Edition) Documentation</a> </li> <li> <a href="/uda/mt/bk01pr01/">Preface</a> </li> <li> <a href="/uda/mt/mt_overview/">Overview</a> </li> <li> <a href="/uda/mt/mt_newfeatures/">New Features in OpenLink UDA</a> </li> <li> <a href="/uda/mt/mt_clientcompinstall/">OpenLink ODBC Driver (Multi-Tier Edition) Client Component</a> </li> <li> <a href="/uda/mt/mt_dotnet/">OpenLink ADO.NET Data Providers</a> </li> <li> <a href="/uda/mt/mt_oledb/">OpenLink OLE-DB Provider</a> </li> <li> <a href="/uda/mt/mt_srvcompinstall/">Server Components Installation</a> </li> <li> <a href="/uda/mt/mt_SrvCompAdm/">Request Broker Administration</a> </li> <li> <a href="/uda/mt/mt_AgentCompAdm/">Server Agent Administration</a> </li> <li> <a href="/uda/mt/mt_uda52ssl/">Securing a Multi-Tier connection using SSL</a> </li> <li> <a href="/uda/mt/mt_UDAZeroConf/">Zero Configuration Networking</a> </li> <li> <a href="/uda/mt/mt_JDBCClientClasses/">JDBC Components</a> </li> <li> <a href="/uda/mt/mt_xamt/">Distributed Transaction Processing (XA)</a> </li> <li> <a href="/uda/mt/mt_udauserrac/">Real Application Cluster (RAC) / TAF Support</a> </li> <li> <a href="/uda/mt/mt_iodbc/">OpenLink ODBC Driver Manager (iODBC SDK)</a> </li> <li> <a href="/uda/mt/mt_sampleapps/">Sample Applications</a> </li> <li> <a href="/uda/mt/mt_bugsfixed/">Bugs Fixed</a> </li> <li> <a href="/uda/mt/mt_appendix/">Technical Appendix</a> </li> </ul> </li> <li> <a onclick="toggleSubmenu(this)">Express Edition (Single-Tier) Manual</a> <ul class="submenu"> <li> <a href="/uda/ee/ee_EEIntro/">OpenLink ODBC Driver (Express Edition) Documentation</a> </li> <li> <a href="/uda/ee/ee_licensing/">Product Licensing</a> </li> <li> <a href="/uda/ee/ee_EEDB2/">OpenLink ODBC Driver for DB2 (Express Edition)</a> </li> <li> <a href="/uda/ee/ee_EEFireBird/">OpenLink ODBC Driver for Firebird (Express Edition)</a> </li> <li> <a href="/uda/ee/ee_EEInformix/">OpenLink ODBC Driver for Informix (Express Edition)</a> </li> <li> <a href="/uda/ee/ee_EEIngres/">OpenLink ODBC Driver for Ingres (Express Edition)</a> </li> <li> <a href="/uda/ee/ee_EEMySQL/">OpenLink ODBC Driver for MySQL (Express Edition)</a> </li> <li> <a href="/uda/ee/ee_EEOracle/">OpenLink ODBC Driver for Oracle (Express Edition)</a> </li> <li> <a href="/uda/ee/ee_EEPostgres/">OpenLink ODBC Driver for PostgreSQL (Express Edition)</a> </li> <li> <a href="/uda/ee/ee_EESQLServer/">OpenLink ODBC Driver for SQL Server (Express Edition)</a> </li> <li> <a href="/uda/ee/ee_EESybase/">OpenLink ODBC Driver for Sybase (Express Edition)</a> </li> </ul> </li> <li> <a onclick="toggleSubmenu(this)">Lite Edition (Single-Tier) Manual</a> <ul class="submenu"> <li> <a href="/uda/lite/bk03pr01/">Preface</a> </li> <li> <a href="/uda/lite/lite_odbcintro/">Overview</a> </li> <li> <a href="/uda/lite/lite_newfeatures/">New Features in OpenLink UDA</a> </li> <li> <a href="/uda/lite/lite_requirements/">OpenLink ODBC Driver (Single-Tier Edition) System Requirements and Basic Instructions</a> </li> <li> <a href="/uda/lite/lite_installation/">OpenLink ODBC Driver (Single-Tier Edition) Installation</a> </li> <li> <a href="/uda/lite/lite_datasource/">OpenLink ODBC Driver (Single-Tier Edition) Configuration</a> </li> <li> <a href="/uda/lite/lite_dotnet/">OpenLink ADO.NET Data Providers</a> </li> <li> <a href="/uda/lite/lite_oled b/">OpenLink OLE-DB Provider</a> </li> <li> <a href="/uda/lite/lite_tuning/">OpenLink ODBC Driver (Single-Tier Edition) Performance Tuning</a> </li> <li> <a href="/uda/lite/lite_iodbc/">OpenLink ODBC Driver Manager (iODBC SDK)</a> </li> <li> <a href="/uda/lite/lite_mac/">Mac OS X Specifics</a> </li> <li> <a href="/uda/lite/lite_jdbc/">JDBC Components</a> </li> <li> <a href="/uda/lite/lite_xa/">Distributed Transaction Processing (XA)</a> </li> <li> <a href="/uda/lite/lite_udauserrac/">Real Application Cluster (RAC) / TAF Support</a> </li> <li> <a href="/uda/lite/lite_odbcwithperl/">Using OpenLink Single-Tier ODBC Drivers with Perl</a> </li> <li> <a href="/uda/lite/lite_sampleapps/">Sample Applications</a> </li> <li> <a href="/uda/lite/lite_bugsfixed/">Bugs Fixed</a> </li> <li> <a href="/uda/lite/lite_appendix/">Technical Appendix</a> </li> </ul> </li> </ul> </li> <li class="menupoint expandable"> <a id="menuvirtuoso" onclick="toggleSubmenu(this)">Virtuoso Documentation</a> <ul class="submenu"> <li> <a href="http://wikis.openlinksw.com/VirtuosoWikiWeb/VirtuosoInstallConfig">Installation Guide</a> </li> <li class="expandable"> <a id="menuvirtuosoinside" onclick="toggleSubmenu(this)">Manual</a> <ul class="submenu"> <li> <a href="/virtuoso/">Home</a> </li> <li> <a href="/virtuoso/preface/">Preface</a> </li> <li> <a href="/virtuoso/ch-overview/">Overview</a> </li> <li> <a href="/virtuoso/ch-installation/">Installation Guide</a> </li> <li> <a href="/virtuoso/ch-quicktours/">Quick Start &Tours</a> </li> <li> <a href="/virtuoso/ch-sampleapps/">Sample ODBC &JDBC Applications</a> </li> <li> <a href="/virtuoso/ch-concepts/">Conceptual Overview</a> </li> <li> <a href="/virtuoso/ch-server/">Conductor Guide</a> </li> <li> <a href="/virtuoso/ch-server/">Virtuoso Server</a> </li> <li> <a href="/virtuoso/ch-accessinterfaces/">Data Access Interfaces</a> </li> <li> <a href="/virtuoso/ch-vdbengine/">Virtual Database Engine</a> </li> <li> <a href="/virtuoso/ch-sqlreference/">SQL Reference</a> </li> <li> <a href="/virtuoso/ch-clusterprogramming/">Virtuoso Cluster Programming</a> </li> <li> <a href="/virtuoso/ch-sqlprocedures/">SQL Procedure Language Guide</a> </li> <li> <a href="/virtuoso/ch-hooks/">Database Event Hooks</a> </li> <li> <a href="/virtuoso/ch-repl/">Data Replication Services</a> </li> <li> <a href="/virtuoso/ch-webappdevelopment/">Web Application Development</a> </li> <li> <a href="/virtuoso/ch-webandxml/">XML Support</a> </li> <li> <a href="/virtuoso/ch-rdfandsparql/">RDF Data Access Management</a> </li> <li> <a href="/virtuoso/ch-webservices/">Web Services</a> </li> <li> <a href="/virtuoso/ch-runtimehosting/">Runtime Hosting</a> </li> <li> <a href="/virtuoso/ch-internetservices/">Internet Services</a> </li> <li> <a href="/virtuoso/ch-freetext/">Free Text Search</a> </li> <li> <a href="/virtuoso/ch-tpcc/">TPC C Benchmark Kit</a> </li> <li> <a href="/virtuoso/ch-xa/">Using Virtuoso with Tuxedo</a> </li> <li> <a href="/virtuoso/ch-appendixa/">Appendix A</a> </li> <li> <a href="/virtuoso/ch-functions/">Functions Reference Guide</a> </li> </ul> </li> <li> <a href="http://wikis.openlinksw.com/VirtuosoWikiWeb/WelcomeVisitors">Evolving Documentation</a> </li> </ul> </li> <li class="menupoint"> <a onclick="toggleSubmenu(this)">OpenLink Software</a> <ul> <li> <a href="http://uda.openlinksw.com/">Universal Data Access (UDA)</a> <ul class="submenu"> <li>ODBC, JDBC, ADO.NET and OleDB Drivers</li> </ul> </li> <li> <a href="http://virtuoso.openlinksw.com/">Virtuoso</a> </li> <li> <a href="http://vos.openlinksw.com/">Virtuoso Open-Souce Edition</a> </li> <li> <a href="http://osde.openlinksw.com/">OpenLink Structured Data Editor</a> </li> <li> <a href="http://osds.openlinksw.com/">OpenLink Structured Data Sniffer</a> </li> <li> <a href="http://ods.openlinksw.com/wiki/ODS/">OpenLink Data Spaces (ODS)</a> </li> </ul> </li> </ul> </div> </div> <div class="content"> <a id="top">  </a><a href="#top" id="toplink">Top</a> <div> <div></div> <div id="thecontent"> <div id="notfound"></div> </div> </div> </div> <div class="navfooter"></div> <div role="contentinfo" class="copyright"> <p>© OpenLink Software <span id="footercopyrightyear">2016</span> . </p> </div> </div> <script> function toggleMenu() { var menu = document.getElementById('menu'); if (menu.style.display === 'block') { menu.style.display = 'none'; } else { menu.style.display = 'block'; } } function toggleSubmenu(element) { var parentLi = element.parentElement; parentLi.classList.toggle('active'); } function permalink(el) { var link=el.href if(!link.match(/^https?:/)) { link=document.location.href + el.href } navigator.clipboard.writeText(link) alert("Link copied to clipboard") } function startup() { var path=document.location.pathname var udatop=document.getElementById("menuuda") var udainside=document.getElementById("menuudainside") var virtuosotop=document.getElementById("menuvirtuoso") var virtuosoinside=document.getElementById("menuvirtuosoinside") var navfootertopprev=document.getElementById("navfootertopprev") var navfootertopnext=document.getElementById("navfootertopnext") var navprev=document.querySelector("body > div.gridcontainer > div.navfooter > table > tbody > tr:nth-child(1) > td:nth-child(1) > a") var navnext=document.querySelector("body > div.gridcontainer > div.navfooter > table > tbody > tr:nth-child(1) > td:nth-child(3) > a") var navprevtitle=document.querySelector("body > div.gridcontainer > div.navfooter > table > tbody > tr:nth-child(2) > td:nth-child(1)") var navnexttitle=document.querySelector("body > div.gridcontainer > div.navfooter > table > tbody > tr:nth-child(2) > td:nth-child(3)") var d=new Date() var did=document.getElementById("footercopyrightyear") did.innerHTML = d.getFullYear() if(window.innerWidth/14 > 58) { if (path.match(/^\/virtuoso/)) { toggleSubmenu(virtuosotop) toggleSubmenu(virtuosoinside) } if (path.match(/^\/uda/)) { toggleSubmenu(udatop) toggleSubmenu(udainside) } } if(navfootertopprev && navprevtitle) { navprevtitle=navprevtitle.innerHTML navfootertopprev.innerHTML='<a accesskey="p" title="Previous: '+navprevtitle+'" href="'+navprev.getAttribute("href")+'">芦</a>' } if(navfootertopnext && navnexttitle) { navnexttitle=navnexttitle.innerHTML navfootertopnext.innerHTML='<a accesskey="n" title="Next: '+navnexttitle+'" href="'+navnext.getAttribute("href")+'">禄</a>' } } startup(); </script>   <script type="text/javascript"> $(document).xpath("//div[contains(@class,'embeddedsparql') and @id and @data-oplembed-target and @data-oplembed-template]").each( function(idx, datid) { var id = $(datid).attr("id"); var data= embedToData(id, 0); var dest= $(datid).attr("data-oplembed-target"); var templt= $("#"+id).attr("data-oplembed-template"); if(typeof embedDataPreHook === "function") { embedDataPreHook(datid); } if(typeof embedDataFixes === "function") { $("#"+dest).loadTemplate($("#"+templt), data, {complete: embedDataFixes}); } else { $("#"+dest).loadTemplate($("#"+templt), data); } if(typeof embedDataPostHook === "function") { embedDataPostHook(datid); } $(datid).toggle(false); } ) </script> </body> </html>

CINXE.COM