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