Line data    Source code

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