@@ -155,13 +155,8 @@ dump_sqlda(sqlda_t *sqlda)
155155printf ("name sqlda descriptor: '%s' value %ld\n" ,sqlda -> sqlvar [i ].sqlname .data ,* (longint * )sqlda -> sqlvar [i ].sqldata );
156156break ;
157157case 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 longint * )sqlda -> sqlvar [i ].sqldata );
158+ printf ("name sqlda descriptor: '%s' value %lld\n" ,
159+ sqlda -> sqlvar [i ].sqlname .data ,* (long longint * )sqlda -> sqlvar [i ].sqldata );
165160break ;
166161case ECPGt_double :
167162printf ("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"
192187char * stmt1 = "SELECT * FROM t1" ;
193188
194- #line 72 "sqlda.pgc"
189+ #line 67 "sqlda.pgc"
195190char * stmt2 = "SELECT * FROM t1 WHERE id = ?" ;
196191
197- #line 73 "sqlda.pgc"
192+ #line 68 "sqlda.pgc"
198193int rec ;
199194
200- #line 74 "sqlda.pgc"
195+ #line 69 "sqlda.pgc"
201196int id ;
202197/* exec sql end declare section */
203- #line 75 "sqlda.pgc"
198+ #line 70 "sqlda.pgc"
204199
205200
206201char msg [128 ];
@@ -209,42 +204,42 @@ main (void)
209204
210205strcpy (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
218213strcpy (msg ,"set" );
219214{ECPGdo (__LINE__ ,0 ,1 ,NULL ,0 ,ECPGst_normal ,"set datestyle to iso" ,ECPGt_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
226221strcpy (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
234229strcpy (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
242237strcpy (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
254249strcpy (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
262257strcpy (msg ,"declare" );
263258/* declare mycur1 cursor for $1 */
264- #line 116 "sqlda.pgc"
259+ #line 111 "sqlda.pgc"
265260
266261
267262strcpy (msg ,"open" );
268263{ECPGdo (__LINE__ ,0 ,1 ,NULL ,0 ,ECPGst_normal ,"declare mycur1 cursor for $1" ,
269264ECPGt_char_variable ,(ECPGprepared_statement (NULL ,"st_id1" ,__LINE__ )),(long )1 ,(long )1 ,(1 )* sizeof (char ),
270265ECPGt_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
281276rec = 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 ,
286281ECPGt_sqlda ,& outp_sqlda ,0L ,0L ,0L ,
287282ECPGt_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
297292printf ("FETCH RECORD %d\n" ,++ rec );
298293dump_sqlda (outp_sqlda );
299294}
300295
301296/* exec sql whenever not found continue ; */
302- #line 133 "sqlda.pgc"
297+ #line 128 "sqlda.pgc"
303298
304299
305300strcpy (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
313308strcpy (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
321316free (outp_sqlda );
@@ -326,35 +321,35 @@ if (sqlca.sqlcode < 0) exit (1);}
326321
327322strcpy (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
335330strcpy (msg ,"declare" );
336331/* declare mycur2 cursor for $1 */
337- #line 151 "sqlda.pgc"
332+ #line 146 "sqlda.pgc"
338333
339334
340335strcpy (msg ,"open" );
341336{ECPGdo (__LINE__ ,0 ,1 ,NULL ,0 ,ECPGst_normal ,"declare mycur2 cursor for $1" ,
342337ECPGt_char_variable ,(ECPGprepared_statement (NULL ,"st_id2" ,__LINE__ )),(long )1 ,(long )1 ,(1 )* sizeof (char ),
343338ECPGt_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
350345strcpy (msg ,"fetch" );
351346{ECPGdo (__LINE__ ,0 ,1 ,NULL ,0 ,ECPGst_normal ,"fetch all from mycur2" ,ECPGt_EOIT ,
352347ECPGt_sqlda ,& outp_sqlda ,0L ,0L ,0L ,
353348ECPGt_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
360355outp_sqlda1 = outp_sqlda ;
@@ -372,18 +367,18 @@ if (sqlca.sqlcode < 0) exit (1);}
372367
373368strcpy (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
381376strcpy (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
408403strcpy (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
416411strcpy (msg ,"execute" );
@@ -419,20 +414,20 @@ if (sqlca.sqlcode < 0) exit (1);}
419414ECPGt_NO_INDICATOR ,NULL ,0L ,0L ,0L ,ECPGt_EOIT ,
420415ECPGt_sqlda ,& outp_sqlda ,0L ,0L ,0L ,
421416ECPGt_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
428423dump_sqlda (outp_sqlda );
429424
430425strcpy (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
438433free (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
469464strcpy (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
477472strcpy (msg ,"execute" );
@@ -480,65 +475,65 @@ if (sqlca.sqlcode < 0) exit (1);}
480475ECPGt_NO_INDICATOR ,NULL ,0L ,0L ,0L ,ECPGt_EOIT ,
481476ECPGt_sqlda ,& outp_sqlda ,0L ,0L ,0L ,
482477ECPGt_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
489484dump_sqlda (outp_sqlda );
490485
491486strcpy (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
499494strcpy (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
507502free (inp_sqlda );
508503free (outp_sqlda );
509504
510505strcpy (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
520515strcpy (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
528523strcpy (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
536531strcpy (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
544539return 0 ;