TLA  Line data    Source code

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