This example shows the use of the DECLARE STATEMENT statement in a C program.
EXEC SQL INCLUDE SQLDA; void main () { EXEC SQL BEGIN DECLARE SECTION ; char src_stmt[32000]; char sqlda[32000] EXEC SQL END DECLARE SECTION ; EXEC SQL INCLUDE SQLCA ; strcpy(src_stmt,"SELECT DEPTNO, DEPTNAME, MGRNO \ FROM DEPARTMENT \ WHERE ADMRDEPT = 'A00'"); EXEC SQL DECLARE OBJ_STMT STATEMENT; (Allocate storage from SQLDA) EXEC SQL DECLARE C1 CURSOR FOR OBJ_STMT; EXEC SQL PREPARE OBJ_STMT FROM :src_stmt; EXEC SQL DESCRIBE OBJ_STMT INTO :sqlda; (Examine SQLDA) (Set SQLDATA pointer addresses) EXEC SQL OPEN C1; while (strncmp(SQLSTATE, "00000", 5) ) { EXEC SQL FETCH C1 USING DESCRIPTOR :sqlda; (Print results) } EXEC SQL CLOSE C1; return; }
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.