5DV021 DB Code, Fall 2008

Principles of Database Systems
Fall 2008
Database Programs

Database Programs to Generate the "Company" Database of the Textbook:

Generate in the Leap database system: Leap
Generate in any ODBC-compliant system using C: C/ODBC

Table data include (.h) file for the above program: H/ODBC
Tuple data include (.h) file for the above program: H/ODBC

Example C programs with ODBC calls:

Connect to an ODBC database: C
Connect to an ODBC database with password: C
Execute a simple SQL query: C
Repeatedly execute an SQL query with interactive input parameters: C
Test for a null value in a retrieved tuple: C