Definition in file SQLDBC_C.h.
Go to the source code of this file.
|
The version string for the SQLDBC.H file.
Definition at line 58 of file SQLDBC_C.h. |
|
Definition at line 76 of file SQLDBC_C.h. |
|
If this macro is set the functions setTraceOption and getTraceOption from SQLDBCs debug trace facility are available. Set SQLDBC_FEATURE_TRACEOPTION_OFF to disable the trace functionality.
Definition at line 46 of file SQLDBC_C.h. |
|
|
|
|
|
|
|
Connection to the database kernel. This class combines the functions necesary for managing a connection to the database. If a new connection object is created, it is not connected. The connection to the database is established when a successful connect() call was performed.
Definition at line 3397 of file SQLDBC_C.h. |
|
Specification of connection options. Together with the command for opening a database session you can set several options. The following options are possible
Definition at line 3341 of file SQLDBC_C.h. |
|
The SQLDBC_Environment object is the basis for initializing the SQLDBC runtime library and making general settings in the SQLDBC interface.
Definition at line 3924 of file SQLDBC_C.h. |
|
Store for error messages and error codes.
Definition at line 87 of file SQLDBC_C.h. |
|
Definition at line 70 of file SQLDBC_C.h. |
|
Interface to a large object (LONG). This interface is used when it is required to Definition at line 151 of file SQLDBC_C.h. |
|
Can retrieve information to find out the parameter types and their properties in a PreparedStatement object.
Definition at line 313 of file SQLDBC_C.h. |
|
A class for preparing and executing SQL statements. A prepared SQL command can be parsed and contain input and output parameters. Parameters are marked with a '?' or ':<name>' tag. All DML commands can be parsed. DDL commands can be parsed, too. However, it is not recommended to do so. Prepared SQL commands increase the performance since they are parsed only once and executed several times. Applications only need to change the content of the bound parameters and execute the command again. All prepared SQL commands are stored in an internally managed ParseInfo Cache . The ParseInfo Cache shares this information with different prepared SQL statements within the same connection.
The SQL statement may contain ASCII or UCS2 characters and must not zero-terminated. The execute() member function converts it to the adequate code set considering the code of the database. Therefore it is possible to write portable code for UNICODE and non-UNICODE databases.
SQLDBC_PreparedStatement *stmt = conn->createPreparedStatement(); SQLDBC_Retcode rc = stmt->prepare("SELECT * FROM DUAL"); if (rc != SQLDBC_OK) { // Handle error ... } rc = stmt->execute(); if (rc != SQLDBC_OK) { // Handle error ... }
Definition at line 2456 of file SQLDBC_C.h. |
|
A class for presenting a database result set. A database result set is generated by executing an SQL statement that queries the database. Select statements, catalog functions, and some procedures create result sets. For example, the following SQL statement creates a result set containing all the rows and columns of the table DUAL:
A result set can be empty, which is different from there being no result set at all. For example, the following SQL statement creates an empty result set:
An SQLDBC_ResultSet object maintains a cursor pointing to its current row of data. Initially the cursor is positioned before the first row. The next() method moves the cursor to the next row, and as it returns SQLDBC_NO_DATA_FOUND when there are no more rows in the SQLDBC_ResultSet object, it can be used in a WHILE loop to iterate the result set. Example for creating an SQLDBC_ResultSet object:
To reduce the time needed for retrieving the data from the database, the SQLDBC_ResultSet class supports so called block cursors, which can return more than one row at a time. The rows returned by a block cursor are called a 'row set'. The result set is fixed, the rowset is not. It changes position and contents each time a new set of rows is retrieved from the database. With block cursors, the method setRowSetSize() must be used with a parameter greater than 1. Navigation within the data represented by the SQLDBC_ResultSet object is possible using of navigation methods like first(), next(), previous(), relative() etc. When block cursors are used, after applying the navigation methods, the cursor points to the actual row set. For example assuming a result set size of 50 and a rowset size of 10, in the following sequence the block cursor points to the rows indicated:
In order to perform operations that operate on a single row only when multiple rows have been fetched, the application must indicate which row is the current row. When a block cursor first returns a row set, the current row is the first row of that row set. To change the current row, the application must call the member function setPos(). The data of a certain column in the current row can be retrieved by calling the method getObject(). Data fetched from the database is passed on to the application in variables that the application has allocated for this purpose. Before fetching the data from the database, the application bind these variables to the columns of the result set. Applications can bind any number of columns of the result set, including binding no columns at all. Binding of columns is done by calling to the member function bindColumn(). The column binding valid for all rows. After positioning the cursor through navigation methods, the data from the database is written into the bound column variables by a call to the member function fetch() of the row set of this result set. When block cursors are used, the number of rows actually filled can be determined with the member function getResultCount(). For unbounded columns, data can be written into application variables with getObject(), or - in case of block cursors - by calling setPos() on the rowset and then calling getObject(). Definition at line 1299 of file SQLDBC_C.h. |
|
A SQLDBC_ResultSetMetaData class can retrieve information used to find out types and properties of the columns in a ResultSet.
Definition at line 521 of file SQLDBC_C.h. |
|
An SQLDBC_RowSet class for representing a SQLDBC row set. A SQLDBC row set is a window on a result set. The size of the row set is determined by the setRowSetSize() method of the SQLDBC_ResultSet object. The method fetch retrieves the rows from the SQLDBC_RowSet object into the bound columns. The getObject() method retrieves one column from the current row into the given buffer. The setPos() method moves the cursor within the row set. Definition at line 701 of file SQLDBC_C.h. |
|
A class for handling SQL warnings. An SQL warning is a state after an execution of an SQL statement or a function call that is not critical but, as it may cause problems or be an user error. Such an SQL warning may originate from the database, or from the SQLDBC interface. Definition at line 125 of file SQLDBC_C.h. |
|
Definition at line 80 of file SQLDBC_C.h. |
|
|
|
|
|
|
|
A SQLDBC_UpdatableRowSet class for representing a SQLDBC updatable row set. A SQLDBC updatable row set offers update, insert and delete operations on the underlying result set. The insertAllRows() and insertOneRow() methods allow inserting either a whole row set or a single row (the first one) of the row set into the parent result set. The method updateRow() updates an arbitrary row of the result set while the method deleteRow() deletes a single row on a given position. Definition at line 940 of file SQLDBC_C.h. |
|
Definition at line 524 of file SQLDBC_C.h. |
|
Definition at line 341 of file SQLDBC_C.h. |
|
Definition at line 317 of file SQLDBC_C.h. |
|
Definition at line 2237 of file SQLDBC_C.h. |
|
Definition at line 2259 of file SQLDBC_C.h. |
|
Definition at line 2195 of file SQLDBC_C.h. |
|
Returns a pointer to the client runtime instance. Two consecutive calls will return the same pointer, as there is only one instance.
|
|
Returns a pointer to the single-threaded client runtime instance. Two consecutive calls will return the same pointer, as there is only one instance.
|
|
Returns the version of the used SQLDBC API. It corresponds to the version indicated in the used SQLDBC header.
|
|
Cancels the running database request that is executed on the connection. For cancellation of a running SQL command it is neccessary to call the cancel method asynchronously. Because of the asynchronous processing it is not guaranteed that the cancellation will be succeed. The returncode of the original function indicates whether the function completed or was cancelled. In case of cancelation the original function returns with the sql code -102 'SQL statement cancelled'. The the cancel methode returns with SQLDBC_OK if it has been send the cancel request to the database.
|
|
Deletes the error has been stored.
|
|
Deletes the warning stored in the SQLWarning object.
|
|
Closes the SQLDBC_Connection. Releases the database and interface runtime resources immediately instead of waiting for them to be released by the destructor. The current transaction is rolled back.
After you called this method, you are able to connect again using one of the
|
|
Commits all changes to the database session. All changes made since the previous COMMIT/ROLLBACK statement are stored, any database locks held by this SQLDBC_Connection object are released.
|
|
Closes the SQLDBC_Connection. Releases the database and interface runtime resources immediately instead of waiting for them to be released by the destructor. The current transaction is committed.
connect methods. |
|
Opens a new database session using the SQLDBC_ConnectProperties object. For the connection options not specified, the following default values are used:
|
|
Opens a new database session using the SQLDBC_ConnectProperties object. This method interprets all character arguments as zero-terminated ASCII strings.
|
|
Opens a new database session using the SQLDBC_ConnectProperties object. This method interpres all character arguments as zero-terminated ASCII strings. User name and password must be in userpwdEncoding code.
|
|
Opens a new database session using the runtime abstraction interface. This method attaches the connection object an existing session. It is recommended that you implement the virtual method getSession and releaseSession in the Runtime Abstraction Interface.
|
|
Creates an SQLDBC_PreparedStatement object for sending SQL statements to the database. An SQLDBC_PreparedStatement object is 'prepared' in the database server and can use binding variables for input/output parameters.
|
|
Creates an SQLDBC_Statement object for sending SQL statements to the database. SQL statements without parameters are normally executed using SQLDBC_Statement objects. Applications executing SQL statements several times or binding parameters for input and/or output must use SQLDBC_PreparedStatement objects.
|
|
Closes the SQLDBC_Connection. Releases the database and interface runtime resources immediately instead of waiting for them to be released by the destructor. No SQL command that handles the current transaction is sent to the database, so the transaction may be implicitely rolled back by the database server.
After you called this method, you are able to connect again using one of the
|
|
Returns whether the connection is in AUTCOMMIT mode.
|
|
Returns the currently active date/time format.
|
|
Returns a reference to the ErrorHndl object.
|
|
Returns the kernel version. It will be returned in the following format: <major_release><minor_releaser><correction_level>
|
|
Returns the transaction isolation level.
|
|
Returns a reference to an SQLWarning object stored in the SQLDBC_ConnectionItem object.
|
|
Returns whether if the connection to the database was established.
|
|
Returns whether the database is an unicode database or not.
|
|
Releases an SQLDBC_PreparedStatement.
|
|
Releases an SQLDBC_Statement.
|
|
Undoes all changes made in the current transaction and releases any database locks held by this connection object.
|
|
Sets the AUTOCOMMIT mode for the connection.
|
|
Sets the SQL mode.
|
|
Sets the transaction isolation level.
|
|
Deletes the SQLDBC_ConnectProperties handle.
|
|
Retrieves an option.
|
|
Creates an empty set of options. A default allocator is used.
|
|
Sets an option.
|
|
Creates a new SQLDBC_Connection object.
|
|
The destructor.
|
|
Returns the version of used SQLDBC runtime. This is the version of the used SQLDBC library. The version of the loaded runtime may differ from the version inidacted in the used header. It is our aim that newer versions of the runtime will run with old applications without the need to be re-compiling.
|
|
Retrieves the current tracing options.
|
|
Creates a new SQLDBC_Environment, using the provided interface to the runtime environment.
|
|
Closes a SQLDBC_Connection.
|
|
Sets tracing options. Take care that the trace options may be set process-wide, not only for the this environment instance. Also, some options may be ignored if they are not applicable to the current runtime environment (e.g. setting the name of trace output file).
|
|
Returns the error code from the ErrorHndl object.
|
|
Returns the error message stored in the ErrorHndl object.
|
|
Returns the SQL state from the ErrorHndl object.
|
|
Closes the LOB object. No further actions can take place.
|
|
|
|
Retrieves the content of the specified LONG column. The specified LONG column value is converted to the given length and to the output parameter buffer pointed to paramAddr. Repeated calls of this method proceed with reading the LONG value, as long as there is data to read available.
|
|
Retrieves the content of the specified LONG column. The specified LONG column value is converted to the given length and to the output parameter buffer pointed to paramAddr. After the operation, the internal position is the start position plus the number of characters that have been read.
|
|
Retrieves the length of this LOB in the database. The length is returned in chars. The LOB must be opened for reading to retrieve this value.
|
|
Get the current read/write position.
|
|
Retrieves the optimal size of data for reading or writing (the maximum size that can be transferred with one call to the database server). An application may use this to optimize the communication, by using buffers that are multiples of the preferred size.
|
|
|
|
Put data into a LONG value that is referenced by this LOB object.
|
|
Returns the number of parameter/columns in the PreparedStatement or ResultSet object.
|
|
Returns the maximum width in characters of the data type of the specified parameter.
|
|
Returns the input/output behaviour of the specified parameter.
|
|
Requests the name of the specified parameter.
|
|
Returns the data type of the specified parameter.
|
|
Returns maximum physical width in bytes of the data type of the specified parameter.
|
|
Returns the number of decimal digits of the data type of the specified parameter. For number types, getPrecision() returns the number of decimal digits. For character types, it returns the maximum length in characters. For binary types, it returns the maximum length in bytes.
|
|
Returns the number of decimal places of the data type of the specified parameter. For none numeric types, the scale is set to zero.
|
|
Returns whether NULL values are allowed for the specified parameter values.
|
|
Binds a user supplied memory buffer to an input and/or output parameter of an SQL statement. A parameter is a '?' or ':<name>' placeholder in an SQL statement. Applications should use SQLDBC_ParameterMetadata to retrieve information about the type and length of the parameters in an SQL statement.
|
|
Binds an input and/or output parameter by address. Binding by adress is useful when the application uses buffers that are allocated as an array of pointers (C function calloc) A parameter is a '?' or ':<name>' placeholder in an SQL statement. Applications should use SQLDBC_ParameterMetadata to retrieve information about the type and length of the parameters in a SQL statement.
|
|
Clears the array of batched statements.
|
|
Deletes the error has been stored.
|
|
Clears the information about parameters.
All information about parameters that have been bound before using either the
|
|
Deletes the warning stored in the SQLWarning object.
|
|
Executes a prepared SQL statement. The SQL statement must be prepared beforehand, and the appropriate binding variables must have been set with the bindParameter() member function.
|
|
Executes the statements previously input via addBatch().
|
|
Returns the size of the row status array.
|
|
Retrieves the cursor name. The cursor name may be set by:
|
|
Returns a reference to the ErrorHndl object.
|
|
Retrieves the key that was inserted by the last insert operation.
|
|
Returns the maximum number of rows allowed in a result set. This value may be set with setMaxRows before the execution of an SQL statement.
|
|
Retrieves and converts the value of the specified output column of the current row to a buffer. The specified column value in the current row of this SQLDBC_PreparedStatement object is converted to the given length and SQLDBC_HostType and written to the output parameter buffer pointed to paramAddr. It can be called multiple times to retrieve character or binary data in parts. For fixed-length datatypes getObject retrieves the same data multiple times. Mixing variable-length datatypes and fixed-length datatypes may produce unexpected results.
|
|
Retrieves and converts the value with an start offset in of the specified output column from a of the current row to a buffer. The specified column value in the current row of this SQLDBC_PreparedStatement object is converted to the given length and SQLDBC_HostType and written to the output parameter buffer pointed to paramAddr. It can be called multiple times to retrieve character or binary data in parts. For fixed-length datatypes getObject retrieves the same data multiple times. Mixing variable-length datatypes and fixed-length datatypes may produce unexpected results.
|
|
Retrieves an SQLDBC_ParameterMetaData object that contains information about the parameters used.
|
|
Get the optimum size for batch execution. Applications that can adjust the size of records delivered at batch execution
|
|
Retrieves a reference to the SQLDBC_ResultSet object.
|
|
Retrieves the type of the result set concurrency. There are two kinds of concurrency:
|
|
Retrieves an SQLDBC_ResultSetMetaData object that contains information about the columns of the SQLDBC_ResultSet object. The SQLDBC_ResultSetMetaData contains information about the columns of the SQLDBC_ResultSet object that will be returned when the SQLDBC_PreparedStatement object is executed. Because an SQLDBC_PreparedStatement object is parsed, it is possible to get information about the ResultSet object that will be returned without having to execute the SQL statement. Consequently, it is possible to use this method with an SQLDBC_PreparedStatement object rather than executing it and then calling the getResultSetMetaData() method on the returned SQLDBC_ResultSet object.
|
|
Returns the type of a result set. If the requested result set type isn't allowed for this SQL statement, the SQLDBC changes it to an allowed one. Check this with getResultSetType() if the execute() member function returns with a warning.
|
|
Returns the number of rows affected by the executed SQL statement. This method returns a non-zero value if more than one row was addressed by the SQL statement. If the return value is lower than zero, more than one rows was addressed but the exact number of addressed rows cannot be determined.
|
|
Returns the row status array. The row status array describes the state of each row. The size of the row status array is increased by each addBatch() function call.
|
|
Retrieves the table name (for SELECT FOR UPDATE commands).
|
|
Returns a reference to an SQLWarning object stored in the SQLDBC_ConnectionItem object.
|
|
Checks if the SQL statement is a query. A statement is a query only if it returns a result set. This can be determined only after execution of the statement object.
|
|
Switches to the input parameter if the application uses data at execute parameters,. After calling this member function, the paramIndex and the paramAddr parameters are set. The paramIndex parameter is used to select the next parameter that is processed. You cannot process parameters that are bound to LONG columns before all parameters that are bound to non-LONG columns have been processed for a row.
|
|
Parses an ASCII/UNICODE coded SQL statement.
|
|
Parses a zero-terminated ASCII coded SQL statement.
|
|
Parses an ASCII/UNICODE coded zero-terminated SQL statement.
|
|
Put data for an input parameter.
|
|
Sets the size of the row array for a batch execute.
|
|
Sets the binding type for parameters. The value of the parameter offset is normally 0, which implies a column-wise binding. If it is set to a value other than 0, a row-wise binding is applied. So, the address offset of the respective next parameter value is computed differently for column-wise and row-wise binding:
|
|
Sets the command info. Sets the command info and a line number (for example name of programm and current line number). This will be send to the database kernel as part of a parse order. If the kernel runs in a special diagnose mode these information will be stored in a system table and can be used to profile your application. The column info and line number will be unset after the next execute of a SQL command at this statement handle.
|
|
Sets the cursor name. Setting the cursorname affects only query and database procedure commands. For DDL-, INSERT-, UPDATE- and DELETE- commands setting the cursorname has no effect.
|
|
Limits the number of rows of an SQLDBC_ResultSet object. The number of rows of the result set is truncated if the result of a query statement is larger than this limit. The default setting is 'unlimited' (0). Setting this limit does not affect an already executed SQL statement.
|
|
Sets the type of the result set concurrency. There are two kinds of concurrency:
The default setting for the concurrency is #CONCUR_READ_ONLY
|
|
Sets the maximum number of be rows that can be fetched at once. Sets the maximum number of rows to be fetched from a result set. Use this to manipulate the number of rows in the order interface. Use a value > 0 to set the maximum number of rows. Use a value <= 0 to reset this limit to the default value. The default value is 'unlimited' (32767). Setting this value does not affect an already executed SQL statement.
|
|
Sets the type of a result set. A result set is only created by a query command. There are three kind of result sets:
The default for the result set type is #SCROLL_INSENSITIVE
|
|
Moves the cursor to the specified row number in this SQLDBC_ResultSet object. If the row number is positive, the cursor moves to this specified row number with respect to the beginning of the result set. The first row is row number 1, the second is row number 2, and so on. If the given row number is negative, the cursor moves to an 'absolute' position with respect to the end of the result set. For example, calling the method absolute(-1) positions the cursor on the last row; calling the method absolute(-2) moves the cursor to the next-to-last row, and so on. An attempt to position the cursor beyond the first or last row in the result set leaves the cursor before the first row or after the last row.
|
|
Binds a user-supplied memory buffer to an SQL column of a result set. Applications must use SQLDBC_ResultSetMetadata to retrieve information about the type and length of the columns of a result set.
|
|
Binds a user-supplied memory buffer to an SQL column of a result set. Applications must use SQLDBC_ResultSetMetadata to retrieve information about the type and length of the columns of a result set.
|
|
Clears the information about columns that have been bound.
All information about columns that have been bound before using
|
|
Deletes the error has been stored.
|
|
Deletes the warning stored in the SQLWarning object.
|
|
Closes this result set. Further operations are not allowed.
|
|
Moves the cursor to the first row in this SQLDBC_ResultSet object.
|
|
Returns a reference to the ErrorHndl object.
|
|
Retrieves and converts the value of the specified column of the current row to a buffer. The specified column value in the current row of this SQLDBC_RowSet object is converted to the given length and SQLDBC_HostType and written to the output parameter buffer pointed to paramAddr. It can be called multiple times to retrieve character or binary data in parts. For fixed-length datatypes getObject retrieves the same data multiple times. Mixing variable-length datatypes and fixed-length datatypes may produce unexpected results. The current row may be set by a positioning command from SQLDBC_ResultSet (current row = 1) or by the setPos method of the SQLDBC_RowSet object.
|
|
Retrieves and converts the value with an start offset in of the specified column from a of the current row to a buffer. The specified column value in the current row of this SQLDBC_RowSet object is converted to the given length and SQLDBC_HostType and written to the output parameter buffer pointed to paramAddr. It can be called multiple times to retrieve character or binary data in parts. For fixed-length datatypes getObject retrieves the same data multiple times. Mixing variable-length datatypes and fixed-length datatypes may produce unexpected results. The current row may be set by a positioning command from SQLDBC_ResultSet (current row = 1) or by the setPos method of the SQLDBC_RowSet object.
|
|
Returns number of rows of the current result set.
|
|
Retrieves an SQLDBC_ResultSetMetaData object that contains information about the columns of this SQLDBC_ResultSet object.
|
|
Returns the current row number. The first row is row number 1, the second row number 2, and so on.
|
|
Retrieves the SQLDBC_RowSet returned by block cursor operations.
|
|
Returns the size of the row array of bounded parameters.
|
|
Retrieves the SQLDBC_Statement object that belongs to the result set.
|
|
Retrieves the SQLDBC_UpdatableRowSet returned by block cursor operations.
|
|
Returns a reference to an SQLWarning object stored in the SQLDBC_ConnectionItem object.
|
|
Returns SQLDBC_TRUE, if the result set is updatable.
|
|
Moves the cursor to the last row in this SQLDBC_ResultSet object.
|
|
Moves the cursor down one row from its current position. A result set cursor is initially positioned before the first row; the first call of the member function next() positions the cursor to the first row set; the second call positions the cursor on the second row set, and so on. An SQLDBC_ResultSet object's warning chain is cleared when the next call is done.
|
|
Moves the cursor to the previous row in this SQLDBC_ResultSet object.
|
|
Moves the cursor by a relative number of rows, either positive or negative. Attempting to move the cursor beyond the first or last row in the result set positions the cursor before or after the first or last row. Calling relative(0) is valid, but does not change the cursor position.
|
|
Sets the desired fetch size.
The fetch size setting is a hint to the runtime, and not a strict setting such as the row set size. If it is 1, the
|
|
Sets the size of the row array of bounded parameters.
|
|
Returns the number of columns in this ResultSet object.
|
|
Returns maximum width in characters of the specified column.
|
|
Requests the name of the specified column.
|
|
Returns the data type of the specified column.
|
|
Returns column's maximum physical width in bytes of the specified columns.
|
|
Returns the maximum number of decimal digits of the specified column. For number types, getPrecision retrieves the number of decimal digits. For character types, it retrieves the maximum length in characters. For binary types, it retrieves the maximum length in bytes.
|
|
Returns the number of decimal places of the data type of the specified column. For non-numeric types, the scale is set to zero.
|
|
Returns whether NULL values are allowed for the specified column values.
|
|
Returns whether a write operation is possible on the specified column.
|
|
Deletes the error has been stored.
|
|
Deletes the warning stored in the SQLWarning object.
|
|
Writes the retrieved data to the bound columns.
|
|
Returns a reference to the ErrorHndl object.
|
|
Retrieves and converts the value of the specified column of the current row to a buffer. The specified column value in the current row of this SQLDBC_RowSet object is converted to the given length and SQLDBC_HostType and written to the output parameter buffer pointed to paramAddr. It can be called multiple times to retrieve character or binary data in parts. For fixed-length datatypes getObject retrieves the same data multiple times. Mixing variable-length datatypes and fixed-length datatypes may produce unexpected results. The current row may be set by a positioning command from SQLDBC_ResultSet (current row = 1) or by the setPos method of the SQLDBC_RowSet object.
|
|
Retrieves and converts the value with an start offset in of the specified column from a of the current row to a buffer. The specified column value in the current row of this SQLDBC_RowSet object is converted to the given length and SQLDBC_HostType and written to the output parameter buffer pointed to paramAddr. It can be called multiple times to retrieve character or binary data in parts. For fixed-length datatypes getObject retrieves the same data multiple times. Mixing variable-length datatypes and fixed-length datatypes may produce unexpected results. The current row may be set by a positioning command from SQLDBC_ResultSet (current row = 1) or by the setPos method of the SQLDBC_RowSet object.
|
|
Returns the number of rows written to the bound parameters.
|
|
Returns the row status array for the last fetch call. The row status array describes the state of each row. The maximum size of the row status array is given by the setRowSetSize(). The row status array is filled during the fetch() call. The return code of the first row matches to the first member of the row status array.
|
|
Returns a reference to an SQLWarning object stored in the SQLDBC_ConnectionItem object.
|
|
Sets the cursor to row pos in the SQLDBC_RowSet.
|
|
Returns the next SQLWarning from the chain.
|
|
Returns the warning code of the SQL warning.
|
|
Adds a statement to the batch. Statements for batched execution must not return result sets.
|
|
Adds a statement to the batch. The must be end with a zero-terminator and in ASCII code.
|
|
Adds a statement to the batch. The must be end with a zero-terminator.
|
|
Clears the array of batched statements.
|
|
Deletes the error has been stored.
|
|
Deletes the warning stored in the SQLWarning object.
|
|
Executes an UNICODE/ASCII coded SQL statement. The SQL statement is executed immediately on sending a DBS request to the database. In case of an error, the SQLDBC_ErrorHndl object (to be queried using error()) of this object is set. If the executed SQL statement is a query, a result set is created. The application can check this using isQuery(), and obtain retrieve the ResultSet using getResultSet().
|
|
Executes an ASCII coded zero-terminated SQL statement. The SQL statement is executed immediately on sending a DBS request to the database. In case of an error, the SQLDBC_ErrorHndl object (to be queried using error()) of this object is set. If the executed SQL statement is a query, a result set is created. The application can check this using isQuery(), and obtain retrieve the resultset using getResultSet().
|
|
Executes the statements previously input via addBatch().
|
|
Executes an UNICODE/ASCII coded zero-terminated SQL statement. The SQL statement is executed immediately on sending a DBS request to the database. In case of an error, the SQLDBC_ErrorHndl object (to be queried using error()) of this object is set. If the executed SQL statement is a query, a result set is created. The application can check this using isQuery(), and obtain retrieve the resultset using getResultSet().
|
|
Returns the size of the row status array.
|
|
Retrieves the cursor name. The cursor name may be set by:
|
|
Returns a reference to the ErrorHndl object.
|
|
Retrieves the key that was inserted by the last insert operation.
|
|
Returns the maximum number of rows allowed in a result set. This value may be set with setMaxRows before the execution of an SQL statement.
|
|
Retrieves a reference to the SQLDBC_ResultSet object.
|
|
Retrieves the type of the result set concurrency. There are two kinds of concurrency:
|
|
Returns the type of a result set. If the requested result set type isn't allowed for this SQL statement, the SQLDBC changes it to an allowed one. Check this with getResultSetType() if the execute() member function returns with a warning.
|
|
Returns the number of rows affected by the executed SQL statement. This method returns a non-zero value if more than one row was addressed by the SQL statement. If the return value is lower than zero, more than one rows was addressed but the exact number of addressed rows cannot be determined.
|
|
Returns the row status array. The row status array describes the state of each row. The size of the row status array is increased by each addBatch() function call.
|
|
Retrieves the table name (for SELECT FOR UPDATE commands).
|
|
Returns a reference to an SQLWarning object stored in the SQLDBC_ConnectionItem object.
|
|
Checks if the SQL statement is a query. A statement is a query only if it returns a result set. This can be determined only after execution of the statement object.
|
|
Sets the command info. Sets the command info and a line number (for example name of programm and current line number). This will be send to the database kernel as part of a parse order. If the kernel runs in a special diagnose mode these information will be stored in a system table and can be used to profile your application. The column info and line number will be unset after the next execute of a SQL command at this statement handle.
|
|
Sets the cursor name. Setting the cursorname affects only query and database procedure commands. For DDL-, INSERT-, UPDATE- and DELETE- commands setting the cursorname has no effect.
|
|
Limits the number of rows of an SQLDBC_ResultSet object. The number of rows of the result set is truncated if the result of a query statement is larger than this limit. The default setting is 'unlimited' (0). Setting this limit does not affect an already executed SQL statement.
|
|
Sets the type of the result set concurrency. There are two kinds of concurrency:
The default setting for the concurrency is #CONCUR_READ_ONLY
|
|
Sets the maximum number of be rows that can be fetched at once. Sets the maximum number of rows to be fetched from a result set. Use this to manipulate the number of rows in the order interface. Use a value > 0 to set the maximum number of rows. Use a value <= 0 to reset this limit to the default value. The default value is 'unlimited' (32767). Setting this value does not affect an already executed SQL statement.
|
|
Sets the type of a result set. A result set is only created by a query command. There are three kind of result sets:
The default for the result set type is #SCROLL_INSENSITIVE
|
|
Deletes the error has been stored.
|
|
Deletes the warning stored in the SQLWarning object.
|
|
Deletes a single row of the row set at a given position.
|
|
Writes the retrieved data to the bound columns.
|
|
Returns a reference to the ErrorHndl object.
|
|
Retrieves and converts the value of the specified column of the current row to a buffer. The specified column value in the current row of this SQLDBC_UpdatableRowSet object is converted to the given length and SQLDBC_HostType and written to the output parameter buffer pointed to paramAddr. It can be called multiple times to retrieve character or binary data in parts. For fixed-length datatypes getObject retrieves the same data multiple times. Mixing variable-length datatypes and fixed-length datatypes may produce unexpected results. The current row may be set by a positioning command from SQLDBC_ResultSet (current row = 1) or by the setPos method of the SQLDBC_UpdatableRowSet object.
|
|
Retrieves and converts the value with an start offset in of the specified column from a of the current row to a buffer. The specified column value in the current row of this SQLDBC_UpdatableRowSet object is converted to the given length and SQLDBC_HostType and written to the output parameter buffer pointed to paramAddr. It can be called multiple times to retrieve character or binary data in parts. For fixed-length datatypes getObject retrieves the same data multiple times. Mixing variable-length datatypes and fixed-length datatypes may produce unexpected results. The current row may be set by a positioning command from SQLDBC_ResultSet (current row = 1) or by the setPos method of the SQLDBC_UpdatableRowSet object.
|
|
Returns the number of rows written to the bound parameters.
|
|
Returns the row status array for the last fetch call. The row status array describes the state of each row. The maximum size of the row status array is given by the setRowSetSize(). The row status array is filled during the fetch() call. The return code of the first row matches to the first member of the row status array.
|
|
Returns a reference to an SQLWarning object stored in the SQLDBC_ConnectionItem object.
|
|
Performs a mass insert of the whole row set into the result set.
|
|
Performs a single insert of the first row of the row set into the result set.
|
|
Sets the cursor to row pos in the SQLDBC_RowSet.
|
|
Updates a single row with the values of the first row of the row set at a given position.
|