95{
96
97
98
99
100#line 9 "indicators.pgc"
101 int intvar = 5 ;
102
103#line 10 "indicators.pgc"
104 int nullind = - 1 ;
105
106#line 11 "indicators.pgc"
107
108
110
111 {
ECPGconnect(__LINE__, 0,
"ecpg1_regression" , NULL, NULL , NULL, 0); }
112#line 15 "indicators.pgc"
113
115#line 16 "indicators.pgc"
116
117
118 {
ECPGdo(__LINE__, 0, 1, NULL, 0,
ECPGst_normal,
"create table indicator_test ( \"id\" int primary key , \"str\" text not null , val int null )",
ECPGt_EOIT,
ECPGt_EORT);}
119#line 21 "indicators.pgc"
120
121 {
ECPGtrans(__LINE__, NULL,
"commit work");}
122#line 22 "indicators.pgc"
123
124
125 {
ECPGdo(__LINE__, 0, 1, NULL, 0,
ECPGst_normal,
"insert into indicator_test ( id , str , val ) values ( 1 , 'Hello' , 0 )",
ECPGt_EOIT,
ECPGt_EORT);}
126#line 24 "indicators.pgc"
127
128
129
130 {
ECPGdo(__LINE__, 0, 1, NULL, 0,
ECPGst_normal,
"insert into indicator_test ( id , str , val ) values ( 2 , 'Hi there' , $1 )",
131 ECPGt_int,&(intvar),(
long)1,(
long)1,
sizeof(
int),
133#line 27 "indicators.pgc"
134
135 nullind = 0;
136 {
ECPGdo(__LINE__, 0, 1, NULL, 0,
ECPGst_normal,
"insert into indicator_test ( id , str , val ) values ( 3 , 'Good evening' , $1 )",
137 ECPGt_int,&(intvar),(
long)1,(
long)1,
sizeof(
int),
139#line 29 "indicators.pgc"
140
141 {
ECPGtrans(__LINE__, NULL,
"commit work");}
142#line 30 "indicators.pgc"
143
144
145
147 ECPGt_int,&(intvar),(
long)1,(
long)1,
sizeof(
int),
149#line 33 "indicators.pgc"
150
152 ECPGt_int,&(intvar),(
long)1,(
long)1,
sizeof(
int),
154#line 34 "indicators.pgc"
155
156 printf(
"intvar: %d, nullind: %d\n", intvar, nullind);
158 ECPGt_int,&(intvar),(
long)1,(
long)1,
sizeof(
int),
160#line 36 "indicators.pgc"
161
162 printf(
"intvar: %d, nullind: %d\n", intvar, nullind);
163
164
165 intvar = 5; nullind = -1;
166 {
ECPGdo(__LINE__, 0, 1, NULL, 0,
ECPGst_normal,
"update indicator_test set val = $1 where id = 1",
167 ECPGt_int,&(intvar),(
long)1,(
long)1,
sizeof(
int),
169#line 41 "indicators.pgc"
170
172 ECPGt_int,&(intvar),(
long)1,(
long)1,
sizeof(
int),
174#line 42 "indicators.pgc"
175
176 printf(
"intvar: %d, nullind: %d\n", intvar, nullind);
177
179#line 45 "indicators.pgc"
180
181 {
ECPGtrans(__LINE__, NULL,
"commit work");}
182#line 46 "indicators.pgc"
183
184
186#line 48 "indicators.pgc"
187
188 return 0;
189}
bool ECPGsetcommit(int lineno, const char *mode, const char *connection_name)
bool ECPGdisconnect(int lineno, const char *connection_name)
bool ECPGconnect(int lineno, int c, const char *name, const char *user, const char *passwd, const char *connection_name, int autocommit)
bool ECPGdo(const int lineno, const int compat, const int force_indicator, const char *connection_name, const bool questionmarks, const int st, const char *query,...)
bool ECPGtrans(int lineno, const char *connection_name, const char *transaction)