Odbc Toolkit - Functions
The following functions are available:
ODBC connection
| database | Create a odbc database connection |
| odbc | Create an ODBC database connection |
| connection | Connection class for a ODBC database connection |
| listDataSources | List available odbc datasources |
| configureODBCDataSource | Open the ODBC Datasource Administrator dialog box in Windows or ODBCManageDat... |
Importing Data
| connection.fetch | Perform SQL query QUERY, and return result |
| connection.sqlinnerjoin | Perform an innerjoin on two tables. |
| connection.sqlouterjoin | runstoredprocedure |
| connection.sqlread | Read data from table TABLENAME |
| connection.select | Perform SQL query QUERY, and return result |
| connection.executeSQLScript | Run statements from a script file |
Exporting Data
| connection.sqlwrite | Insert rows of data into a table. |
Database Operations
| connection.commit | Make permanent changes to the database. |
| connection.execute | Perform SQL query QUERY, that does not return result |
| connection.rollback | Rollback changes to the database. |
| connection.sqlupdate | Update rows of data in database. |
| connection.update | Update columns in database. |
Support Functions
| rowfilter | Create an unconstrained rowfilter object with columns names. |