<?php include_once '../doc-typo3-funcs.php'; $doxygen_vars = array( "title" => "TYPO3 4.0.1: ADODB_ODBC_DB2 Class Reference", "datetime" => "Sat Dec 2 19:23:30 2006", "date" => "2 Dec 2006", "doxygenversion" => "1.4.6", "projectname" => "TYPO3 4.0.1", "projectnumber" => "4.0.1" ); get_header($doxygen_vars); ?> <!-- Generated by Doxygen 1.4.6 --> <div class="tabs"> <ul> <li><a href="main.html"><span>Main Page</span></a></li> <li><a href="namespaces.html"><span>Namespaces</span></a></li> <li id="current"><a href="classes.html"><span>Classes</span></a></li> <li><a href="files.html"><span>Files</span></a></li> <li><a href="dirs.html"><span>Directories</span></a></li> <li><a href="pages.html"><span>Related Pages</span></a></li> <li><a href="examples.html"><span>Examples</span></a></li> <li> <form action="search.php" method="get"> <table cellspacing="0" cellpadding="0" border="0"> <tr> <td><label> <u>S</u>earch for </label></td> <td><input type="text" name="query" value="" size="20" accesskey="s"/></td> </tr> </table> </form> </li> </ul></div> <div class="tabs"> <ul> <li><a href="classes.html"><span>Alphabetical List</span></a></li> <li><a href="annotated.html"><span>Class List</span></a></li> <li><a href="hierarchy.html"><span>Class Hierarchy</span></a></li> <li><a href="functions.html"><span>Class Members</span></a></li> </ul></div> <h1>ADODB_ODBC_DB2 Class Reference</h1><!-- doxytag: class="ADODB_ODBC_DB2" --><!-- doxytag: inherits="ADODB_odbc" -->Inheritance diagram for ADODB_ODBC_DB2:<p><center><img src="classADODB__ODBC__DB2__inherit__graph.png" border="0" usemap="#ADODB__ODBC__DB2__inherit__map" alt="Inheritance graph"></center> <map name="ADODB__ODBC__DB2__inherit__map"> <area href="classADODB__odbc.html" shape="rect" coords="5,7,264,609" alt=""> </map> <center><font size="2">[<a target="top" href="graph_legend.html">legend</a>]</font></center>Collaboration diagram for ADODB_ODBC_DB2:<p><center><img src="classADODB__ODBC__DB2__coll__graph.png" border="0" usemap="#ADODB__ODBC__DB2__coll__map" alt="Collaboration graph"></center> <map name="ADODB__ODBC__DB2__coll__map"> <area href="classADODB__odbc.html" shape="rect" coords="5,7,264,609" alt=""> </map> <center><font size="2">[<a target="top" href="graph_legend.html">legend</a>]</font></center><a href="classADODB__ODBC__DB2-members.html">List of all members.</a><table border="0" cellpadding="0" cellspacing="0"> <tr><td></td></tr> <tr><td colspan="2"><br><h2>Public Member Functions</h2></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="8b1caa6c7de31be9921546817d24c969"></a><!-- doxytag: member="ADODB_ODBC_DB2::ADODB_DB2" ref="8b1caa6c7de31be9921546817d24c969" args="()" --> </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__ODBC__DB2.html#8b1caa6c7de31be9921546817d24c969">ADODB_DB2</a> ()</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="6bc45975d8792305ad3e8301b422cd50"></a><!-- doxytag: member="ADODB_ODBC_DB2::IfNull" ref="6bc45975d8792305ad3e8301b422cd50" args="($field, $ifNull)" --> </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__ODBC__DB2.html#6bc45975d8792305ad3e8301b422cd50">IfNull</a> ($field, $ifNull)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__ODBC__DB2.html#5f6c45540c1e5fd90b25b22996c4ba70">ServerInfo</a> ()</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="0118e1b5f3eb7df2abac7caece418b0b"></a><!-- doxytag: member="ADODB_ODBC_DB2::_insertid" ref="0118e1b5f3eb7df2abac7caece418b0b" args="()" --> </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__ODBC__DB2.html#0118e1b5f3eb7df2abac7caece418b0b">_insertid</a> ()</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="060c923e7a6bdb43c6a47b7f58c3e86b"></a><!-- doxytag: member="ADODB_ODBC_DB2::RowLock" ref="060c923e7a6bdb43c6a47b7f58c3e86b" args="($tables, $where, $flds='1 as ignore')" --> </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__ODBC__DB2.html#060c923e7a6bdb43c6a47b7f58c3e86b">RowLock</a> ($tables, $where, $flds='1 as ignore')</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="edbee26b5c442d6e65abbe1f2389e4b4"></a><!-- doxytag: member="ADODB_ODBC_DB2::MetaTables" ref="edbee26b5c442d6e65abbe1f2389e4b4" args="($ttype=false, $showSchema=false, $qtable="%", $qschema="%")" --> & </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__ODBC__DB2.html#edbee26b5c442d6e65abbe1f2389e4b4">MetaTables</a> ($ttype=false, $showSchema=false, $qtable="%", $qschema="%")</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">& </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__ODBC__DB2.html#62b05fbf8dcd26939566cafa488b4f05">MetaIndexes</a> ($table, $primary=FALSE, $owner=false)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="e0c3928b634db486372f12a33debd636"></a><!-- doxytag: member="ADODB_ODBC_DB2::SQLDate" ref="e0c3928b634db486372f12a33debd636" args="($fmt, $col=false)" --> </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__ODBC__DB2.html#e0c3928b634db486372f12a33debd636">SQLDate</a> ($fmt, $col=false)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="21922603aa072743c4b5a8943c013856"></a><!-- doxytag: member="ADODB_ODBC_DB2::SelectLimit" ref="21922603aa072743c4b5a8943c013856" args="($sql, $nrows=-1, $offset=-1, $inputArr=false)" --> & </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__ODBC__DB2.html#21922603aa072743c4b5a8943c013856">SelectLimit</a> ($sql, $nrows=-1, $offset=-1, $inputArr=false)</td></tr> <tr><td colspan="2"><br><h2>Public Attributes</h2></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="9f25e4e3eacb6e70e4015d42f6262cd1"></a><!-- doxytag: member="ADODB_ODBC_DB2::$databaseType" ref="9f25e4e3eacb6e70e4015d42f6262cd1" args="" --> </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__ODBC__DB2.html#9f25e4e3eacb6e70e4015d42f6262cd1">$databaseType</a> = "db2"</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="41be0711779d6c04b803434648b7a2df"></a><!-- doxytag: member="ADODB_ODBC_DB2::$concat_operator" ref="41be0711779d6c04b803434648b7a2df" args="" --> </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__ODBC__DB2.html#41be0711779d6c04b803434648b7a2df">$concat_operator</a> = '||'</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">maximum size of blobs or large text fields (262144 = 256K)-- some db's die otherwise like foxpro <br></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="e94bceb3416f164abff192d77b96dc0b"></a><!-- doxytag: member="ADODB_ODBC_DB2::$sysTime" ref="e94bceb3416f164abff192d77b96dc0b" args="" --> </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__ODBC__DB2.html#e94bceb3416f164abff192d77b96dc0b">$sysTime</a> = 'CURRENT TIME'</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="820c937c0945de2b08147d2318ba7d72"></a><!-- doxytag: member="ADODB_ODBC_DB2::$sysDate" ref="820c937c0945de2b08147d2318ba7d72" args="" --> </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__ODBC__DB2.html#820c937c0945de2b08147d2318ba7d72">$sysDate</a> = 'CURRENT DATE'</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">cache for 1 hour <br></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="85d9cd822fa72afd5727c772596ef810"></a><!-- doxytag: member="ADODB_ODBC_DB2::$sysTimeStamp" ref="85d9cd822fa72afd5727c772596ef810" args="" --> </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__ODBC__DB2.html#85d9cd822fa72afd5727c772596ef810">$sysTimeStamp</a> = 'CURRENT TIMESTAMP'</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">name of function that returns the current date <br></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="16f5b62b7d4e029c014ba1c4ac861f67"></a><!-- doxytag: member="ADODB_ODBC_DB2::$fmtTimeStamp" ref="16f5b62b7d4e029c014ba1c4ac861f67" args="" --> </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__ODBC__DB2.html#16f5b62b7d4e029c014ba1c4ac861f67">$fmtTimeStamp</a> = "'Y-m-d-H.i.s'"</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">used by <a class="el" href="classADOConnection.html#cb3116e6c17d7d43e8104df34aef3066">DBDate()</a> as the default date format used by the database <br></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="003cbd1b89612fa5ba83162ad08225aa"></a><!-- doxytag: member="ADODB_ODBC_DB2::$ansiOuter" ref="003cbd1b89612fa5ba83162ad08225aa" args="" --> </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__ODBC__DB2.html#003cbd1b89612fa5ba83162ad08225aa">$ansiOuter</a> = true</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">operator to use for right outer join in WHERE clause <br></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="2b942948d2d7f023fc5aa61db969b667"></a><!-- doxytag: member="ADODB_ODBC_DB2::$identitySQL" ref="2b942948d2d7f023fc5aa61db969b667" args="" --> </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__ODBC__DB2.html#2b942948d2d7f023fc5aa61db969b667">$identitySQL</a> = 'values IDENTITY_VAL_LOCAL()'</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="e404172d9b024019684336b36308dd20"></a><!-- doxytag: member="ADODB_ODBC_DB2::$_bindInputArray" ref="e404172d9b024019684336b36308dd20" args="" --> </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__ODBC__DB2.html#e404172d9b024019684336b36308dd20">$_bindInputArray</a> = true</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">A boolean variable to state whether its a persistent connection or normal connection. */. <br></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="59de8dee0bee5a2cf843d36fd204ed4a"></a><!-- doxytag: member="ADODB_ODBC_DB2::$hasInsertID" ref="59de8dee0bee5a2cf843d36fd204ed4a" args="" --> </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__ODBC__DB2.html#59de8dee0bee5a2cf843d36fd204ed4a">$hasInsertID</a> = true</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="anchor" name="b7fa84114614d87a4246121670ad6c4d"></a><!-- doxytag: member="ADODB_ODBC_DB2::$rsPrefix" ref="b7fa84114614d87a4246121670ad6c4d" args="" --> </td><td class="memItemRight" valign="bottom"><a class="el" href="classADODB__ODBC__DB2.html#b7fa84114614d87a4246121670ad6c4d">$rsPrefix</a> = 'ADORecordset_odbc_'</td></tr> </table> <hr><a name="_details"></a><h2>Detailed Description</h2> <p> <p> Definition at line <a class="el" href="adodb-odbc__db2_8inc_8php-source.html#l00098">98</a> of file <a class="el" href="adodb-odbc__db2_8inc_8php-source.html">adodb-odbc_db2.inc.php</a>.<hr><h2>Member Function Documentation</h2> <a class="anchor" name="62b05fbf8dcd26939566cafa488b4f05"></a><!-- doxytag: member="ADODB_ODBC_DB2::MetaIndexes" ref="62b05fbf8dcd26939566cafa488b4f05" args="($table, $primary=FALSE, $owner=false)" --><p> <table class="mdTable" cellpadding="2" cellspacing="0"> <tr> <td class="mdRow"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td class="md" nowrap valign="top">& ADODB_ODBC_DB2::MetaIndexes </td> <td class="md" valign="top">( </td> <td class="md" nowrap valign="top">$ </td> <td class="mdname" nowrap> <em>table</em>, </td> </tr> <tr> <td class="md" nowrap align="right"></td> <td class="md"></td> <td class="md" nowrap>$ </td> <td class="mdname" nowrap> <em>primary</em> = <code>FALSE</code>, </td> </tr> <tr> <td class="md" nowrap align="right"></td> <td class="md"></td> <td class="md" nowrap>$ </td> <td class="mdname" nowrap> <em>owner</em> = <code>false</code></td> </tr> <tr> <td class="md"></td> <td class="md">) </td> <td class="md" colspan="2"></td> </tr> </table> </td> </tr> </table> <table cellspacing="5" cellpadding="0" border="0"> <tr> <td> </td> <td> <p> List indexes on a table as an array. <dl compact><dt><b>Parameters:</b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign="top"></td><td valign="top"><em>table</em> </td><td>table name to query </td></tr> <tr><td valign="top"></td><td valign="top"><em>primary</em> </td><td>true to only show primary keys. Not actually used for most databases</td></tr> </table> </dl> <dl compact><dt><b>Returns:</b></dt><dd>array of indexes on current table. Each element represents an index, and is itself an associative array.</dd></dl> Array ( [name_of_index] => Array ( [unique] => true or false [columns] => Array ( [0] => firstname [1] => lastname ) ) <p> Reimplemented from <a class="el" href="classADOConnection.html#c80167593d259dab94f07fda1e079edf">ADOConnection</a>. <p> Definition at line <a class="el" href="adodb-odbc__db2_8inc_8php-source.html#l00187">187</a> of file <a class="el" href="adodb-odbc__db2_8inc_8php-source.html">adodb-odbc_db2.inc.php</a>. </td> </tr> </table> <a class="anchor" name="5f6c45540c1e5fd90b25b22996c4ba70"></a><!-- doxytag: member="ADODB_ODBC_DB2::ServerInfo" ref="5f6c45540c1e5fd90b25b22996c4ba70" args="()" --><p> <table class="mdTable" cellpadding="2" cellspacing="0"> <tr> <td class="mdRow"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td class="md" nowrap valign="top">ADODB_ODBC_DB2::ServerInfo </td> <td class="md" valign="top">( </td> <td class="mdname1" valign="top" nowrap> </td> <td class="md" valign="top"> ) </td> <td class="md" nowrap></td> </tr> </table> </td> </tr> </table> <table cellspacing="5" cellpadding="0" border="0"> <tr> <td> </td> <td> <p> Get server version info...<p> <dl compact><dt><b>Returns:</b></dt><dd>An array with 2 elements: $arr['string'] is the description string, and $arr[version] is the version (also a string). </dd></dl> <p> Reimplemented from <a class="el" href="classADODB__odbc.html#3539c35663279e7493609d96c941933a">ADODB_odbc</a>. <p> Definition at line <a class="el" href="adodb-odbc__db2_8inc_8php-source.html#l00124">124</a> of file <a class="el" href="adodb-odbc__db2_8inc_8php-source.html">adodb-odbc_db2.inc.php</a>. <p> References <a class="el" href="adodb_8inc_8php-source.html#l01267">ADOConnection::GetOne()</a>. </td> </tr> </table> <hr>The documentation for this class was generated from the following file:<ul> <li>typo3_src-4.0.1/typo3/sysext/adodb/adodb/drivers/<a class="el" href="adodb-odbc__db2_8inc_8php-source.html">adodb-odbc_db2.inc.php</a></ul> <?php include_once '../doc-typo3-funcs.php'; get_footer(); ?>