Line data Source code
1 : #include <stdio.h>
2 : #include <stdlib.h>
3 : #include <string.h>
4 :
5 : exec sql include ../regression;
6 :
7 : exec sql whenever sqlerror sqlprint;
8 :
9 0 : int main(void)
10 : {
11 0 : char msg[128];
12 :
13 0 : ECPGdebug(1, stderr);
14 :
15 0 : strcpy(msg, "connect");
16 0 : exec sql connect to REGRESSDB1;
17 0 : exec sql set autocommit to off;
18 0 :
19 0 : strcpy(msg, "create");
20 0 : exec sql create table t1(c int);
21 0 :
22 0 : strcpy(msg, "commit");
23 0 : exec sql commit;
24 0 :
25 0 : strcpy(msg, "begin");
26 0 : exec sql begin;
27 0 :
28 0 : strcpy(msg, "insert");
29 0 : exec sql insert into t1 values(1);
30 0 :
31 0 : strcpy(msg, "prepare transaction");
32 0 : exec sql prepare transaction 'ecpg_twophase';
33 0 :
34 0 : strcpy(msg, "commit prepared");
35 0 : exec sql commit prepared 'ecpg_twophase';
36 0 :
37 0 : strcpy(msg, "drop");
38 0 : exec sql drop table t1;
39 0 :
40 0 : strcpy(msg, "disconnect");
41 0 : exec sql disconnect current;
42 0 :
43 0 : return 0;
44 0 : }
|