📄 enums.html
字号:
Uncommitted'<BR><STRONG>
SA_ReadCommitted =
SA_ANSILevel1, //
</STRONG>isolation level 'Read
Committed'<STRONG><BR>
SA_RepeatableRead = SA_ANSILevel2,
// </STRONG>isolation level 'Repeatable
Read'<STRONG><BR>
SA_Serializable =
SA_ANSILevel3
// </STRONG>isolation level
'Serializable'<STRONG><BR>}
SAIsolationLevel_t;</STRONG></FONT></P>
<hr>
<P><A name=SAAutoCommit_t><STRONG>SAAutoCommit_t</A> enum</STRONG> describes autocommit modes:</P>
<P><FONT face=Arial size=2><STRONG>typedef enum {
<BR>
SA_AutoCommitUnknown = -1, //
</STRONG>Autocommit mode is
unknown<STRONG><BR>
SA_AutoCommitOff,
// </STRONG>Autocommit is
off<STRONG><BR>
SA_AutoCommitOn
// </STRONG>Autocommit is on<STRONG><BR>}
SAAutoCommit_t;</STRONG></FONT></P>
<hr>
<P><A name=SADataType_t><STRONG>SADataType_t</A> enum</STRONG> describes a list of supported
datatypes:</P>
<P><FONT face=Arial size=2><STRONG>typedef enum {
<BR>
SA_dtUnknown,
<BR>
<STRONG>SA_dtBool,</STRONG>
</STRONG>
// data type is C <STRONG>bool</STRONG>
<BR><STRONG>
SA_dtShort,
// </STRONG>data type is C
<STRONG>short</STRONG><STRONG><BR>
SA_dtLong,
// </STRONG>data type is C
<STRONG>long</STRONG><STRONG><BR>
</STRONG><STRONG>
SA_dtDouble,
// </STRONG>data type is C
<STRONG>double</STRONG><BR>
<STRONG>
SA_dtNumeric,
// </STRONG>data type is
<STRONG>SANumeric (used internally)</STRONG><STRONG><BR>
SA_dtDateTime, //
</STRONG> data type
is<STRONG>
SADateTime</STRONG><STRONG><BR>
SA_dtString,
// </STRONG>data type is character string
(<STRONG>SAString</STRONG>)<STRONG><BR>
SA_dtBytes,
// </STRONG>data type is binary string
(<STRONG>SAString</STRONG>)<STRONG><BR>
SA_dtLongBinary, // </STRONG>data type is
long binary data (<STRONG>SAString</STRONG>)
<BR><STRONG>
SA_dtLongChar, //
</STRONG>data type is long character data
(<STRONG>SAString</STRONG>)<STRONG><BR>
SA_dtBLob,
// </STRONG>data type is BLob data
(<STRONG>SAString</STRONG>)<STRONG><BR>
SA_dtCLob,
// </STRONG>data type is CLob data
(<STRONG>SAString</STRONG>)<BR><STRONG>
SA_dtCursor,</STRONG>
// data type is Oracle REF CURSOR
(<STRONG>SACommand</STRONG>)<BR>
<STRONG>SA_dtSpecificToDBMS</STRONG> // data
type is server-specific and not interpreted by
SQLAPI++<BR><STRONG>}
SADataType_t;</STRONG></FONT></P>
<hr>
<P><A name=SACommandType_t><STRONG>SACommandType_t</A> enum</STRONG> describes types of a command:</P>
<P><FONT face=Arial size=2><STRONG>typedef enum {
<BR>
SA_CmdUnknown, //
</STRONG>Command type is not
defined<STRONG><BR>
SA_CmdSQLStmt, //
</STRONG>Command is an SQL
statement<BR><STRONG>
SA_CmdStoredProc // </STRONG>Command
is a stored procedure or a function<STRONG><BR>}
SACommandType_t;</STRONG></FONT></P>
<hr>
<P><A name=SAParamDirType_t><STRONG>SAParamDirType_t</A> enum</STRONG> describes types of a parameter:</P>
<P><FONT face=Arial size=2><STRONG>typedef enum {
<BR>
SA_ParamInput,
// </STRONG>Input
parameter<STRONG><BR>
SA_ParamInputOutput, //
</STRONG>Input/output
parameter<STRONG><BR>
SA_ParamOutput,
// </STRONG>Output
parameter<STRONG><BR>
SA_ParamReturn
// </STRONG>Returning parameter<STRONG><BR>}
SAParamDirType_t;</STRONG></FONT></P>
<hr>
<P><A
name=SALongOrLobReaderModes_t><STRONG>SALongOrLobReaderModes_t</A> enum</STRONG>
describes Long or Lob(CLob) data reading
modes:</P>
<P><FONT face=Arial size=2><STRONG>typedef enum {
<BR>
SA_LongOrLobReaderDefault, //
</STRONG>Long or Lob(CLob) data reading mode is
default<STRONG><BR>
SA_LongOrLobReaderManual //
</STRONG>Long or Lob(CLob) data reading mode is
manual<STRONG><BR>}
SALongOrLobReaderModes_t;</STRONG></FONT></P>
<hr>
<P><A name=SAPieceType_t><STRONG>SAPieceType_t</A> enum</STRONG> describes read piece of Long or Lob(CLob)
data description:</P>
<P><FONT face=Arial size=2><STRONG>typedef enum {
<BR>
SA_FirstPiece = 1, //
</STRONG>The first (but not the last) piece of data
<STRONG><BR>
SA_NextPiece = 2, // </STRONG>The next
(not the first and not the last) piece of data
<STRONG><BR>
SA_LastPiece = 3, // </STRONG>The last
piece of data
<STRONG><BR>
SA_OnePiece = 4 // </STRONG>All
required data is represented as one block<BR><STRONG>}
SAPieceType_t;</STRONG></FONT></P>
<hr>
<P><A
name=saLongOrLobWriter_t><STRONG>saLongOrLobWriter_t</A> typedef
declaration</STRONG> defines Long or Lob writer
callback:</P>
<P><FONT face=Arial
size=2><STRONG>typedef unsigned int
(*saLongOrLobWriter_t)
(<BR>
SAPieceType_t &ePieceType,
<BR>
void *pBuf,
<BR>
unsigned int nLen,
<BR>
void *pAddlData );</STRONG></FONT>
</P>
<P>User defined function has the
following parameters:</P>
<P><EM>ePieceType</EM>. Defines which
piece of data value was written. Can be one of the
<A href="#SAPieceType_t">SAPieceType_t</A> enum
values.</P>
<P><EM>pBuf</EM>. Pointer to the buffer
that contains the data block written to database.</P>
<P><EM>nLen</EM>. The actual size of
data in buffer <EM>pBuf</EM>.</P>
<P><EM>pAddData</EM>. An additional
data user want to pass to the function.</P>
<hr>
<P><A
name=saLongOrLobReader_t><STRONG>saLongOrLobReader_t</A> typedef
declaration</STRONG> defines Long or Lob reader
callback:</P>
<P><FONT face=Arial
size=2><STRONG>typedef unsigned int
(*saLongOrLobReader_t)
(<BR>
SAPieceType_t ePieceType,
<BR>
void *pBuf,
<BR>
unsigned int nLen,
<BR>
unsigned int nBlobSize,
<BR>
void *pAddlData );</STRONG></FONT>
</P>
<P>User defined function has the
following parameters:</P>
<P><EM>ePieceType</EM>. Parameter
passed to the function from SQLAPI++ Library mechanisms.
It defines which piece of data value was read. Can
be one of the <A
href="#SAPieceType_t">SAPieceType_t</A> enum values.</P>
<P><EM>pBuf</EM>. Pointer to the buffer
that contains the data block read from database.</P>
<P><EM>nLen</EM>. The actual size of
data in buffer <EM>pBuf</EM>.</P>
<P><EM>nBlobSize</EM>. A size of whole
Long or BLob(CLob) field (if DBMS server allows to know
it before whole field was read; otherwise 0).</P>
<P><EM>pAddData</EM>. An additional
data user want to pass to the function.</P>
<P> </P></td>
</tr>
</table>
<H3>Problems and Questions</H3>
<P> If
you haven't found the answer to your questions or
have some problems on using the Library, please, send e-mail to <A
href="mailto:howto@sqlapi.com">howto@sqlapi.com</A>.
</P>
</td>
<tr></tr>
</table>
</body></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -