ODBC: Data Sources | Handles | Data Driver | Error Messages | API: Connect Read Update Create Bulk Insert
The Open Database Connectivity (ODBC) interface allows applications to access data from database management systems (DBMS), using Structured Query Language (SQL) expressions. The processing required by the application is essentially independent of the DBMS.
The application and the driver programs that access the DBMS are physically separate. To access a DBMS, you need only ensure a driver for that DBMS is available. There are ODBC drivers for virtually all commercial DBMS. Note that the DBMS need not itself support SQL, for example dBase does not. All that matters is that the ODBC DBMS driver is available. An ODBC DBMS driver, together with information on where its datasets are stored, is typically referred to as a data source.
The J/ODBC interface uses the Data Driver verbs defined in script dd.ijs. The application sends requests to the Data Driver, which converts them into a standard format and sends them to the ODBC Manager. The ODBC Manager then sends them to the appropriate Data Source, and is also responsible for ensuring the required drivers are loaded. The Data Source drivers then handle the data access.
Explore - user documentation, see also the top navigation bar
- Data Sources - data sources
- Handles - connection and statement handles
- Error Messages - error messages
- Connect - connecting to a database
- Read - reading data
- Update - updating data
- Create - creating a table
There are several ODBC labs in the J system.