Sophie

Sophie

distrib > Fedora > 14 > x86_64 > media > updates > by-pkgid > 71d40963b505df4524269198e237b3e3 > files > 581

virtuoso-opensource-doc-6.1.4-2.fc14.noarch.rpm

<!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: sql_gettypeinfo - Virtuoso Functions Guide" />
  <meta name="dc.subject" content="Function: sql_gettypeinfo - Virtuoso Functions Guide" />
  <meta name="dc.creator" content="OpenLink Software Documentation Team ;&#10;" />
  <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: sql_gettypeinfo - Virtuoso Functions Guide</title>
  <meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" />
  <meta name="author" content="OpenLink Software Documentation Team ;&#10;" />
  <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_sql_gettypeinfo" />
    <img src="../images/misc/logo.jpg" alt="" />
    <h1>22. Virtuoso Functions Guide - sql_gettypeinfo</h1>
  </div>
  <div id="navbartop">
   <div>
      <a class="link" href="functions.html">Chapter Contents</a> | <a class="link" href="fn_sql_data_sources.html" title="sql_data_sources">Prev</a> | <a class="link" href="fn_sql_primary_keys.html" title="sql_primary_keys">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 &amp; 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 &amp; Decoding</a>
   </div>
   <div>
      <a href="functions.html#file">File Manipulation</a>
   </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 class="selected" href="functions.html#rmt">Remote SQL Data Source</a>
   </div>
   <div class="selected">
    <div>
        <a href="fn_att_local_name.html">att_local_name</a>
    </div>
    <div>
        <a href="fn_quote_dotted.html">quote_dotted</a>
    </div>
    <div>
        <a href="fn_rclose.html">rclose</a>
    </div>
    <div>
        <a href="fn_rexecute.html">rexecute</a>
    </div>
    <div>
        <a href="fn_rmoreresults.html">rmoreresults</a>
    </div>
    <div>
        <a href="fn_rnext.html">rnext</a>
    </div>
    <div>
        <a href="fn_rstmtexec.html">rstmtexec</a>
    </div>
    <div>
        <a href="fn_sql_columns.html">sql_columns</a>
    </div>
    <div>
        <a href="fn_sql_config_data_sources.html">sql_config_data_sour...</a>
    </div>
    <div>
        <a href="fn_sql_data_sources.html">sql_data_sources</a>
    </div>
    <div>
        <a href="fn_sql_driver_connect.html">sql_driver_connect</a>
    </div>
    <div>
        <a href="fn_sql_get_installed_drivers.html">sql_get_installed_dr...</a>
    </div>
    <div>
        <a href="fn_sql_get_private_profile_string.html">sql_get_private_prof...</a>
    </div>
    <div>
        <a class="selected" href="fn_sql_gettypeinfo.html">sql_gettypeinfo</a>
    </div>
    <div>
        <a href="fn_sql_primary_keys.html">sql_primary_keys</a>
    </div>
    <div>
        <a href="fn_sql_procedures.html">sql_procedures</a>
    </div>
    <div>
        <a href="fn_sql_remove_dsn_from_ini.html">sql_remove_dsn_from_...</a>
    </div>
    <div>
        <a href="fn_sql_special_columns.html">sql_special_columns</a>
    </div>
    <div>
        <a href="fn_sql_statistics.html">sql_statistics</a>
    </div>
    <div>
        <a href="fn_sql_tables.html">sql_tables</a>
    </div>
    <div>
        <a href="fn_sql_transact.html">sql_transact</a>
    </div>
    <div>
        <a href="fn_sql_write_file_dsn.html">sql_write_file_dsn</a>
    </div>
    <div>
        <a href="fn_sql_write_private_profile_string.html">sql_write_private_pr...</a>
    </div>
    <div>
        <a href="fn_vd_remote_data_source.html">vd_remote_data_sourc...</a>
    </div>
    <div>
        <a href="fn_vd_remote_proc_wrapper.html">vd_remote_proc_wrapp...</a>
    </div>
    <div>
        <a href="fn_vd_remote_table.html">vd_remote_table</a>
    </div>
    <div>
        <a href="fn_vd_statistics.html">vd_statistics</a>
    </div>
    <div>
        <a href="fn_vdd_disconnect_data_source.html">vdd_disconnect_data_...</a>
    </div>
    <div>
        <a href="fn_vdd_measure_rpc_time.html">vdd_measure_rpc_time</a>
    </div>
   </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 &amp; 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 &amp; Internet</a>
   </div>
   <div>
      <a href="functions.html#xml">XML</a>
   </div>
   <div>
      <a href="functions.html#XPATH">XPATH &amp; XQUERY</a>
   </div>
    <br />
   <div>
      <a href="functionidx.html">Functions Index</a>
   </div>
    <br />
  </div>
  <div id="text">
    <h2>sql_gettypeinfo</h2>
    <div class="refpurpose">return type information from a remote DSN</div>
    <div class="funcsynopsis">
        <span class="funcdef">vector <span class="function">sql_gettypeinfo</span>
      </span>
        (<span class="paramdef">in <span class="parameter">dsn</span> varchar</span>, 
        <span class="paramdef">in <span class="parameter">type</span> integer</span>);
      </div>
  
  
  
  <div class="refsect1">
      <div class="refsect1title">Description</div>
			<p>You can use the functions described here to find out information about the
