Age         Owner                  TLA  Line data    Source code

                                  1                 : #include <stdio.h>
                                  2                 : #include <stdlib.h>
                                  3                 : #include <string.h>
                                  4                 : 
                                  5                 : EXEC SQL INCLUDE ../regression;
                                  6                 : 
 5072 meskes                      7 CBC           1 : int main() {
                                  8                 :   EXEC SQL BEGIN DECLARE SECTION;
 5346                             9               1 :     char var[25] = "public";
                                 10                 :   EXEC SQL END DECLARE SECTION;
                                 11                 : 
 6094                            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                 : 
 5346                            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                 : 
 6031                            22               1 :   EXEC SQL SET search_path TO 'public';
 6094                            23               1 :   EXEC SQL SHOW search_path INTO :var;
                                 24               1 :   printf("Var: Search path: %s\n", var);
                                 25                 : 
 6031                            26               1 :   EXEC SQL SET standard_conforming_strings TO off;
 6094                            27               1 :   EXEC SQL SHOW standard_conforming_strings INTO :var;
                                 28               1 :   printf("Var: Standard conforming strings: %s\n", var);
                                 29                 : 
 6031                            30               1 :   EXEC SQL SET TIME ZONE PST8PDT;
 6094                            31               1 :   EXEC SQL SHOW TIME ZONE INTO :var;
                                 32               1 :   printf("Time Zone: %s\n", var);
                                 33                 : 
 6031                            34               1 :   EXEC SQL SET TRANSACTION ISOLATION LEVEL read committed;
 6094                            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                 : }