Chapter 34. ECPG(Oracle Pro*c compatible) — LightDB's Embedded SQL in C

ALLOCATE DESCRIPTOR — allocate an SQL descriptor area
COMMIT RELEASE — release current connection after commit
CONNECT — establish a database connection
CONTEXT — context for 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 ... END-EXEC — execute an anonymous block
EXECUTE IMMEDIATE — dynamically prepare and execute a statement
GET DESCRIPTOR — get information from an SQL descriptor area
OPEN — open a dynamic cursor
ORACLE OPTION — set oracle option
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

34.15. Oracle Compatibility Mode

34.15.1. Oracle-compatible string
34.15.2. Oracle-compatible SQLDA Descriptor Area
34.15.3. Additional Functions

34.16. Internals

34.17. Comment

This chapter describes the embedded SQL package for LightDB. 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.

Prev	Up	Next
33.5. Example Program	Home	34.1. The Concept