📄 otl3_stream_class.htm
字号:
statement and big buffers, which would be are a drag of the system
resources,
and would need to be deallocated as soon as the use of the stream is
finished. </p>
<p>For more detail, see examples <a href="otl3_ex113.htm">113</a>, <a
href="otl3_ex114.htm">114</a>, <a href="otl3_ex115.htm">115</a>.</p>
</ul>
<pre>#ifdef OTL_STREAM_POOLING_ON<br> <i>(2)</i> void close(const bool save_in_stream_pool=true);<br>#endif</pre>
<ul>
<li><a name="good"></a>Test if the stream is open. This function has
the same meaning as
the
good()
function in C++ streams.</li>
</ul>
<pre> int good(void);</pre>
<ul>
<li> <a name="describe_select"></a>Describe the output column list
in:</li>
</ul>
<ul>
<ul>
<li>straight SELECT statement (OCIx, ODBC, and DB2-CLI)</li>
<li>Referenced cursor (OCIx)</li>
<li>Result set returned via a stored procedure call (ODBC for MS
SQL Server
and Sybase, DB2-CLI for DB2)</li>
</ul>
This function returns a pointer of the <a href="#otl_column_desc">otl_column_desc</a>
type to the descriptor of the output column list:
</ul>
<pre> <a name="otl_column_desc"></a>class otl_column_desc{<br> public:<br> char* name; // column name<br> int dbtype; // database dependent, column datatype code.<br> // for more detail, see the OCIx and the ODBC manuals.<br> int otl_var_dbtype; // OTL defined, column datatype code<br> int dbsize; // column length<br> int scale; // for numeric columns, column scale<br> int prec; // for numeric columns, column precision<br> int nullok; // indicator whether column is nullable or not<br><br>--<a
name="charset_form"></a> under <a href="otl3_compile.htm#OTL_UNICODE">OTL_UNICODE</a> and <a
href="otl3_compile.htm#OTLORA9I">OTL_ORA9I</a> / <a
href="otl3_compile.htm#OTL_ORA10G">OTL_ORA10G</a><br><br> int charset_form; <br> // SQLCS_IMPLICIT (1) for on-byte character sets, <br> // SQLCS_NCHAR (2) for NLS multi-byte character sets<br> // 0 otherwise.<br> int char_size; // column size in characters, not in bytes <br> // this column size is set to 0 for <a
href="otl3_compile.htm#OTL_ORA8I">OTL_ORA8I</a>,<br> // because the corresponding attribute<br> // is not available in OCI8i<br><br> };</pre>
<ul>
<a name="otl_var_dbtype"></a><font size="-1">OTL 4.0 defines the
following
datatypes which the OTL maps the native database datatypes to:<br>
<br>
</font>
</ul>
<table style="text-align: left; width: 100%;" border="1" cellpadding="2"
cellspacing="2">
<tbody>
<tr>
<td style="vertical-align: top;"><span
style="font-weight: bold; font-style: italic;">OTL defined integer
constant</span><br>
</td>
<td style="vertical-align: top;"><span
style="font-weight: bold; font-style: italic;">Integer code</span><br>
</td>
<td style="vertical-align: top;"><span
style="font-weight: bold; font-style: italic;">Explanation</span><br>
</td>
</tr>
<tr>
<td style="vertical-align: top;"><font size="-1"><b>otl_var_bigint </b></font></td>
<td style="vertical-align: top;">20<br>
</td>
<td style="vertical-align: top;">MS SQL
Server, DB2, MySQL, PostgreSQL, etc. BIGINT (signed 64-bit integer) type<font
size="-1"><br>
</font></td>
</tr>
<tr>
<td style="vertical-align: top;"><font size="-1"><b>otl_var_blob</b></font></td>
<td style="vertical-align: top;">12<br>
</td>
<td style="vertical-align: top;"><font size="-1">datatype that is
mapped
into BLOB
in Oracle 8<br>
</font></td>
</tr>
<tr>
<td style="vertical-align: top;"><font size="-1"><b>otl_var_char</b></font></td>
<td style="vertical-align: top;">1<br>
</td>
<td style="vertical-align: top;"><font size="-1">null terminated
string<br>
</font></td>
</tr>
<tr>
<td style="vertical-align: top;"><font size="-1"><b>otl_var_clob </b></font></td>
<td style="vertical-align: top;">11<br>
</td>
<td style="vertical-align: top;"><font size="-1">datatype that is
mapped
into CLOB
in Oracle 8 <br>
</font></td>
</tr>
<tr>
<td style="vertical-align: top;"><font size="-1"><b>otl_var_db2date </b></font></td>
<td style="vertical-align: top;">17<br>
</td>
<td style="vertical-align: top;">DB2 DATE type<font size="-1"> <br>
</font></td>
</tr>
<tr>
<td style="vertical-align: top;"><font size="-1"><b>otl_var_db2time</b></font></td>
<td style="vertical-align: top;">16<br>
</td>
<td style="vertical-align: top;">DB2 TIME type<font size="-1"><br>
</font></td>
</tr>
<tr>
<td style="vertical-align: top;"> <a name="otl_var_double"></a><font
size="-1"><b>otl_var_double</b></font></td>
<td style="vertical-align: top;">2<br>
</td>
<td style="vertical-align: top;"><font size="-1">8-byte
floating point number<br>
</font></td>
</tr>
<tr>
<td style="vertical-align: top;"><font size="-1"><b>otl_var_float</b></font></td>
<td style="vertical-align: top;">3<br>
</td>
<td style="vertical-align: top;"><font size="-1">4-byte floating
point
number<br>
</font></td>
</tr>
<tr>
<td style="vertical-align: top;"><font size="-1"><b>otl_var_int</b></font></td>
<td style="vertical-align: top;">4<br>
</td>
<td style="vertical-align: top;">signed <font size="-1">32-bit
integer<br>
</font></td>
</tr>
<tr>
<td style="vertical-align: top;"><font size="-1"><b>otl_var_long_int</b></font></td>
<td style="vertical-align: top;">7<br>
</td>
<td style="vertical-align: top;"><font size="-1">signed
32-bit integer (for 32-bit, and LLP64 C++ compilers), signed 64-bit
integer (for LP-64 C++ compilers)<br>
</font></td>
</tr>
<tr>
<td style="vertical-align: top;"><font size="-1"><b>otl_var_ltz_timestamp </b></font></td>
<td style="vertical-align: top;">19<br>
</td>
<td style="vertical-align: top;">Oracle
9i/10g TIMESTAMP WITH LOCAL TIME ZONE type<font size="-1"><br>
</font></td>
</tr>
<tr>
<td style="vertical-align: top;"><span style="font-weight: bold;"><a
name="otl_var_raw"></a>otl_var_raw</span><br>
</td>
<td style="vertical-align: top;">23<br>
</td>
<td style="vertical-align: top;">RAW, BINARY, VARBINARY, BYTEA,
VARCHAR BYTE, CHAR BYTE, etc.<br>
</td>
</tr>
<tr>
<td style="vertical-align: top;"><font size="-1"><b>otl_var_raw_long</b></font></td>
<td style="vertical-align: top;">10<br>
</td>
<td style="vertical-align: top;"><font size="-1">datatype that is
mapped into LONG
RAW in Oracle 7/8, IMAGE in MS SQL Server ad Sybase, BLOB in DB2<br>
</font></td>
</tr>
<tr>
<td style="vertical-align: top;"><font size="-1"><b>otl_var_short</b></font></td>
<td style="vertical-align: top;">6<br>
</td>
<td style="vertical-align: top;">signed <font size="-1">16-bit
integer <br>
</font></td>
</tr>
<tr>
<td style="vertical-align: top;"><font size="-1"><b>otl_var_timestamp</b></font></td>
<td style="vertical-align: top;">8<br>
</td>
<td style="vertical-align: top;"><font size="-1">datatype that is
mapped into
TIMESTAMP_STRUCT, ODBC and DB2-CLI only<br>
</font></td>
</tr>
<tr>
<td style="vertical-align: top;"><font size="-1"><b>otl_var_tz_timestamp</b></font></td>
<td style="vertical-align: top;">18<br>
</td>
<td style="vertical-align: top;">Oracle
9i/10g TIMESTAMP WITH TIME ZONE type<font size="-1"><br>
</font></td>
</tr>
<tr>
<td style="vertical-align: top;"><font size="-1"><b>otl_var_unsigned_int</b></font></td>
<td style="vertical-align: top;">5<br>
</td>
<td style="vertical-align: top;"><font size="-1">unsigned </font><font
size="-1">32-bit
integer<br>
</font></td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -