| 1 |
#include <stdlib.h> |
| 2 |
#include <string.h> |
| 3 |
|
| 4 |
exec sql include ../regression; |
| 5 |
|
| 6 |
exec sql whenever sqlerror stop; |
| 7 |
|
| 8 |
exec sql type c is char reference; |
| 9 |
typedef char* c; |
| 10 |
|
| 11 |
exec sql type ind is union { int integer; short smallint; }; |
| 12 |
typedef union { int integer; short smallint; } ind; |
| 13 |
|
| 14 |
#define BUFFERSIZ 8 |
| 15 |
exec sql type str is varchar[BUFFERSIZ]; |
| 16 |
|
| 17 |
exec sql declare cur cursor for |
| 18 |
select name, born, age, married, children from family; |
| 19 |
|
| 20 |
int |
| 21 |
main (void) |
| 22 |
{ |
| 23 |
exec sql struct birthinfo { long born; short age; }; |
| 24 |
exec sql begin declare section; |
| 25 |
struct personal_struct { str name; |
| 26 |
struct birthinfo birth; |
| 27 |
} personal, *p; |
| 28 |
struct personal_indicator { int ind_name; |
| 29 |
struct birthinfo ind_birth; |
| 30 |
} ind_personal, *i; |
| 31 |
ind ind_children; |
| 32 |
struct t1 { str name; }; struct t2 { str name; }; |
| 33 |
static varchar vc1[50], vc2[50], vc3[255]; |
| 34 |
static int i1, i2, i3; |
| 35 |
exec sql end declare section; |
| 36 |
|
| 37 |
exec sql char *married = NULL; |
| 38 |
exec sql long ind_married; |
| 39 |
exec sql ind children; |
| 40 |
int loopcount; |
| 41 |
char msg[128]; |
| 42 |
|
| 43 |
ECPGdebug(1, stderr); |
| 44 |
|
| 45 |
strcpy(msg, "connect"); |
| 46 |
exec sql connect to REGRESSDB1; |
| 47 |
|
| 48 |
strcpy(msg, "set"); |
| 49 |
exec sql set datestyle to iso; |
| 50 |
|
| 51 |
strcpy(msg, "create"); |
| 52 |
exec sql create table family(name char(8), born integer, age smallint, married date, children integer); |
| 53 |
|
| 54 |
strcpy(msg, "insert"); |
| 55 |
exec sql insert into family(name, married, children) values ('Mum', '19870714', 3); |
| 56 |
exec sql insert into family(name, born, married, children) values ('Dad', '19610721', '19870714', 3); |
| 57 |
exec sql insert into family(name, age) values ('Child 1', 16); |
| 58 |
exec sql insert into family(name, age) values ('Child 2', 14); |
| 59 |
exec sql insert into family(name, age) values ('Child 3', 9); |
| 60 |
|
| 61 |
strcpy(msg, "commit"); |
| 62 |
exec sql commit; |
| 63 |
|
| 64 |
strcpy(msg, "open"); |
| 65 |
exec sql open cur; |
| 66 |
|
| 67 |
exec sql whenever not found do break; |
| 68 |
|
| 69 |
p=&personal; |
| 70 |
i=&ind_personal; |
| 71 |
memset(i, 0, sizeof(ind_personal)); |
| 72 |
for (loopcount = 0; loopcount < 100; loopcount++) { |
| 73 |
strcpy(msg, "fetch"); |
| 74 |
exec sql fetch cur into :p:i, :married:ind_married, :children.integer:ind_children.smallint; |
| 75 |
printf("%8.8s", personal.name.arr); |
| 76 |
if (i->ind_birth.born >= 0) |
| 77 |
printf(", born %ld", personal.birth.born); |
| 78 |
if (i->ind_birth.age >= 0) |
| 79 |
printf(", age = %d", personal.birth.age); |
| 80 |
if (ind_married >= 0) |
| 81 |
printf(", married %s", married); |
| 82 |
if (ind_children.smallint >= 0) |
| 83 |
printf(", children = %d", children.integer); |
| 84 |
putchar('\n'); |
| 85 |
|
| 86 |
free(married); |
| 87 |
married = NULL; |
| 88 |
} |
| 89 |
|
| 90 |
strcpy(msg, "close"); |
| 91 |
exec sql close cur; |
| 92 |
|
| 93 |
strcpy(msg, "drop"); |
| 94 |
exec sql drop table family; |
| 95 |
|
| 96 |
strcpy(msg, "commit"); |
| 97 |
exec sql commit; |
| 98 |
|
| 99 |
strcpy(msg, "disconnect"); |
| 100 |
exec sql disconnect; |
| 101 |
|
| 102 |
/* this just to silence unused-variable warnings: */ |
| 103 |
vc1.len = vc2.len = vc3.len = 0; |
| 104 |
i1 = i2 = i3 = 0; |
| 105 |
printf("%d %d %d %d %d %d\n", |
| 106 |
vc1.len, vc2.len, vc3.len, |
| 107 |
i1, i2, i3); |
| 108 |
|
| 109 |
return 0; |
| 110 |
} |