| #include <stdlib.h> |
| #include <stdio.h> |
| |
| /*----------------------------------------------------------------*/ |
| EXEC SQL INCLUDE SQLCA; |
| short sqlcode; |
| |
| EXEC SQL BEGIN DECLARE SECTION; |
| int host_a; |
| double host_b; |
| char host_c; |
| EXEC SQL END DECLARE SECTION; |
| |
| EXEC SQL DECLARE csr1 CURSOR FOR |
| SELECT a, b, c |
| FROM table1 |
| WHERE x = :hostvar1; |
| |
| /*----------------------------------------------------------------*/ |
| void main(void) |
| { |
| hostvar1 = 42; |
| |
| EXEC SQL OPEN csr1; |
| if (sqlcode < 0) |
| { |
| exit(0); |
| } |
| |
| while (rc >= 0 && rc != 100) |
| { |
| EXEC SQL FETCH csr1 INTO :host_a, :host_b, :host_c; |
| printf("Fetch %d, %lf, %s\n", host_a, host_b, host_c); |
| } |
| |
| EXEC SQL CLOSE csr1; |
| } |
| |
| void foo(void) |
| { |
| strcpy(demoquery1, "some SQL statement"); |
| EXEC SQL prepare demo3id from :demoquery1; |
| /* a comment */ |
| EXEC SQL declare demo3cursor cursor for demo3id; |
| } |