Line data    Source code

       1              : #include <stdio.h>
       2              : #include <stdlib.h>
       3              : #include <string.h>
       4              : 
       5              : EXEC SQL INCLUDE ../regression;
       6              : 
       7            2 : int main() {
       8              :   EXEC SQL BEGIN DECLARE SECTION;
       9            2 :     char var[25] = "public";
      10              :   EXEC SQL END DECLARE SECTION;
      11              : 
      12            2 :   ECPGdebug(1, stderr);
      13            2 :   EXEC SQL CONNECT TO REGRESSDB1;
      14              : 
      15              :   EXEC SQL WHENEVER SQLWARNING SQLPRINT;
      16              :   EXEC SQL WHENEVER SQLERROR SQLPRINT;
      17              : 
      18            2 :   EXEC SQL SET search_path TO :var;
      19            2 :   EXEC SQL SHOW search_path INTO :var;
      20            2 :   printf("Var: Search path: %s\n", var);
      21              : 
      22            2 :   EXEC SQL SET search_path TO 'public';
      23            2 :   EXEC SQL SHOW search_path INTO :var;
      24            2 :   printf("Var: Search path: %s\n", var);
      25              : 
      26            2 :   EXEC SQL SET standard_conforming_strings TO on;
      27            2 :   EXEC SQL SHOW standard_conforming_strings INTO :var;
      28            2 :   printf("Var: Standard conforming strings: %s\n", var);
      29              : 
      30            2 :   EXEC SQL SET TIME ZONE PST8PDT;
      31            2 :   EXEC SQL SHOW TIME ZONE INTO :var;
      32            2 :   printf("Time Zone: %s\n", var);
      33              : 
      34            2 :   EXEC SQL SET TRANSACTION ISOLATION LEVEL read committed;
      35            2 :   EXEC SQL SHOW TRANSACTION ISOLATION LEVEL INTO :var;
      36            2 :   printf("Transaction isolation level: %s\n", var);
      37              : 
      38            2 :   EXEC SQL DISCONNECT ALL;
      39            2 : 
      40            2 :   return 0;
      41              : }