Chapter 28. Introduction to ODBC

Introduction

A disadvantage of embedded SQL is that only the programming languages for which a precompiler has been developed can be used. Without one, embedded SQL does not work. Usually precompilers are developed by the vendor of the SQL product. However, it is impossible for a vendor to develop a precompiler for every programming language and each development environment—there are just too many of them. This was one of the reasons another approach was considered for processing SQL statements, one that is less dependent on a host language.

The method found was based on the Call-Level Interface (CLI). A CLI is an application programming interface (API), which is a set of functions or routines with clearly defined ...

Get Introduction to SQL: Mastering the Relational Database Language, Fourth Edition/20th Anniversary Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.