Part IV. Programming with SQL

SQL can be used in two ways: interactively and preprogrammed. Preprogrammed SQL is used primarily in programs developed for end users who do not have to learn SQL statements but who work with easy-to-use menus and screens instead.

Previous chapters have assumed interactive use of the language. Interactive means that statements are processed as soon as they are entered, whereas, with preprogrammed SQL, statements are included in a program that has been written in another programming language. Most products support, among others, the languages C, C++, Java, Visual Basic, PHP, Perl, and COBOL. These languages are known as host languages. When using preprogrammed SQL, the results of the SQL statements are not immediately ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.