SQL/MX Programming Manual for C and COBOL (G06.24+, H06.03+)

C Sample Programs
HP NonStop SQL/MX Programming Manual for C and COBOL—523627-004
A-18
Using a Dynamic SQL Cursor With Descriptor Area
Example A-7. Using a Dynamic SQL Cursor With Descriptor Areas (page 1 of 8)
/*Description: Using a Dynamic Cursor With Desc Areas
Statements: ALLOCATE DESCRIPTOR
PREPARE
DESCRIBE OUTPUT
Dynamic DECLARE CURSOR
OPEN
FETCH USING DESCRIPTOR
GET DESCRIPTOR
CLOSE
DEALLOCATE PREPARE
DEALLOCATE DESCRIPTOR
WHENEVER
GET DIAGNOSTICS
------------------------------------------------------------ */
#include <stdio.h>
#include <string.h>
#include <math.h>
EXEC SQL MODULE SQL12.mysch.t2002s1 NAMES ARE ISO88591;
void run_dynTest(char *chstr);
void assign_to_hv();
void sql_error();
EXEC SQL BEGIN DECLARE SECTION;
char SQLSTATE[6];
long SQLCODE;
EXEC SQL END DECLARE SECTION;
int main()
{
char teststr[256];
strcpy(teststr,"select * from testchar");
run_dynTest(teststr);
strcpy(teststr,"select * from testint");
run_dynTest(teststr);
strcpy(teststr,"select * from testnum");
run_dynTest(teststr);
strcpy(teststr,"select * from testpic");
run_dynTest(teststr);
strcpy(teststr,"select cdate, ctime,ctimestamp from
testdatetime;");
run_dynTest(teststr);
strcpy(teststr,"select cintervalYM, cintervaldhms from
testinterval;");
run_dynTest(teststr);
}