Chapter 35. ECPG - Embedded SQL in C
Table of Contents
- 35.1. The Concept
- 35.2. Managing Database Connections
- 35.3. Running SQL Commands
- 35.4. Using Host Variables
- 35.5. Dynamic SQL
- 35.6. pgtypes Library
- 35.7. Using Descriptor Areas
- 35.8. Error Handling
- 35.9. Preprocessor Directives
- 35.10. Processing Embedded SQL Programs
- 35.11. Library Functions
- 35.12. Large Objects
- 35.13. C++ Applications
- 35.14. Embedded SQL Commands
-
- ALLOCATE DESCRIPTOR - allocate an SQL descriptor area
- CONNECT - establish a database connection
- DEALLOCATE DESCRIPTOR - deallocate an SQL descriptor area
- DECLARE - define a cursor
- DESCRIBE - obtain information about a prepared statement or result set
- DISCONNECT - terminate a database connection
- EXECUTE IMMEDIATE - dynamically prepare and execute a statement
- GET DESCRIPTOR - get information from an SQL descriptor area
- OPEN - open a dynamic cursor
- PREPARE - prepare a statement for execution
- SET AUTOCOMMIT - set the autocommit behavior of the current session
- SET CONNECTION - select a database connection
- SET DESCRIPTOR - set information in an SQL descriptor area
- TYPE - define a new data type
- VAR - define a variable
- WHENEVER - specify the action to be taken when an SQL statement causes a specific class condition to be raised
- 35.15. Informix Compatibility Mode
- 35.16. Oracle Compatibility Mode
- 35.17. Internals
This chapter describes the embedded
SQL
package
for
PostgreSQL
. It was written by
Linus Tolke (
<
linus@epact.se
>
) and Michael Meskes
(
<
meskes@postgresql.org
>
). Originally it was written to work with
C
. It also works with
C++
, but
it does not recognize all
C++
constructs yet.
This documentation is quite incomplete. But since this interface is standardized, additional information can be found in many resources about SQL.