<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html> <head profile="http://internetalchemy.org/2003/02/profile"> <link rel="foaf" type="application/rdf+xml" title="FOAF" href="http://www.openlinksw.com/dataspace/uda/about.rdf" /> <link rel="schema.dc" href="http://purl.org/dc/elements/1.1/" /> <meta name="dc.title" content="Function: file_stat - Virtuoso Functions Guide" /> <meta name="dc.subject" content="Function: file_stat - Virtuoso Functions Guide" /> <meta name="dc.creator" content="OpenLink Software Documentation Team ; " /> <meta name="dc.copyright" content="OpenLink Software, 1999 - 2009" /> <link rel="top" href="index.html" title="OpenLink Virtuoso Universal Server: Documentation" /> <link rel="search" href="/doc/adv_search.vspx" title="Search OpenLink Virtuoso Universal Server: Documentation" /> <link rel="parent" href="functions.html" title="Chapter Contents" /> <link rel="prev" href="appendixa.html" title="Appendix" /> <link rel="next" href="functions.html#.html" title="" /> <link rel="shortcut icon" href="../images/misc/favicon.ico" type="image/x-icon" /> <link rel="stylesheet" type="text/css" href="doc.css" /> <link rel="stylesheet" type="text/css" href="/doc/translation.css" /> <title>Function: file_stat - Virtuoso Functions Guide</title> <meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" /> <meta name="author" content="OpenLink Software Documentation Team ; " /> <meta name="copyright" content="OpenLink Software, 1999 - 2009" /> <meta name="keywords" content="" /> <meta name="GENERATOR" content="OpenLink XSLT Team" /> </head> <body> <div id="header"> <a name="fn_file_stat" /> <img src="../images/misc/logo.jpg" alt="" /> <h1>22. Virtuoso Functions Guide - file_stat</h1> </div> <div id="navbartop"> <div> <a class="link" href="functions.html">Chapter Contents</a> | <a class="link" href="fn_file_mkpath.html" title="file_mkpath">Prev</a> | <a class="link" href="fn_file_to_string.html" title="file_to_string">Next</a> </div> </div> <div id="currenttoc"> <form method="post" action="/doc/adv_search.vspx"> <div class="search">Keyword Search: <br /> <input type="text" name="q" /> <input type="submit" name="go" value="Go" /> </div> </form> <div> <a href="http://www.openlinksw.com/">www.openlinksw.com</a> </div> <div> <a href="http://docs.openlinksw.com/">docs.openlinksw.com</a> </div> <br /> <div> <a href="index.html">Book Home</a> </div> <br /> <div> <a href="contents.html">Contents</a> </div> <div> <a href="preface.html">Preface</a> </div> <br /> <div> <a class="selected" href="functions.html">Virtuoso Functions Guide</a> </div> <br /> <div> <a href="functions.html#admin">Administration</a> </div> <div> <a href="functions.html#aggr">Aggregate Functions</a> </div> <div> <a href="functions.html#array">Array Manipulation</a> </div> <div> <a href="functions.html#bpel">BPEL APIs</a> </div> <div> <a href="functions.html#backup">Backup</a> </div> <div> <a href="functions.html#compression">Compression</a> </div> <div> <a href="functions.html#cursors">Cursor</a> </div> <div> <a href="functions.html#time">Date & Time Manipulation</a> </div> <div> <a href="functions.html#debug">Debug</a> </div> <div> <a href="functions.html#dict">Dictionary Manipulation</a> </div> <div> <a href="functions.html#encoding">Encoding & Decoding</a> </div> <div> <a class="selected" href="functions.html#file">File Manipulation</a> </div> <div class="selected"> <div> <a href="fn_csv_cols_def.html">csv_cols_def</a> </div> <div> <a href="fn_csv_load.html">csv_load</a> </div> <div> <a href="fn_csv_load_file.html">csv_load_file</a> </div> <div> <a href="fn_csv_parse.html">csv_parse</a> </div> <div> <a href="fn_csv_table_def.html">csv_table_def</a> </div> <div> <a href="fn_file_delete.html">file_delete</a> </div> <div> <a href="fn_file_dirlist.html">file_dirlist</a> </div> <div> <a href="fn_file_mkdir.html">file_mkdir</a> </div> <div> <a href="fn_file_mkpath.html">file_mkpath</a> </div> <div> <a href="fn_file_open.html">file_open</a> </div> <div> <a class="selected" href="fn_file_stat.html">file_stat</a> </div> <div> <a href="fn_file_to_string.html">file_to_string</a> </div> <div> <a href="fn_file_to_string_output.html">file_to_string_outpu...</a> </div> <div> <a href="fn_file_unlink.html">file_unlink</a> </div> <div> <a href="fn_get_csv_row.html">get_csv_row</a> </div> <div> <a href="fn_gz_file_open.html">gz_file_open</a> </div> <div> <a href="fn_os_chmod.html">os_chmod</a> </div> <div> <a href="fn_os_chown.html">os_chown</a> </div> </div> <div> <a href="functions.html#ft">Free Text</a> </div> <div> <a href="functions.html#hash">Hashing / Cryptographic</a> </div> <div> <a href="functions.html#ldap">LDAP</a> </div> <div> <a href="functions.html#localization">Locale</a> </div> <div> <a href="functions.html#mail">Mail</a> </div> <div> <a href="functions.html#misc">Miscellaneous</a> </div> <div> <a href="functions.html#number">Number</a> </div> <div> <a href="functions.html#phrz">Phrases</a> </div> <div> <a href="functions.html#rdf">RDF data</a> </div> <div> <a href="functions.html#rmt">Remote SQL Data Source</a> </div> <div> <a href="functions.html#repl">Replication</a> </div> <div> <a href="functions.html#soap">SOAP</a> </div> <div> <a href="functions.html#sql">SQL</a> </div> <div> <a href="functions.html#string">String</a> </div> <div> <a href="functions.html#txn">Transaction</a> </div> <div> <a href="functions.html#type">Type Mapping</a> </div> <div> <a href="functions.html#uddi">UDDI</a> </div> <div> <a href="functions.html#udt">User Defined Types & The CLR</a> </div> <div> <a href="functions.html#vad">VAD</a> </div> <div> <a href="functions.html#jvmpl">Virtuoso Java PL API</a> </div> <div> <a href="functions.html#bif">Virtuoso Server Extension Interface (VSEI)</a> </div> <div> <a href="functions.html#ws">Web & Internet</a> </div> <div> <a href="functions.html#xml">XML</a> </div> <div> <a href="functions.html#XPATH">XPATH & XQUERY</a> </div> <br /> <div> <a href="functionidx.html">Functions Index</a> </div> <br /> </div> <div id="text"> <h2>file_stat</h2> <div class="refpurpose">get various OS statistics about a file</div> <div class="funcsynopsis"> <span class="funcdef"> <span class="function">file_stat</span> </span> (<span class="paramdef">in <span class="parameter">path</span> varchar</span>, <span class="paramdef">in <span class="parameter">what</span> integer</span>); </div> <div class="refsect1"> <div class="refsect1title">Description</div> <p> <span class="computeroutput">file_stat</span> returns various information for an OS file by calling stat () system call and converting the relevant value to a <span class="computeroutput">varchar</span>. The path is relative to the server's working directory. The what is an integer value selecting what information to return. If you don't supply second argument to the function it defaults to mode = 0.</p> <p>The DirsAllowed and DirsDenied lists in Parameters section of the virtuoso configuration file (virtuoso.ini by default) are not used to control disk access. </p> </div> <div class="refsect1"> <div class="refsect1title">Parameters</div> <div class="refsect2"> <span class="refsect2title">path – </span> <span class="computeroutput">varchar</span> relative path. </div> <div class="refsect2"> <span class="refsect2title">what – </span> <span class="computeroutput">integer</span> info to be returned. <ul> <li>0 - (default) file modification time (st_mtime) </li> <li>1 - file size (st_size, bytes) </li> <li>2 - file mode (st_mode, as integer) </li> <li>3 - file modification time for directories only (st_mtime) </li> <li>4 - file owner (user name corresponding to st_uid) </li> <li>5 - file group (group name corresponding to st_gid) </li> </ul> </div> </div> <div class="refsect1"> <div class="refsect1title">Examples</div> <a name="ex_file_stat" /> <div class="example"> <div class="exampletitle">Simple example</div> <p>Get the size of the virtuoso INI file</p> <div> <pre class="screen"> SQL>select file_stat (virtuoso_ini_path(), 1); callret VARCHAR _______________________________________________________________________________ 958 </pre> </div> </div> </div> <div class="refsect1"> <div class="refsect1title">See Also</div> <p> <a href="fn_file_delete.html">file_delete</a> </p> <p> <a href="fn_os_chmod.html">os_chmod</a> </p> <p> <a href="fn_os_chown.html">os_chown</a> </p> <p> <a href="fn_virtuoso_ini_path.html">virtuoso_ini_path</a> </p> </div> </div> <div id="footer"> <div>Copyright© 1999 - 2009 OpenLink Software All rights reserved.</div> <div id="validation"> <a href="http://validator.w3.org/check/referer"> <img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" height="31" width="88" /> </a> <a href="http://jigsaw.w3.org/css-validator/"> <img src="http://jigsaw.w3.org/css-validator/images/vcss" alt="Valid CSS!" height="31" width="88" /> </a> </div> </div> </body> </html>