Chapter 2: Interfacing SQL to a Procedural Language
In This Chapter
Interfacing procedural language programs with Microsoft Access
Giving Microsoft SQL Server a shot
Doing the same with MySQL
Oracle 11g’s turn
Ending with IBM DB2
You can’t build a user-friendly database application with SQL alone. SQL is a data sublanguage and as such lacks many of the facilities required to build a user interface or even execute a sequence of steps. Building a moderately sophisticated application that uses the data in a database requires a procedural language in addition to SQL. Most database management systems (DBMSs) offer compatibility with several procedural languages. Which ones in particular are offered depends on the source of the DBMS and its history, as well as considerations of what capabilities users are most likely to need. In this chapter, I discuss the most common ways of connecting and interfacing to the most popular DBMS products: Access, SQL Server, MySQL, Oracle 10g, and IBM DB2. ...