1
/* Processed by ecpg (regression mode) */
2
/* These include files are added by the preprocessor */
6
/* End of automatic include section */
7
#define ECPGdebug(X,Y) ECPGdebug((X)+100,(Y))
16
#line 1 "regression.h"
26
/* exec sql whenever sqlerror sqlprint ; */
33
/* exec sql begin declare section */
40
#line 14 "oldexec.pgc"
43
#line 15 "oldexec.pgc"
46
#line 16 "oldexec.pgc"
47
char name [ 8 ] [ 8 ] ;
49
#line 17 "oldexec.pgc"
50
char letter [ 8 ] [ 1 ] ;
52
#line 18 "oldexec.pgc"
53
char command [ 128 ] ;
54
/* exec sql end declare section */
55
#line 19 "oldexec.pgc"
61
{ ECPGconnect(__LINE__, 0, "regress1" , NULL, NULL , "main", 0);
62
#line 24 "oldexec.pgc"
64
if (sqlca.sqlcode < 0) sqlprint();}
65
#line 24 "oldexec.pgc"
67
{ ECPGdo(__LINE__, 0, 1, NULL, 1, ECPGst_normal, "create table test ( name char ( 8 ) , amount int , letter char ( 1 ) )", ECPGt_EOIT, ECPGt_EORT);
68
#line 25 "oldexec.pgc"
70
if (sqlca.sqlcode < 0) sqlprint();}
71
#line 25 "oldexec.pgc"
73
{ ECPGtrans(__LINE__, NULL, "commit");
74
#line 26 "oldexec.pgc"
76
if (sqlca.sqlcode < 0) sqlprint();}
77
#line 26 "oldexec.pgc"
80
sprintf(command, "insert into test (name, amount, letter) values ('db: ''r1''', 1, 'f')");
81
{ ECPGdo(__LINE__, 0, 1, NULL, 1, 2, command, ECPGt_EOIT, ECPGt_EORT);
82
#line 29 "oldexec.pgc"
84
if (sqlca.sqlcode < 0) sqlprint();}
85
#line 29 "oldexec.pgc"
88
sprintf(command, "insert into test (name, amount, letter) values ('db: ''r1''', 2, 't')");
89
{ ECPGdo(__LINE__, 0, 1, NULL, 1, 2, command, ECPGt_EOIT, ECPGt_EORT);
90
#line 32 "oldexec.pgc"
92
if (sqlca.sqlcode < 0) sqlprint();}
93
#line 32 "oldexec.pgc"
96
sprintf(command, "insert into test (name, amount, letter) select name, amount+10, letter from test");
97
{ ECPGdo(__LINE__, 0, 1, NULL, 1, 2, command, ECPGt_EOIT, ECPGt_EORT);
98
#line 35 "oldexec.pgc"
100
if (sqlca.sqlcode < 0) sqlprint();}
101
#line 35 "oldexec.pgc"
104
printf("Inserted %ld tuples via execute immediate\n", sqlca.sqlerrd[2]);
106
sprintf(command, "insert into test (name, amount, letter) select name, amount+$1, letter from test");
107
{ ECPGprepare(__LINE__, NULL, 1, "i", command);
108
#line 40 "oldexec.pgc"
110
if (sqlca.sqlcode < 0) sqlprint();}
111
#line 40 "oldexec.pgc"
113
{ ECPGdo(__LINE__, 0, 1, NULL, 1, 1, "i",
114
ECPGt_int,&(increment),(long)1,(long)1,sizeof(int),
115
ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EOIT, ECPGt_EORT);
116
#line 41 "oldexec.pgc"
118
if (sqlca.sqlcode < 0) sqlprint();}
119
#line 41 "oldexec.pgc"
122
printf("Inserted %ld tuples via prepared execute\n", sqlca.sqlerrd[2]);
124
{ ECPGtrans(__LINE__, NULL, "commit");
125
#line 45 "oldexec.pgc"
127
if (sqlca.sqlcode < 0) sqlprint();}
128
#line 45 "oldexec.pgc"
131
sprintf (command, "select * from test");
133
{ ECPGprepare(__LINE__, NULL, 1, "f", command);
134
#line 49 "oldexec.pgc"
136
if (sqlca.sqlcode < 0) sqlprint();}
137
#line 49 "oldexec.pgc"
139
/* declare CUR cursor for $1 */
140
#line 50 "oldexec.pgc"
143
{ ECPGdo(__LINE__, 0, 1, NULL, 1, ECPGst_normal, "declare CUR cursor for $1",
144
ECPGt_char_variable,(ECPGprepared_statement(NULL, "f", __LINE__)),(long)1,(long)1,(1)*sizeof(char),
145
ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EOIT, ECPGt_EORT);
146
#line 52 "oldexec.pgc"
148
if (sqlca.sqlcode < 0) sqlprint();}
149
#line 52 "oldexec.pgc"
151
{ ECPGdo(__LINE__, 0, 1, NULL, 1, ECPGst_normal, "fetch 8 in CUR", ECPGt_EOIT,
152
ECPGt_char,(name),(long)8,(long)8,(8)*sizeof(char),
153
ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L,
154
ECPGt_int,(amount),(long)1,(long)8,sizeof(int),
155
ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L,
156
ECPGt_char,(letter),(long)1,(long)8,(1)*sizeof(char),
157
ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EORT);
158
#line 53 "oldexec.pgc"
160
if (sqlca.sqlcode < 0) sqlprint();}
161
#line 53 "oldexec.pgc"
164
for (i=0, j=sqlca.sqlerrd[2]; i<j; i++)
166
/* exec sql begin declare section */
170
#line 58 "oldexec.pgc"
171
char n [ 8 ] , l = letter [ i ] [ 0 ] ;
173
#line 59 "oldexec.pgc"
174
int a = amount [ i ] ;
175
/* exec sql end declare section */
176
#line 60 "oldexec.pgc"
179
strncpy(n, name[i], 8);
180
printf("name[%d]=%8.8s\tamount[%d]=%d\tletter[%d]=%c\n", i, n, i, a, i, l);
183
{ ECPGdo(__LINE__, 0, 1, NULL, 1, ECPGst_normal, "close CUR", ECPGt_EOIT, ECPGt_EORT);
184
#line 66 "oldexec.pgc"
186
if (sqlca.sqlcode < 0) sqlprint();}
187
#line 66 "oldexec.pgc"
190
sprintf (command, "select * from test where ? = amount");
192
{ ECPGprepare(__LINE__, NULL, 1, "f", command);
193
#line 70 "oldexec.pgc"
195
if (sqlca.sqlcode < 0) sqlprint();}
196
#line 70 "oldexec.pgc"
198
/* declare CUR3 cursor for $1 */
199
#line 71 "oldexec.pgc"
202
{ ECPGdo(__LINE__, 0, 1, NULL, 1, ECPGst_normal, "declare CUR3 cursor for $1",
203
ECPGt_char_variable,(ECPGprepared_statement(NULL, "f", __LINE__)),(long)1,(long)1,(1)*sizeof(char),
204
ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L,
205
ECPGt_const,"1",(long)1,(long)1,strlen("1"),
206
ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EOIT, ECPGt_EORT);
207
#line 73 "oldexec.pgc"
209
if (sqlca.sqlcode < 0) sqlprint();}
210
#line 73 "oldexec.pgc"
212
{ ECPGdo(__LINE__, 0, 1, NULL, 1, ECPGst_normal, "fetch in CUR3", ECPGt_EOIT,
213
ECPGt_char,(name),(long)8,(long)8,(8)*sizeof(char),
214
ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L,
215
ECPGt_int,(amount),(long)1,(long)8,sizeof(int),
216
ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L,
217
ECPGt_char,(letter),(long)1,(long)8,(1)*sizeof(char),
218
ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EORT);
219
#line 74 "oldexec.pgc"
221
if (sqlca.sqlcode < 0) sqlprint();}
222
#line 74 "oldexec.pgc"
225
for (i=0, j=sqlca.sqlerrd[2]; i<j; i++)
227
/* exec sql begin declare section */
231
#line 79 "oldexec.pgc"
232
char n [ 8 ] , l = letter [ i ] [ 0 ] ;
234
#line 80 "oldexec.pgc"
235
int a = amount [ i ] ;
236
/* exec sql end declare section */
237
#line 81 "oldexec.pgc"
240
strncpy(n, name[i], 8);
241
printf("name[%d]=%8.8s\tamount[%d]=%d\tletter[%d]=%c\n", i, n, i, a, i, l);
244
{ ECPGdo(__LINE__, 0, 1, NULL, 1, ECPGst_normal, "close CUR3", ECPGt_EOIT, ECPGt_EORT);
245
#line 87 "oldexec.pgc"
247
if (sqlca.sqlcode < 0) sqlprint();}
248
#line 87 "oldexec.pgc"
250
{ ECPGdo(__LINE__, 0, 1, NULL, 1, ECPGst_normal, "drop table test", ECPGt_EOIT, ECPGt_EORT);
251
#line 88 "oldexec.pgc"
253
if (sqlca.sqlcode < 0) sqlprint();}
254
#line 88 "oldexec.pgc"
256
{ ECPGtrans(__LINE__, NULL, "commit");
257
#line 89 "oldexec.pgc"
259
if (sqlca.sqlcode < 0) sqlprint();}
260
#line 89 "oldexec.pgc"
262
{ ECPGdisconnect(__LINE__, "CURRENT");
263
#line 90 "oldexec.pgc"
265
if (sqlca.sqlcode < 0) sqlprint();}
266
#line 90 "oldexec.pgc"