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