Line data    Source code

       1              : #include <stdio.h>
       2              : #include <stdlib.h>
       3              : #include <string.h>
       4              : 
       5              : EXEC SQL INCLUDE ../regression;
       6              : 
       7            0 : int main() {
       8              :   EXEC SQL BEGIN DECLARE SECTION;
       9            0 :     char var[25];
      10            0 :     int i, loopcount;
      11              :   EXEC SQL END DECLARE SECTION;
      12              : 
      13            0 :   ECPGdebug(1, stderr);
      14            0 :   EXEC SQL CONNECT TO REGRESSDB1;
      15              : 
      16            0 :   EXEC SQL SET AUTOCOMMIT TO ON;
      17              :   EXEC SQL WHENEVER SQLWARNING SQLPRINT;
      18              :   EXEC SQL WHENEVER SQLERROR STOP;
      19              : 
      20            0 :   EXEC SQL CREATE TABLE "My_Table" ( Item1 int, Item2 text );
      21            0 : 
      22            0 :   EXEC SQL SET standard_conforming_strings TO on;
      23            0 : 
      24            0 :   EXEC SQL SHOW standard_conforming_strings INTO :var;
      25            0 :   printf("Standard conforming strings: %s\n", var);
      26              : 
      27              :   /* this is a\\\\b actually */
      28            0 :   EXEC SQL INSERT INTO "My_Table" VALUES ( 2, 'a\\\\b' );
      29            0 :   /* this is a\\b */
      30            0 :   EXEC SQL INSERT INTO "My_Table" VALUES ( 2, E'a\\\\b' );
      31            0 : 
      32            0 :   EXEC SQL BEGIN;
      33            0 :   EXEC SQL DECLARE C CURSOR FOR SELECT * FROM "My_Table";
      34              : 
      35            0 :   EXEC SQL OPEN C;
      36            0 : 
      37              :   EXEC SQL WHENEVER NOT FOUND DO BREAK;
      38              : 
      39            0 :   for (loopcount = 0; loopcount < 100; loopcount++)
      40              :   {
      41            0 :         EXEC SQL FETCH C INTO :i, :var;
      42            0 :         printf("value: %d %s\n", i, var);
      43            0 :   }
      44            0 : 
      45            0 :   EXEC SQL ROLLBACK;
      46            0 :   EXEC SQL DROP TABLE "My_Table";
      47            0 : 
      48            0 :   EXEC SQL DISCONNECT ALL;
      49            0 : 
      50            0 :   return 0;
      51            0 : }