@@ -155,13 +155,8 @@ dump_sqlda(sqlda_t *sqlda)
155155 printf ("name sqlda descriptor: '%s' value %ld\n" , sqlda -> sqlvar [i ].sqlname .data , * (long int * )sqlda -> sqlvar [i ].sqldata );
156156 break ;
157157 case ECPGt_long_long :
158- printf (
159- #ifdef _WIN32
160- "name sqlda descriptor: '%s' value %I64d\n" ,
161- #else
162- "name sqlda descriptor: '%s' value %lld\n" ,
163- #endif
164- sqlda -> sqlvar [i ].sqlname .data , * (long long int * )sqlda -> sqlvar [i ].sqldata );
158+ printf ("name sqlda descriptor: '%s' value %lld\n" ,
159+ sqlda -> sqlvar [i ].sqlname .data , * (long long int * )sqlda -> sqlvar [i ].sqldata );
165160 break ;
166161 case ECPGt_double :
167162 printf ("name sqlda descriptor: '%s' value %f\n" , sqlda -> sqlvar [i ].sqlname .data , * (double * )sqlda -> sqlvar [i ].sqldata );
@@ -188,19 +183,19 @@ main (void)
188183
189184
190185
191- #line 71 "sqlda.pgc"
186+ #line 66 "sqlda.pgc"
192187 char * stmt1 = "SELECT * FROM t1" ;
193188
194- #line 72 "sqlda.pgc"
189+ #line 67 "sqlda.pgc"
195190 char * stmt2 = "SELECT * FROM t1 WHERE id = ?" ;
196191
197- #line 73 "sqlda.pgc"
192+ #line 68 "sqlda.pgc"
198193 int rec ;
199194
200- #line 74 "sqlda.pgc"
195+ #line 69 "sqlda.pgc"
201196 int id ;
202197/* exec sql end declare section */
203- #line 75 "sqlda.pgc"
198+ #line 70 "sqlda.pgc"
204199
205200
206201 char msg [128 ];
@@ -209,42 +204,42 @@ main (void)
209204
210205 strcpy (msg , "connect" );
211206 { ECPGconnect (__LINE__ , 0 , "ecpg1_regression" , NULL , NULL , "regress1" , 0 );
212- #line 82 "sqlda.pgc"
207+ #line 77 "sqlda.pgc"
213208
214209if (sqlca .sqlcode < 0 ) exit (1 );}
215- #line 82 "sqlda.pgc"
210+ #line 77 "sqlda.pgc"
216211
217212
218213 strcpy (msg , "set" );
219214 { ECPGdo (__LINE__ , 0 , 1 , NULL , 0 , ECPGst_normal , "set datestyle to iso" , E
57AE
CPGt_EOIT , ECPGt_EORT );
220- #line 85 "sqlda.pgc"
215+ #line 80 "sqlda.pgc"
221216
222217if (sqlca .sqlcode < 0 ) exit (1 );}
223- #line 85 "sqlda.pgc"
218+ #line 80 "sqlda.pgc"
224219
225220
226221 strcpy (msg , "create" );
227222 { ECPGdo (__LINE__ , 0 , 1 , NULL , 0 , ECPGst_normal , "create table t1 ( id integer , t text , d1 numeric , d2 float8 , c char ( 10 ) , big bigint )" , ECPGt_EOIT , ECPGt_EORT );
228- #line 95 "sqlda.pgc"
223+ #line 90 "sqlda.pgc"
229224
230225if (sqlca .sqlcode < 0 ) exit (1 );}
231- #line 95 "sqlda.pgc"
226+ #line 90 "sqlda.pgc"
232227
233228
234229 strcpy (msg , "insert" );
235230 { ECPGdo (__LINE__ , 0 , 1 , NULL , 0 , ECPGst_normal , "insert into t1 values ( 1 , 'a' , 1.0 , 1 , 'a' , 1111111111111111111 ) , ( 2 , null , null , null , null , null ) , ( 3 , 'c' , 0.0 , 3 , 'c' , 3333333333333333333 ) , ( 4 , 'd' , 'NaN' , 4 , 'd' , 4444444444444444444 ) , ( 5 , 'e' , 0.001234 , 5 , 'e' , 5555555555555555555 )" , ECPGt_EOIT , ECPGt_EORT );
236- #line 103 "sqlda.pgc"
231+ #line 98 "sqlda.pgc"
237232
238233if (sqlca .sqlcode < 0 ) exit (1 );}
239- #line 103 "sqlda.pgc"
234+ #line 98 "sqlda.pgc"
240235
241236
242237 strcpy (msg , "commit" );
243238 { ECPGtrans (__LINE__ , NULL , "commit" );
244- #line 106 "sqlda.pgc"
239+ #line 101 "sqlda.pgc"
245240
246241if (sqlca .sqlcode < 0 ) exit (1 );}
247- #line 106 "sqlda.pgc"
242+ #line 101 "sqlda.pgc"
248243
249244
250245 /* SQLDA test for getting all records from a table */
@@ -253,29 +248,29 @@ if (sqlca.sqlcode < 0) exit (1);}
253248
254249 strcpy (msg , "prepare" );
255250 { ECPGprepare (__LINE__ , NULL , 0 , "st_id1" , stmt1 );
256- #line 113 "sqlda.pgc"
251+ #line 108 "sqlda.pgc"
257252
258253if (sqlca .sqlcode < 0 ) exit (1 );}
259- #line 113 "sqlda.pgc"
254+ #line 108 "sqlda.pgc"
260255
261256
262257 strcpy (msg , "declare" );
263258 /* declare mycur1 cursor for $1 */
264- #line 116 "sqlda.pgc"
259+ #line 111 "sqlda.pgc"
265260
266261
267262 strcpy (msg , "open" );
268263 { ECPGdo (__LINE__ , 0 , 1 , NULL , 0 , ECPGst_normal , "declare mycur1 cursor for $1" ,
269264 ECPGt_char_variable ,(ECPGprepared_statement (NULL , "st_id1" , __LINE__ )),(long )1 ,(long )1 ,(1 )* sizeof (char ),
270265 ECPGt_NO_INDICATOR , NULL , 0L , 0L , 0L , ECPGt_EOIT , ECPGt_EORT );
271- #line 119 "sqlda.pgc"
266+ #line 114 "sqlda.pgc"
272267
273268if (sqlca .sqlcode < 0 ) exit (1 );}
274- #line 119 "sqlda.pgc"
269+ #line 114 "sqlda.pgc"
275270
276271
277272 /* exec sql whenever not found break ; */
278- #line 121 "sqlda.pgc"
273+ #line 116 "sqlda.pgc"
279274
280275
281276 rec = 0 ;
@@ -285,37 +280,37 @@ if (sqlca.sqlcode < 0) exit (1);}
285280 { ECPGdo (__LINE__ , 0 , 1 , NULL , 0 , ECPGst_normal , "fetch 1 from mycur1" , ECPGt_EOIT ,
286281 ECPGt_sqlda , & outp_sqlda , 0L , 0L , 0L ,
287282 ECPGt_NO_INDICATOR , NULL , 0L , 0L , 0L , ECPGt_EORT );
288- #line 127 "sqlda.pgc"
283+ #line 122 "sqlda.pgc"
289284
290285if (sqlca .sqlcode == ECPG_NOT_FOUND ) break ;
291- #line 127 "sqlda.pgc"
286+ #line 122 "sqlda.pgc"
292287
293288if (sqlca .sqlcode < 0 ) exit (1 );}
294- #line 127 "sqlda.pgc"
289+ #line 122 "sqlda.pgc"
295290
296291
297292 printf ("FETCH RECORD %d\n" , ++ rec );
298293 dump_sqlda (outp_sqlda );
299294 }
300295
301296 /* exec sql whenever not found continue ; */
302- #line 133 "sqlda.pgc"
297+ #line 128 "sqlda.pgc"
303298
304299
305300 strcpy (msg , "close" );
306301 { ECPGdo (__LINE__ , 0 , 1 , NULL , 0 , ECPGst_normal , "close mycur1" , ECPGt_EOIT , ECPGt_EORT );
307- #line 136 "sqlda.pgc"
302+ #line 131 "sqlda.pgc"
308303
309304if (sqlca .sqlcode < 0 ) exit (1 );}
310- #line 136 "sqlda.pgc"
305+ #line 131 "sqlda.pgc"
311306
312307
313308 strcpy (msg , "deallocate" );
314309 { ECPGdeallocate (__LINE__ , 0 , NULL , "st_id1" );
315- #line 139 "sqlda.pgc"
310+ #line 134 "sqlda.pgc"
316311
317312if (sqlca .sqlcode < 0 ) exit (1 );}
318- #line 139 "sqlda.pgc"
313+ #line 134 "sqlda.pgc"
319314
320315
321316 free (outp_sqlda );
@@ -326,35 +321,35 @@ if (sqlca.sqlcode < 0) exit (1);}
326321
327322 strcpy (msg , "prepare" );
328323 { ECPGprepare (__LINE__ , NULL , 0 , "st_id2" , stmt1 );
329- #line 148 "sqlda.pgc"
324+ #line 143 "sqlda.pgc"
330325
331326if (sqlca .sqlcode < 0 ) exit (1 );}
332- #line 148 "sqlda.pgc"
327+ #line 143 "sqlda.pgc"
333328
334329
335330 strcpy (msg , "declare" );
336331 /* declare mycur2 cursor for $1 */
337- #line 151 "sqlda.pgc"
332+ #line 146 "sqlda.pgc"
338333
339334
340335 strcpy (msg , "open" );
341336 { ECPGdo (__LINE__ , 0 , 1 , NULL , 0 , ECPGst_normal , "declare mycur2 cursor for $1" ,
342337 ECPGt_char_variable ,(ECPGprepared_statement (NULL , "st_id2" , __LINE__ )),(long )1 ,(long )1 ,(1 )* sizeof (char ),
343338 ECPGt_NO_INDICATOR , NULL , 0L , 0L , 0L , ECPGt_EOIT , ECPGt_EORT );
344- #line 154 "sqlda.pgc"
339+ #line 149 "sqlda.pgc"
345340
346341if (sqlca .sqlcode < 0 ) exit (1 );}
347- #line 154 "sqlda.pgc"
342+ #line 149 "sqlda.pgc"
348343
349344
350345 strcpy (msg , "fetch" );
351346 { ECPGdo (__LINE__ , 0 , 1 , NULL , 0 , ECPGst_normal , "fetch all from mycur2" , ECPGt_EOIT ,
352347 ECPGt_sqlda , & outp_sqlda , 0L , 0L , 0L ,
353348 ECPGt_NO_INDICATOR , NULL , 0L , 0L , 0L , ECPGt_EORT );
354- #line 157 "sqlda.pgc"
349+ #line 152 "sqlda.pgc"
355350
356351if (sqlca .sqlcode < 0 ) exit (1 );}
357- #line 157 "sqlda.pgc"
352+ #line 152 "sqlda.pgc"
358353
359354
360355 outp_sqlda1 = outp_sqlda ;
@@ -372,18 +367,18 @@ if (sqlca.sqlcode < 0) exit (1);}
372367
373368 strcpy (msg , "close" );
374369 { ECPGdo (__LINE__ , 0 , 1 , NULL , 0 , ECPGst_normal , "close mycur2" , ECPGt_EOIT , ECPGt_EORT );
375- #line 173 "sqlda.pgc"
370+ #line 168 "sqlda.pgc"
376371
377372if (sqlca .sqlcode < 0 ) exit (1 );}
378- #line 173 "sqlda.pgc"
373+ #line 168 "sqlda.pgc"
379374
380375
381376 strcpy (msg , "deallocate" );
382377 { ECPGdeallocate (__LINE__ , 0 , NULL , "st_id2" );
383- #line 176 "sqlda.pgc"
378+ #line 171 "sqlda.pgc"
384379
385380if (sqlca .sqlcode < 0 ) exit (1 );}
386- #line 176 "sqlda.pgc"
381+ #line 171 "sqlda.pgc"
387382
388383
389384 /* SQLDA test for getting one record using an input descriptor */
@@ -407,10 +402,10 @@ if (sqlca.sqlcode < 0) exit (1);}
407402
408403 strcpy (msg , "prepare" );
409404 { ECPGprepare (__LINE__ , NULL , 0 , "st_id3" , stmt2 );
410- #line 198 "sqlda.pgc"
405+ #line 193 "sqlda.pgc"
411406
412407if (sqlca .sqlcode < 0 ) exit (1 );}
413- #line 198 "sqlda.pgc"
408+ #line 193 "sqlda.pgc"
414409
415410
416411 strcpy (msg , "execute" );
@@ -419,20 +414,20 @@ if (sqlca.sqlcode < 0) exit (1);}
419414 ECPGt_NO_INDICATOR , NULL , 0L , 0L , 0L , ECPGt_EOIT ,
420415 ECPGt_sqlda , & outp_sqlda , 0L , 0L , 0L ,
421416 ECPGt_NO_INDICATOR , NULL , 0L , 0L , 0L , ECPGt_EORT );
422- #line 201 "sqlda.pgc"
417+ #line 196 "sqlda.pgc"
423418
424419if (sqlca .sqlcode < 0 ) exit (1 );}
425- #line 201 "sqlda.pgc"
420+ #line 196 "sqlda.pgc"
426421
427422
428423 dump_sqlda (outp_sqlda );
429424
430425 strcpy (msg , "deallocate" );
431426 { ECPGdeallocate (__LINE__ , 0 , NULL , "st_id3" );
432- #line 206 "sqlda.pgc"
427+ #line 201 "sqlda.pgc"
433428
434429if (sqlca .sqlcode < 0 ) exit (1 );}
435- #line 206 "sqlda.pgc"
430+ #line 201 "sqlda.pgc"
436431
437432
438433 free (inp_sqlda );
@@ -443,10 +438,10 @@ if (sqlca.sqlcode < 0) exit (1);}
443438 */
444439
445440 { ECPGconnect (__LINE__ , 0 , "ecpg1_regression" , NULL , NULL , "con2" , 0 );
446- #line 215 "sqlda.pgc"
441+ #line 210 "sqlda.pgc"
447442
448443if (sqlca .sqlcode < 0 ) exit (1 );}
449- #line 215 "sqlda.pgc"
444+ #line 210 "sqlda.pgc"
450445
451446
452447 /*
@@ -468,10 +463,10 @@ if (sqlca.sqlcode < 0) exit (1);}
468463
469464 strcpy (msg , "prepare" );
470465 { ECPGprepare (__LINE__ , "con2" , 0 , "st_id4" , stmt2 );
471- #line 235 "sqlda.pgc"
466+ #line 230 "sqlda.pgc"
472467
473468if (sqlca .sqlcode < 0 ) exit (1 );}
474- #line 235 "sqlda.pgc"
469+ #line 230 "sqlda.pgc"
475470
476471
477472 strcpy (msg , "execute" );
@@ -480,65 +475,65 @@ if (sqlca.sqlcode < 0) exit (1);}
480475 ECPGt_NO_INDICATOR , NULL , 0L , 0L , 0L , ECPGt_EOIT ,
481476 ECPGt_sqlda , & outp_sqlda , 0L , 0L , 0L ,
482477 ECPGt_NO_INDICATOR , NULL , 0L , 0L , 0L , ECPGt_EORT );
483- #line 238 "sqlda.pgc"
478+ #line 233 "sqlda.pgc"
484479
485480if (sqlca .sqlcode < 0 ) exit (1 );}
486- #line 238 "sqlda.pgc"
481+ #line 233 "sqlda.pgc"
487482
488483
489484 dump_sqlda (outp_sqlda );
490485
491486 strcpy (msg , "commit" );
492487 { ECPGtrans (__LINE__ , "con2" , "commit" );
493- #line 243 "sqlda.pgc"
488+ #line 238 "sqlda.pgc"
494489
495490if (sqlca .sqlcode < 0 ) exit (1 );}
496- #line 243 "sqlda.pgc"
491+ #line 238 "sqlda.pgc"
497492
498493
499494 strcpy (msg , "deallocate" );
500495 { ECPGdeallocate (__LINE__ , 0 , NULL , "st_id4" );
501- #line 246 "sqlda.pgc"
496+ #line 241 "sqlda.pgc"
502497
503498if (sqlca .sqlcode < 0 ) exit (1 );}
504- #line 246 "sqlda.pgc"
499+ #line 241 "sqlda.pgc"
505500
506501
507502 free (inp_sqlda );
508503 free (outp_sqlda );
509504
510505 strcpy (msg , "disconnect" );
511506 { ECPGdisconnect (__LINE__ , "con2" );
512- #line 252 "sqlda.pgc"
507+ #line 247 "sqlda.pgc"
513508
514509if (sqlca .sqlcode < 0 ) exit (1 );}
515- #line 252 "sqlda.pgc"
510+ #line 247 "sqlda.pgc"
516511
517512
518513 /* End test */
519514
520515 strcpy (msg , "drop" );
521516 { ECPGdo (__LINE__ , 0 , 1 , NULL , 0 , ECPGst_normal , "drop table t1" , ECPGt_EOIT , ECPGt_EORT );
522- #line 257 "sqlda.pgc"
517+ #line 252 "sqlda.pgc"
523518
524519if (sqlca .sqlcode < 0 ) exit (1 );}
525- #line 257 "sqlda.pgc"
520+ #line 252 "sqlda.pgc"
526521
527522
528523 strcpy (msg , "commit" );
529524 { ECPGtrans (__LINE__ , NULL , "commit" );
530- #line 260 "sqlda.pgc"
525+ #line 255 "sqlda.pgc"
531526
532527if (sqlca .sqlcode < 0 ) exit (1 );}
533- #line 260 "sqlda.pgc"
528+ #line 255 "sqlda.pgc"
534529
535530
536531 strcpy (msg , "disconnect" );
537532 { ECPGdisconnect (__LINE__ , "CURRENT" );
538- #line 263 "sqlda.pgc"
533+ #line 258 "sqlda.pgc"
539534
540535if (sqlca .sqlcode < 0 ) exit (1 );}
541- #line 263 "sqlda.pgc"
536+ #line 258 "sqlda.pgc"
542537
543538
544539 return 0 ;
0 commit comments