Including embedded SQL commands v16
EDB enhanced ECPG (the PostgreSQL precompiler) to create ECPGPlus. ECPGPlus allows you to include Pro*C-compatible embedded SQL commands in C applications when connected to an EDB Postgres Advanced Server database. When you use ECPGPlus to compile an application, the SQL code syntax is checked and translated into C.
ECPGPlus supports:
- Oracle Dynamic SQL – Method 4 (ODS-M4)
- Pro*C-compatible anonymous blocks
- A
CALLstatement compatible with Oracle databases
As part of ECPGPlus's Pro*C compatibility, you don't need to include the BEGIN DECLARE SECTION and END DECLARE SECTION directives.
While most ECPGPlus statements work with community PostgreSQL, the CALL statement and the EXECUTE…END EXEC statement work only when the client application is connected to EDB Postgres Advanced Server.
introduction overview using_embedded_sql using_descriptors building_executing_dynamic_sql_statements error_handling reference conclusion
ECPGPlus overview
Provides an overview of the ECPGPlus precompiler capabilities
Installing and configuring ECPGPlus
Provides an overview of the ECPGPlus precompiler capabilities
Using embedded SQL
Provides examples for making a query and for using a cursor to process a result set
Using descriptors
Describes the process for executing SQL statements that are composed at runtime
Building and executing dynamic SQL statements
Outlines four techniques for building and executing dynamic SQL statements
Error handling
Outlines the methods for detecting and handling errors in embedded SQL code