| 1 |
#include <stdio.h> |
| 2 |
#include <stdlib.h> |
| 3 |
|
| 4 |
exec sql include ../regression; |
| 5 |
|
| 6 |
EXEC SQL WHENEVER sqlerror sqlprint; |
| 7 |
EXEC SQL WHENEVER sqlwarning sqlprint; |
| 8 |
EXEC SQL WHENEVER not found sqlprint; |
| 9 |
|
| 10 |
EXEC SQL TYPE customer IS |
| 11 |
struct |
| 12 |
{ |
| 13 |
varchar name[50]; |
| 14 |
int phone; |
| 15 |
}; |
| 16 |
|
| 17 |
EXEC SQL TYPE cust_ind IS |
| 18 |
struct ind |
| 19 |
{ |
| 20 |
short name_ind; |
| 21 |
short phone_ind; |
| 22 |
}; |
| 23 |
|
| 24 |
int main() |
| 25 |
{ |
| 26 |
EXEC SQL begin declare section; |
| 27 |
customer *custs1 = (customer *) malloc(sizeof(customer) * 10); |
| 28 |
cust_ind *inds = (cust_ind *) malloc(sizeof(cust_ind) * 10); |
| 29 |
typedef struct |
| 30 |
{ |
| 31 |
varchar name[50]; |
| 32 |
int phone; |
| 33 |
} customer2; |
| 34 |
customer2 *custs2 = (customer2 *) malloc(sizeof(customer2) * 10); |
| 35 |
|
| 36 |
struct customer3 |
| 37 |
{ |
| 38 |
char name[50]; |
| 39 |
int phone; |
| 40 |
} *custs3 = (struct customer3 *) malloc(sizeof(struct customer3) * 10); |
| 41 |
|
| 42 |
struct customer4 |
| 43 |
{ |
| 44 |
varchar name[50]; |
| 45 |
int phone; |
| 46 |
} *custs4 = (struct customer4 *) malloc(sizeof(struct customer4)); |
| 47 |
|
| 48 |
int r; |
| 49 |
varchar onlyname[2][50]; |
| 50 |
EXEC SQL end declare section; |
| 51 |
|
| 52 |
ECPGdebug(1, stderr); |
| 53 |
|
| 54 |
EXEC SQL connect to REGRESSDB1; |
| 55 |
|
| 56 |
EXEC SQL create table customers (c varchar(50), p int); |
| 57 |
EXEC SQL insert into customers values ('John Doe', '12345'); |
| 58 |
EXEC SQL insert into customers values ('Jane Doe', '67890'); |
| 59 |
|
| 60 |
EXEC SQL select * INTO :custs1:inds from customers limit 2; |
| 61 |
printf("custs1:\n"); |
| 62 |
for (r = 0; r < 2; r++) |
| 63 |
{ |
| 64 |
printf( "name - %s\n", custs1[r].name.arr ); |
| 65 |
printf( "phone - %d\n", custs1[r].phone ); |
| 66 |
} |
| 67 |
|
| 68 |
EXEC SQL select * INTO :custs2:inds from customers limit 2; |
| 69 |
printf("\ncusts2:\n"); |
| 70 |
for (r = 0; r < 2; r++) |
| 71 |
{ |
| 72 |
printf( "name - %s\n", custs2[r].name.arr ); |
| 73 |
printf( "phone - %d\n", custs2[r].phone ); |
| 74 |
} |
| 75 |
|
| 76 |
EXEC SQL select * INTO :custs3:inds from customers limit 2; |
| 77 |
printf("\ncusts3:\n"); |
| 78 |
for (r = 0; r < 2; r++) |
| 79 |
{ |
| 80 |
printf( "name - %s\n", custs3[r].name ); |
| 81 |
printf( "phone - %d\n", custs3[r].phone ); |
| 82 |
} |
| 83 |
|
| 84 |
EXEC SQL select * INTO :custs4:inds from customers limit 1; |
| 85 |
printf("\ncusts4:\n"); |
| 86 |
printf( "name - %s\n", custs4->name.arr ); |
| 87 |
printf( "phone - %d\n", custs4->phone ); |
| 88 |
|
| 89 |
EXEC SQL select c INTO :onlyname from customers limit 2; |
| 90 |
printf("\nname:\n"); |
| 91 |
for (r = 0; r < 2; r++) |
| 92 |
{ |
| 93 |
printf( "name - %s\n", onlyname[r].arr ); |
| 94 |
} |
| 95 |
|
| 96 |
EXEC SQL disconnect all; |
| 97 |
|
| 98 |
/* All the memory will anyway be freed at the end */ |
| 99 |
return 0; |
| 100 |
} |