Difference between revisions of "Library ODBC Compatible Functions"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 115: | Line 115: | ||
| − | <path>/ | + | <path>/lib/libodbc_recital.so |
Latest revision as of 15:01, 31 March 2009
On Recital supported UNIX and Linux platforms, the following ODBC compatible functions are also available in addition to the standard Recital/Library functions.
| FUNCTION | DESCRIPTION |
|---|---|
| SQLAllocConnect() [1] | Allocate a connection handle. |
| SQLAllocEnv() [2] | Allocate an environment handle. |
| SQLAllocStmt() [3] | Allocate a new statement and associate it with a connection handle. |
| SQLBindCol() [4] | Bind application storage space to columns in a result set. |
| SQLBindParameter() [5] | Bind an application variable to a parameter marker. |
| SQLColAttributes() [6] | Return descriptor information for a column. |
| SQLColumnPrivileges() [7] | Return a list of columns and associated privileges for the specified table. |
| SQLColumns() [8] | Return a list of column names for the specified tables. |
| SQLConnect() [9] | Establish a connection to a database. |
| SQLDataSources() [10] | Return information about a data source. This function is implemented solely by the Driver Manager. |
| SQLDescribeCol() [11] | Return column information. |
| SQLDescribeParam() [12] | Return the description of a parameter marker. |
| SQLDisconnect() [13] | Disconnect a connection from a database. |
| SQLError() [14] | Return information about the most recent error. |
| SQLExecDirect() [15] | Prepare and execute an SQL statement. |
| SQLExecImmediate() | Execute an SQL statement. |
| SQLExecute() [16] | Execute a previously prepared dynamic SQL statement. |
| SQLFetch() [17] | Advance cursor to next row. |
| SQLForeignKeys() [18] | Return a list of foreign keys in the specified table. |
| SQLFreeConnect() [19] | Free connection from a database. |
| SQLFreeEnv() [20] | Free environment handle. |
| SQLFreeStmt() [21] | Close a cursor. |
| SQLGetConnectOption() [22] | Return the current setting of a connection option. |
| SQLGetCursorName() [23] | Associate a cursor name with a statement handle. |
| SQLGetData() [24] | Retrieve data for a single column in the result set. It can be called multiple times to retrieve variable length data in parts. |
| SQLGetInfo() [25] | Return general information about the currently connected DBMS. |
| SQLGetStmtOption() [26] | Set options related to the HSTMT. |
| SQLGetTypeInfo() [27] | Return information about data types supported by the data source. |
| SQLLockTable() | Apply the specified lock to the table. |
| SQLMoreResults() [28] | Determine whether there are more results available on a statement containing SELECT, UPDATE, INSERT, or DELETE statements and, if so, initialize processing for those results. |
| SQLNativeSql() [29] | Return the SQL string as translated by the driver. |
| SQLNumParams() [30] | Return the number of parameter markers. |
| SQLNumResultCols() [31] | Returns the number of columns in a result set. |
| SQLParamData() [32] | Used in conjunction with SQLPutData to supply parameter data at statement execution time. |
| SQLPrepare() [33] | Associate a cursor name with a statement handle. |
| SQLPrimaryKeys() [34] | Return the column names that make up the primary key for a table. |
| SQLProcedureColumns() [35] | Return a list of input and output parameters, as well as the columns that make up the result set for the specified procedures. |
| SQLProcedures() [36] | Return the list of procedure names stored in a specific data source. Procedure is a generic term used to describe an executable object, or a named entity that can be invoked using input and output parameters. |
| SQLPutData() [37] | Allow an application to send data for a parameter or column to the driver at statement execution time. |
| SQLRowCount() [38] | Build a scroll cursor. |
| SQLSavePoint() | Set or roll back a save point on the current transaction. |
| SQLSetConnectOption() [39] | Set connection options. |
| SQLSetCursorName() [40] | Associate a cursor name with a statement handle. |
| SQLSetLocking() | Change the transaction locking type. |
| SQLSetParam() [41] | Bind application storage space to columns in a result set. |
| SQLSetPos() [42] | Set the cursor position. |
| SQLSetStmtOption() [43] | Set SQL statement options. |
| SQLSpecialColumns() [44] | Set up fetch for special column names. |
| SQLStatistics() [45] | Retrieve a list of statistics about a single table and the indexes associated with the table. |
| SQLTablePrivileges() [46] | Return a list of tables and the privileges associated with each table. |
| SQLTables() [47] | Return a list of table names in the specified data source. |
| SQLTransact() [48] | Commit or roll back the current transaction. |
NOTE: To use the ODBC compatible functions, the following shared object library must be loaded or linked into your application:
<path>/lib/libodbc_recital.so
