Chapter 33.ECPG - EmbeddedSQL in C
- Table of Contents
- 33.1.The Concept
- 33.2.Managing Database Connections
- 33.1.The Concept
- 33.2.1.Connecting to the Database Server
- 33.2.2.Choosing a Connection
- 33.2.3.Closing a Connection
- 33.2.2.Choosing a Connection
- 33.2.1.Connecting to the Database Server
- 33.3.Running SQL Commands
- 33.3.1.Executing SQL Statements
- 33.3.2.Using Cursors
- 33.3.3.Managing Transactions
- 33.3.4.Prepared Statements
- 33.3.2.Using Cursors
- 33.3.1.Executing SQL Statements
- 33.4.Using Host Variables
- 33.4.1.Overview
- 33.4.2.Declare Sections
- 33.4.3.Retrieving Query Results
- 33.4.4.Type Mapping
- 33.4.5.Handling Nonprimitive SQL Data Types
- 33.4.6.Indicators
- 33.4.2.Declare Sections
- 33.4.1.Overview
- 33.5.Dynamic SQL
- 33.6.pgtypes Library
- 33.6.1.The numeric Type
- 33.6.2.The date Type
- 33.6.3.The timestamp Type
- 33.6.4.The interval Type
- 33.6.5.The decimal Type
- 33.6.6.errno Values of pgtypeslib
- 33.6.7.Special Constants of pgtypeslib
- 33.6.2.The date Type
- 33.6.1.The numeric Type
- 33.7.Using Descriptor Areas
- 33.7.1.Named SQL Descriptor Areas
- 33.7.2.SQLDA Descriptor Areas
- 33.7.1.Named SQL Descriptor Areas
- 33.8.Error Handling
- 33.8.1.Setting Callbacks
- 33.8.2.sqlca
- 33.8.3.SQLSTATE vs.SQLCODE
- 33.8.2.sqlca
- 33.8.1.Setting Callbacks
- 33.9.Preprocessor Directives
- 33.10.Processing Embedded SQL Programs
- 33.11.Library Functions
- 33.12.Large Objects
- 33.13.C++ Applications
- 33.11.Library Functions
- 33.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
- CONNECT -- establish a database connection
- ALLOCATE DESCRIPTOR -- allocate an SQL descriptor area
- 33.15.Informix Compatibility Mode
- 33.15.1.Additional Types
- 33.15.2.Additional/Missing Embedded SQL Statements
- 33.15.3.Informix-compatible SQLDA Descriptor Areas
- 33.15.4.Additional Functions
- 33.15.5.Additional Constants
- 33.15.2.Additional/Missing Embedded SQL Statements
- 33.15.1.Additional Types
- 33.16.Internals
This chapter describes the embeddedSQL package forPostgreSQL. It was written by Linus Tolke ( This documentation is quite incomplete. But since this interface is standardized, additional information can be found in many resources about SQL.<linus@epact.se>) and Michael Meskes (<meskes@postgresql.org>). Originally it was written to work withC. It also works withC++, but it does not recognize allC++ constructs yet.