ECPGPlus Guide

• Introduction
• ECPGPlus - Overview
  • 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 Non-query Statement Without Parameters
  • Example - Executing a Non-query 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
• Reference
  • C-preprocessor Directives
  • Supported C Data Types
  • Type Codes
  • The SQLDA Structure
  • 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
• Conclusion