Debian Codegraph @

src/interfaces/ecpg/test/sql/dynalloc2.pgc

raw
1 #include <stdio.h>
2 exec sql include sqlca;
3 #include <stdlib.h>
4 exec sql include ../regression;
5
6 int main(void)
7 {
8 exec sql begin declare section;
9 int *ip1=0;
10 char **cp2=0;
11 int *ipointer1=0;
12 int *ipointer2=0;
13 int colnum;
14 exec sql end declare section;
15 int i;
16
17 ECPGdebug(1, stderr);
18
19 exec sql whenever sqlerror do sqlprint();
20 exec sql connect to REGRESSDB1;
21
22 exec sql set datestyle to postgres;
23
24 exec sql create table test (a int, b text);
25 exec sql insert into test values (1, 'one');
26 exec sql insert into test values (2, 'two');
27 exec sql insert into test values (NULL, 'three');
28 exec sql insert into test values (4, 'four');
29 exec sql insert into test values (5, NULL);
30 exec sql insert into test values (NULL, NULL);
31
32 exec sql allocate descriptor mydesc;
33 exec sql select * into sql descriptor mydesc from test;
34 exec sql get descriptor mydesc :colnum=COUNT;
35 exec sql get descriptor mydesc value 1 :ip1=DATA, :ipointer1=INDICATOR;
36 exec sql get descriptor mydesc value 2 :cp2=DATA, :ipointer2=INDICATOR;
37
38 printf("Result (%d columns):\n", colnum);
39 for (i=0;i < sqlca.sqlerrd[2];++i)
40 {
41 if (ipointer1[i]) printf("NULL, ");
42 else printf("%d, ",ip1[i]);
43
44 if (ipointer2[i]) printf("NULL, ");
45 else printf("'%s', ",cp2[i]);
46 printf("\n");
47 }
48 ECPGfree_auto_mem();
49 printf("\n");
50
51 exec sql deallocate descriptor mydesc;
52 exec sql rollback;
53 exec sql disconnect;
54 return 0;
55 }