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] = "public";
      10              :   EXEC SQL END DECLARE SECTION;
      11              : 
      12            0 :   ECPGdebug(1, stderr);
      13            0 :   EXEC SQL CONNECT TO REGRESSDB1;
      14              : 
      15              :   EXEC SQL WHENEVER SQLWARNING SQLPRINT;
      16              :   EXEC SQL WHENEVER SQLERROR SQLPRINT;
      17              : 
      18            0 :   EXEC SQL SET search_path TO :var;
      19            0 :   EXEC SQL SHOW search_path INTO :var;
      20            0 :   printf("Var: Search path: %s\n", var);
      21              : 
      22            0 :   EXEC SQL SET search_path TO 'public';
      23            0 :   EXEC SQL SHOW search_path INTO :var;
      24            0 :   printf("Var: Search path: %s\n", var);
      25              : 
      26            0 :   EXEC SQL SET standard_conforming_strings TO on;
      27            0 :   EXEC SQL SHOW standard_conforming_strings INTO :var;
      28            0 :   printf("Var: Standard conforming strings: %s\n", var);
      29              : 
      30            0 :   EXEC SQL SET TIME ZONE PST8PDT;
      31            0 :   EXEC SQL SHOW TIME ZONE INTO :var;
      32            0 :   printf("Time Zone: %s\n", var);
      33              : 
      34            0 :   EXEC SQL SET TRANSACTION ISOLATION LEVEL read committed;
      35            0 :   EXEC SQL SHOW TRANSACTION ISOLATION LEVEL INTO :var;
      36            0 :   printf("Transaction isolation level: %s\n", var);
      37              : 
      38            0 :   EXEC SQL DISCONNECT ALL;
      39            0 : 
      40            0 :   return 0;
      41            0 : }