remote datasources that you are using.  These could be especially useful in Virtuoso PL
later on if you are not able to know everything about the remote tables ahead of time for
the ATTACH TABLE statement.
statement</p>
			<p>
These SQL functions correspond to the ODBC catalog calls of similar name.
</p>
			<p>
The dsn argument must refer to a dsn previously defined by
vd_remote_data_source or ATTACH TABLE.
</p>
			<p>
By default information for all the data types supported by the remote is returned.
The optional type argument (defaults to SQL_ALL_TYPES) limits the information
returned to cover only the ODBC type number supplied.
</p>
			<p>
These functions return an array, with one element for each row of the result set.
Each row is represented as an array with one element for each column.
</p>
<div>
        <pre class="screen">

dbg_obj_print (sql_gettypeinfo (&#39;Local Virtuoso&#39;));
-&gt;
(
 (&quot;character&quot; 1 2000 &quot;&#39;&quot; &quot;&#39;&quot; &quot;length&quot; 1 1 3 0 0 0 &quot;varchar&quot; &lt;DB NULL&gt; &lt;DB NULL&gt; )
 (&quot;numeric&quot; 2 40 &quot;&quot; &quot;&quot; &quot;precision,scale&quot; 1 1 2 0 0 0 &quot;numeric&quot; 0 15 )
 (&quot;decimal&quot; 3 40 &quot;&quot; &quot;&quot; &quot;precision,scale&quot; 1 1 2 0 0 0 &quot;decimal&quot; 0 15 )
 (&quot;integer&quot; 4 10 &quot;&quot; &quot;&quot; &lt;DB NULL&gt; 1 1 2 0 0 0 &quot;integer&quot; 0 10 )
 (&quot;smallint&quot; 5 3 &quot;&quot; &quot;&quot; &lt;DB NULL&gt; 1 1 2 0 0 0 &quot;smallint&quot; &lt;DB NULL&gt; &lt;DB NULL&gt; )
 (&quot;smallint&quot; -7 3 &quot;&quot; &quot;&quot; &lt;DB NULL&gt; 1 1 2 0 0 0 &quot;smallint&quot; &lt;DB NULL&gt; &lt;DB NULL&gt; )
 (&quot;float&quot; 6 16 &quot;&quot; &quot;e0&quot; &lt;DB NULL&gt; 1 1 2 0 0 0 &quot;double precision&quot; &lt;DB NULL&gt; &lt;DB NULL&gt; )
 (&quot;real&quot; 7 16 &quot;&quot; &quot;e0&quot; &lt;DB NULL&gt; 1 1 2 0 0 0 &quot;real&quot; &lt;DB NULL&gt; &lt;DB NULL&gt; )
 (&quot;double precision&quot; 8 16 &quot;&quot; &quot;e0&quot; &lt;DB NULL&gt; 1 1 2 0 0 0 &quot;double precision&quot; &lt;DB NULL&gt; &lt;DB NULL&gt; )
 (&quot;varchar&quot; 12 2000 &quot;&#39;&quot; &quot;&#39;&quot; &quot;length&quot; 1 1 3 0 0 0 &quot;varchar&quot; &lt;DB NULL&gt; &lt;DB NULL&gt; )
 (&quot;long varchar&quot; -1 2147483647 &quot;&#39;&quot; &quot;&#39;&quot; &lt;DB NULL&gt; 1 1 0 0 0 0 &quot;long varchar&quot; &lt;DB NULL&gt; &lt;DB NULL&gt; )
 (&quot;long varbinary&quot; -4 2147483647 &quot;&#39;&quot; &quot;&#39;&quot; &lt;DB NULL&gt; 1 1 0 0 0 0 &quot;long varbinary&quot; &lt;DB NULL&gt; &lt;DB NULL&gt; )
 (&quot;datetime&quot; 11 19 &quot;{ts&quot; &quot;}&quot; &lt;DB NULL&gt; 1 1 3 0 0 0 &quot;datetime&quot; &lt;DB NULL&gt; &lt;DB NULL&gt; )
 (&quot;timestamp&quot; -2 10 &quot;0x&quot; &lt;DB NULL&gt; &lt;DB NULL&gt; 0 0 2 0 0 0 &quot;timestamp&quot; &lt;DB NULL&gt; &lt;DB NULL&gt; )
 (&quot;time&quot; 10 8 &quot;{t&quot; &quot;}&quot; &lt;DB NULL&gt; 1 1 2 0 0 0 &quot;time&quot; &lt;DB NULL&gt; &lt;DB NULL&gt; )
 (&quot;date&quot; 9 10 &quot;{d&quot; &quot;}&quot; &lt;DB NULL&gt; 1 1 2 0 0 0 &quot;date&quot; &lt;DB NULL&gt; &lt;DB NULL&gt; )
 (&quot;binary&quot; -2 2000 &quot;0x&quot; &quot;&quot; &quot;length&quot; 1 1 2 0 0 0 &quot;varbinary&quot; &lt;DB NULL&gt; &lt;DB NULL&gt; )
 (&quot;varbinary&quot; -3 2000 &quot;0x&quot; &quot;&quot; &quot;length&quot; 1 1 2 0 0 0 &quot;varbinary&quot; &lt;DB NULL&gt; &lt;DB NULL&gt; )
 (&quot;nchar&quot; -8 1000 &quot;N&#39;&quot; &quot;&#39;&quot; &quot;length&quot; 1 1 3 0 0 0 &quot;nvarchar&quot; &lt;DB NULL&gt; &lt;DB NULL&gt; )
 (&quot;nvarchar&quot; -9 1000 &quot;N&#39;&quot; &quot;&#39;&quot; &quot;length&quot; 1 1 3 0 0 0 &quot;nvarchar&quot; &lt;DB NULL&gt; &lt;DB NULL&gt; )
 (&quot;long nvarchar&quot; -10 1073741823 &quot;N&#39;&quot; &quot;&#39;&quot; &lt;DB NULL&gt; 1 1 0 0 0 0 &quot;long nvarchar&quot; &lt;DB NULL&gt; &lt;DB NULL&gt; )
)

</pre>
      </div>
	</div>
  <div class="refsect1">
    <div class="refsect1title">See Also</div>
    <p>
        <a href="fn_sql_data_sources.html">sql_data_sources</a>,
    <a href="fn_sql_columns.html">sql_columns</a>
    <a href="fn_sql_primary_keys.html">sql_primary_keys</a>,
    <a href="fn_sql_statistics.html">sql_statistics</a>,
    <a href="fn_sql_tables.html">sql_tables</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>

Perl :: Catalyst :: PostgreSQL :: RPM Valid HTML 4.01 Transitional