Line data    Source code

       1              : #include <stdio.h>
       2              : 
       3              : EXEC SQL INCLUDE sqlca;
       4              : exec sql include ../regression;
       5              : 
       6              : EXEC SQL WHENEVER SQLERROR sqlprint;
       7              : 
       8              : int
       9            0 : main ()
      10              : {
      11            0 :   ECPGdebug (1, stderr);
      12              : 
      13            0 :   EXEC SQL CONNECT TO REGRESSDB1;
      14            0 :   EXEC SQL CREATE TABLE foo (a int, b varchar);
      15            0 :   EXEC SQL INSERT INTO foo VALUES (5, 'abc');
      16            0 :   EXEC SQL INSERT INTO foo VALUES (6, 'def');
      17            0 :   EXEC SQL INSERT INTO foo VALUES (7, 'ghi');
      18            0 : 
      19            0 :   EXEC SQL COPY foo TO STDOUT WITH DELIMITER ',';
      20            0 :   printf ("copy to STDOUT : sqlca.sqlcode = %ld\n", sqlca.sqlcode);
      21              : 
      22            0 :   EXEC SQL DISCONNECT;
      23            0 : 
      24            0 :   return 0;
      25              : }