1 /* Processed by ecpg (regression mode) */
2 /* These include files are added by the preprocessor */
3 #include <ecpglib.h>
4 #include <ecpgerrno.h>
5 #include <sqlca.h>
6 /* End of automatic include section */
7 #define ECPGdebug(X,Y) ECPGdebug((X)+100,(Y))
8
9 #line 1 "define.pgc"
10
11 #line 1 "sqlca.h"
12 #ifndef POSTGRES_SQLCA_H
13 #define POSTGRES_SQLCA_H
14
15 #ifndef PGDLLIMPORT
16 #if defined(WIN32) || defined(__CYGWIN__)
17 #define PGDLLIMPORT __declspec (dllimport)
18 #else
19 #define PGDLLIMPORT
20 #endif /* __CYGWIN__ */
21 #endif /* PGDLLIMPORT */
22
23 #define SQLERRMC_LEN 150
24
25 #ifdef __cplusplus
26 extern "C"
27 {
28 #endif
29
30 struct sqlca_t
31 {
32 char sqlcaid[8];
33 long sqlabc;
34 long sqlcode;
35 struct
36 {
37 int sqlerrml;
38 char sqlerrmc[SQLERRMC_LEN];
39 } sqlerrm;
40 char sqlerrp[8];
41 long sqlerrd[6];
42 /* Element 0: empty */
43 /* 1: OID of processed tuple if applicable */
44 /* 2: number of rows processed */
45 /* after an INSERT, UPDATE or */
46 /* DELETE statement */
47 /* 3: empty */
48 /* 4: empty */
49 /* 5: empty */
50 char sqlwarn[8];
51 /* Element 0: set to 'W' if at least one other is 'W' */
52 /* 1: if 'W' at least one character string */
53 /* value was truncated when it was */
54 /* stored into a host variable. */
55
56 /*
57 * 2: if 'W' a (hopefully) non-fatal notice occurred
58 */ /* 3: empty */
59 /* 4: empty */
60 /* 5: empty */
61 /* 6: empty */
62 /* 7: empty */
63
64 char sqlstate[5];
65 };
66
67 struct sqlca_t *ECPGget_sqlca(void);
68
69 #ifndef POSTGRES_ECPG_INTERNAL
70 #define sqlca (*ECPGget_sqlca())
71 #endif
72
73 #ifdef __cplusplus
74 }
75 #endif
76
77 #endif
78
79 #line 1 "define.pgc"
80
81
82 #line 1 "regression.h"
83
84
85
86
87
88
89 #line 2 "define.pgc"
90
91
92
93
94
main(void)95 int main(void)
96 {
97 /* exec sql begin declare section */
98
99
100
101 #line 10 "define.pgc"
102 int i ;
103
104 #line 11 "define.pgc"
105 char s [ 200 ] ;
106 /* exec sql end declare section */
107 #line 12 "define.pgc"
108
109
110 ECPGdebug(1, stderr);
111
112 /* exec sql whenever sqlerror do sqlprint ( ) ; */
113 #line 16 "define.pgc"
114
115 { ECPGconnect(__LINE__, 0, "ecpg1_regression" , NULL, NULL , NULL, 0);
116 #line 17 "define.pgc"
117
118 if (sqlca.sqlcode < 0) sqlprint ( );}
119 #line 17 "define.pgc"
120
121
122 { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "create table test ( a int , b text )", ECPGt_EOIT, ECPGt_EORT);
123 #line 19 "define.pgc"
124
125 if (sqlca.sqlcode < 0) sqlprint ( );}
126 #line 19 "define.pgc"
127
128 { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "insert into test values ( 29 , 'abcdef' )", ECPGt_EOIT, ECPGt_EORT);
129 #line 20 "define.pgc"
130
131 if (sqlca.sqlcode < 0) sqlprint ( );}
132 #line 20 "define.pgc"
133
134
135
136 { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "insert into test values ( null , 'defined' )", ECPGt_EOIT, ECPGt_EORT);
137 #line 23 "define.pgc"
138
139 if (sqlca.sqlcode < 0) sqlprint ( );}
140 #line 23 "define.pgc"
141
142
143
144
145
146
147
148
149 { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "insert into test values ( null , 'someothervar not defined' )", ECPGt_EOIT, ECPGt_EORT);
150 #line 31 "define.pgc"
151
152 if (sqlca.sqlcode < 0) sqlprint ( );}
153 #line 31 "define.pgc"
154
155
156
157
158
159 { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "select 1 , 29 :: text || '-' || 'abcdef'", ECPGt_EOIT,
160 ECPGt_int,&(i),(long)1,(long)1,sizeof(int),
161 ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L,
162 ECPGt_char,(s),(long)200,(long)1,(200)*sizeof(char),
163 ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L, ECPGt_EORT);
164 #line 36 "define.pgc"
165
166 if (sqlca.sqlcode < 0) sqlprint ( );}
167 #line 36 "define.pgc"
168
169
170 printf("i: %d, s: %s\n", i, s);
171
172
173
174 { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "insert into test values ( 29 , 'no string' )", ECPGt_EOIT, ECPGt_EORT);
175 #line 42 "define.pgc"
176
177 if (sqlca.sqlcode < 0) sqlprint ( );}
178 #line 42 "define.pgc"
179
180
181
182 /* no value */
183
184
185
186
187
188
189
190 { ECPGdo(__LINE__, 0, 1, NULL, 0, ECPGst_normal, "set TIMEZONE to 'UTC'", ECPGt_EOIT, ECPGt_EORT);
191 #line 53 "define.pgc"
192
193 if (sqlca.sqlcode < 0) sqlprint ( );}
194 #line 53 "define.pgc"
195
196
197
198 { ECPGdisconnect(__LINE__, "CURRENT");
199 #line 56 "define.pgc"
200
201 if (sqlca.sqlcode < 0) sqlprint ( );}
202 #line 56 "define.pgc"
203
204 return 0;
205 }
206