ECPGPlus

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 CALL statement 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.

PostgreSQL compatibility

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
  • Behind the scenes
  • Installation and configuration
  • Constructing a makefile
  • ECPGPlus command line options
• Using embedded SQL
  • Example: A simple query
    • Using indicator variables
    • Declaring host variables
  • Example: Using a cursor to process a result set
• Using descriptors
  • Example: Using a descriptor to return data
• Building and executing dynamic SQL statements
  • Example: Executing a nonquery statement without parameters
  • Example: Executing a nonquery statement with a specified number of placeholders
  • Example: Executing a query with a known number of placeholders
  • Example: Executing a query with an unknown number of variables
• Error handling
  • Error handling with sqlca
  • EXEC SQL WHENEVER
  • Example
• Reference
  • C-preprocessor directives
    • Compiling in PROC mode
    • Using the SELECT_ERROR precompiler option
    • Compiling in non-PROC mode
  • Supported C data types
  • Type codes
  • The SQLDA structure
    • Parameters
  • ECPGPlus statements
    • ALLOCATE DESCRIPTOR
    • CALL
    • CLOSE
    • COMMIT
    • CONNECT
    • DEALLOCATE DESCRIPTOR
    • DECLARE CURSOR
    • DECLARE DATABASE
    • DECLARE STATEMENT
    • DELETE
    • DESCRIBE
    • DESCRIBE DESCRIPTOR
    • DISCONNECT
    • EXECUTE
    • EXECUTE DESCRIPTOR
    • EXECUTE…END EXEC
    • EXECUTE IMMEDIATE
    • FETCH
    • FETCH DESCRIPTOR
    • GET DESCRIPTOR
    • INSERT
    • OPEN
    • OPEN DESCRIPTOR
    • PREPARE
    • ROLLBACK
    • SAVEPOINT
    • SELECT
    • SET CONNECTION
    • SET DESCRIPTOR
    • UPDATE
    • WHENEVER