Table of Contents 1 Introduction 1.1 Typographical Conventions Used in this Guide 2 ECPGPlus - Overview 2.1 Installation and Configuration 2.2 Constructing a Makefile 2.3 ECPGPlus Command Line Options 3 Using Embedded SQL 3.1 Example - A Simple Query 3.1.1 Using Indicator Variables 3.1.2 Declaring Host Variables 3.2 Example - Using a Cursor to Process a Result Set 4 Using Descriptors 4.1 Example - Using a Descriptor to Return Data 5 Building and Executing Dynamic SQL Statements 5.1 Example - Executing a Non-query Statement Without Parameters 5.2 Example - Executing a Non-query Statement with a Specified Number of Placeholders 5.3 Example - Executing a Query With a Known Number of Placeholders 5.4 Example - Executing a Query With an Unknown Number of Variables 6 Error Handling 6.1 Error Handling with sqlca 6.2 EXEC SQL WHENEVER 7 Reference 7.1 C-preprocessor Directives 7.2 Supported C Data Types 7.3 Type Codes 7.4 The SQLDA Structure 7.5 ECPGPlus Statements 7.5.1 ALLOCATE DESCRIPTOR 7.5.2 CALL 7.5.3 CLOSE 7.5.4 COMMIT 7.5.5 CONNECT 7.5.6 DEALLOCATE DESCRIPTOR 7.5.7 DECLARE CURSOR 7.5.8 DECLARE DATABASE 7.5.9 DECLARE STATEMENT 7.5.10 DELETE 7.5.11 DESCRIBE 7.5.12 DESCRIBE DESCRIPTOR 7.5.13 DISCONNECT 7.5.14 EXECUTE 7.5.15 EXECUTE DESCRIPTOR 7.5.16 EXECUTE...END EXEC 7.5.17 EXECUTE IMMEDIATE 7.5.18 FETCH 7.5.19 FETCH DESCRIPTOR 7.5.20 GET DESCRIPTOR 7.5.21 INSERT 7.5.22 OPEN 7.5.23 OPEN DESCRIPTOR 7.5.24 PREPARE 7.5.25 ROLLBACK 7.5.26 SAVEPOINT 7.5.27 SELECT 7.5.28 SET CONNECTION 7.5.29 SET DESCRIPTOR 7.5.30 UPDATE 7.5.31 WHENEVER