1[NO_PID]: ECPGdebug: set to 1 2[NO_PID]: sqlca: code: 0, state: 00000 3[NO_PID]: ECPGconnect: opening database ecpg1_regression on <DEFAULT> port <DEFAULT> 4[NO_PID]: sqlca: code: 0, state: 00000 5[NO_PID]: ecpg_execute on line 19: query: create table My_Table ( Item1 int , Item2 text ); with 0 parameter(s) on connection ecpg1_regression 6[NO_PID]: sqlca: code: 0, state: 00000 7[NO_PID]: ecpg_execute on line 19: using PQexec 8[NO_PID]: sqlca: code: 0, state: 00000 9[NO_PID]: ecpg_process_output on line 19: OK: CREATE TABLE 10[NO_PID]: sqlca: code: 0, state: 00000 11[NO_PID]: ecpg_execute on line 21: query: insert into My_Table values ( 1 , 'text1' ); with 0 parameter(s) on connection ecpg1_regression 12[NO_PID]: sqlca: code: 0, state: 00000 13[NO_PID]: ecpg_execute on line 21: using PQexec 14[NO_PID]: sqlca: code: 0, state: 00000 15[NO_PID]: ecpg_process_output on line 21: OK: INSERT 0 1 16[NO_PID]: sqlca: code: 0, state: 00000 17[NO_PID]: ecpg_execute on line 22: query: insert into My_Table values ( 2 , 'text2' ); with 0 parameter(s) on connection ecpg1_regression 18[NO_PID]: sqlca: code: 0, state: 00000 19[NO_PID]: ecpg_execute on line 22: using PQexec 20[NO_PID]: sqlca: code: 0, state: 00000 21[NO_PID]: ecpg_process_output on line 22: OK: INSERT 0 1 22[NO_PID]: sqlca: code: 0, state: 00000 23[NO_PID]: ecpg_execute on line 23: query: insert into My_Table values ( 3 , 'text3' ); with 0 parameter(s) on connection ecpg1_regression 24[NO_PID]: sqlca: code: 0, state: 00000 25[NO_PID]: ecpg_execute on line 23: using PQexec 26[NO_PID]: sqlca: code: 0, state: 00000 27[NO_PID]: ecpg_process_output on line 23: OK: INSERT 0 1 28[NO_PID]: sqlca: code: 0, state: 00000 29[NO_PID]: ecpg_execute on line 24: query: insert into My_Table values ( 4 , 'text4' ); with 0 parameter(s) on connection ecpg1_regression 30[NO_PID]: sqlca: code: 0, state: 00000 31[NO_PID]: ecpg_execute on line 24: using PQexec 32[NO_PID]: sqlca: code: 0, state: 00000 33[NO_PID]: ecpg_process_output on line 24: OK: INSERT 0 1 34[NO_PID]: sqlca: code: 0, state: 00000 35[NO_PID]: ecpg_execute on line 28: query: declare C cursor for select * from My_Table; with 0 parameter(s) on connection ecpg1_regression 36[NO_PID]: sqlca: code: 0, state: 00000 37[NO_PID]: ecpg_execute on line 28: using PQexec 38[NO_PID]: sqlca: code: 0, state: 00000 39[NO_PID]: ecpg_process_output on line 28: OK: DECLARE CURSOR 40[NO_PID]: sqlca: code: 0, state: 00000 41[NO_PID]: ecpg_execute on line 32: query: fetch 1 in C; with 0 parameter(s) on connection ecpg1_regression 42[NO_PID]: sqlca: code: 0, state: 00000 43[NO_PID]: ecpg_execute on line 32: using PQexec 44[NO_PID]: sqlca: code: 0, state: 00000 45[NO_PID]: ecpg_process_output on line 32: correctly got 1 tuples with 2 fields 46[NO_PID]: sqlca: code: 0, state: 00000 47[NO_PID]: ecpg_get_data on line 32: RESULT: 1 offset: -1; array: no 48[NO_PID]: sqlca: code: 0, state: 00000 49[NO_PID]: ecpg_get_data on line 32: RESULT: text1 offset: -1; array: no 50[NO_PID]: sqlca: code: 0, state: 00000 51[NO_PID]: ecpg_execute on line 32: query: fetch 1 in C; with 0 parameter(s) on connection ecpg1_regression 52[NO_PID]: sqlca: code: 0, state: 00000 53[NO_PID]: ecpg_execute on line 32: using PQexec 54[NO_PID]: sqlca: code: 0, state: 00000 55[NO_PID]: ecpg_process_output on line 32: correctly got 1 tuples with 2 fields 56[NO_PID]: sqlca: code: 0, state: 00000 57[NO_PID]: ecpg_get_data on line 32: RESULT: 2 offset: -1; array: no 58[NO_PID]: sqlca: code: 0, state: 00000 59[NO_PID]: ecpg_get_data on line 32: RESULT: text2 offset: -1; array: no 60[NO_PID]: sqlca: code: 0, state: 00000 61[NO_PID]: ecpg_execute on line 32: query: fetch 1 in C; with 0 parameter(s) on connection ecpg1_regression 62[NO_PID]: sqlca: code: 0, state: 00000 63[NO_PID]: ecpg_execute on line 32: using PQexec 64[NO_PID]: sqlca: code: 0, state: 00000 65[NO_PID]: ecpg_process_output on line 32: correctly got 1 tuples with 2 fields 66[NO_PID]: sqlca: code: 0, state: 00000 67[NO_PID]: ecpg_get_data on line 32: RESULT: 3 offset: -1; array: no 68[NO_PID]: sqlca: code: 0, state: 00000 69[NO_PID]: ecpg_get_data on line 32: RESULT: text3 offset: -1; array: no 70[NO_PID]: sqlca: code: 0, state: 00000 71[NO_PID]: ecpg_execute on line 32: query: fetch 1 in C; with 0 parameter(s) on connection ecpg1_regression 72[NO_PID]: sqlca: code: 0, state: 00000 73[NO_PID]: ecpg_execute on line 32: using PQexec 74[NO_PID]: sqlca: code: 0, state: 00000 75[NO_PID]: ecpg_process_output on line 32: correctly got 1 tuples with 2 fields 76[NO_PID]: sqlca: code: 0, state: 00000 77[NO_PID]: ecpg_get_data on line 32: RESULT: 4 offset: -1; array: no 78[NO_PID]: sqlca: code: 0, state: 00000 79[NO_PID]: ecpg_get_data on line 32: RESULT: text4 offset: -1; array: no 80[NO_PID]: sqlca: code: 0, state: 00000 81[NO_PID]: ecpg_execute on line 32: query: fetch 1 in C; with 0 parameter(s) on connection ecpg1_regression 82[NO_PID]: sqlca: code: 0, state: 00000 83[NO_PID]: ecpg_execute on line 32: using PQexec 84[NO_PID]: sqlca: code: 0, state: 00000 85[NO_PID]: ecpg_process_output on line 32: correctly got 0 tuples with 2 fields 86[NO_PID]: sqlca: code: 0, state: 00000 87[NO_PID]: raising sqlcode 100 on line 32: no data found on line 32 88[NO_PID]: sqlca: code: 100, state: 02000 89[NO_PID]: ecpg_execute on line 37: query: move backward 2 in C; with 0 parameter(s) on connection ecpg1_regression 90[NO_PID]: sqlca: code: 0, state: 00000 91[NO_PID]: ecpg_execute on line 37: using PQexec 92[NO_PID]: sqlca: code: 0, state: 00000 93[NO_PID]: ecpg_process_output on line 37: OK: MOVE 2 94[NO_PID]: sqlca: code: 0, state: 00000 95[NO_PID]: ecpg_execute on line 39: query: fetch 1 in C; with 0 parameter(s) on connection ecpg1_regression 96[NO_PID]: sqlca: code: 0, state: 00000 97[NO_PID]: ecpg_execute on line 39: using PQexec 98[NO_PID]: sqlca: code: 0, state: 00000 99[NO_PID]: ecpg_process_output on line 39: correctly got 1 tuples with 2 fields 100[NO_PID]: sqlca: code: 0, state: 00000 101[NO_PID]: ecpg_get_data on line 39: RESULT: 4 offset: -1; array: no 102[NO_PID]: sqlca: code: 0, state: 00000 103[NO_PID]: ecpg_get_data on line 39: RESULT: text4 offset: -1; array: no 104[NO_PID]: sqlca: code: 0, state: 00000 105[NO_PID]: ecpg_execute on line 42: query: close C; with 0 parameter(s) on connection ecpg1_regression 106[NO_PID]: sqlca: code: 0, state: 00000 107[NO_PID]: ecpg_execute on line 42: using PQexec 108[NO_PID]: sqlca: code: 0, state: 00000 109[NO_PID]: ecpg_process_output on line 42: OK: CLOSE CURSOR 110[NO_PID]: sqlca: code: 0, state: 00000 111[NO_PID]: ecpg_execute on line 46: query: declare D cursor for select * from My_Table where Item1 = $1; with 1 parameter(s) on connection ecpg1_regression 112[NO_PID]: sqlca: code: 0, state: 00000 113[NO_PID]: ecpg_execute on line 46: using PQexecParams 114[NO_PID]: sqlca: code: 0, state: 00000 115[NO_PID]: ecpg_free_params on line 46: parameter 1 = 1 116[NO_PID]: sqlca: code: 0, state: 00000 117[NO_PID]: ecpg_process_output on line 46: OK: DECLARE CURSOR 118[NO_PID]: sqlca: code: 0, state: 00000 119[NO_PID]: ecpg_execute on line 50: query: fetch 1 in D; with 0 parameter(s) on connection ecpg1_regression 120[NO_PID]: sqlca: code: 0, state: 00000 121[NO_PID]: ecpg_execute on line 50: using PQexec 122[NO_PID]: sqlca: code: 0, state: 00000 123[NO_PID]: ecpg_process_output on line 50: correctly got 1 tuples with 2 fields 124[NO_PID]: sqlca: code: 0, state: 00000 125[NO_PID]: ecpg_get_data on line 50: RESULT: 1 offset: -1; array: no 126[NO_PID]: sqlca: code: 0, state: 00000 127[NO_PID]: ecpg_get_data on line 50: RESULT: text1 offset: -1; array: no 128[NO_PID]: sqlca: code: 0, state: 00000 129[NO_PID]: ecpg_execute on line 50: query: fetch 1 in D; with 0 parameter(s) on connection ecpg1_regression 130[NO_PID]: sqlca: code: 0, state: 00000 131[NO_PID]: ecpg_execute on line 50: using PQexec 132[NO_PID]: sqlca: code: 0, state: 00000 133[NO_PID]: ecpg_process_output on line 50: correctly got 0 tuples with 2 fields 134[NO_PID]: sqlca: code: 0, state: 00000 135[NO_PID]: raising sqlcode 100 on line 50: no data found on line 50 136[NO_PID]: sqlca: code: 100, state: 02000 137[NO_PID]: ecpg_execute on line 53: query: close D; with 0 parameter(s) on connection ecpg1_regression 138[NO_PID]: sqlca: code: 0, state: 00000 139[NO_PID]: ecpg_execute on line 53: using PQexec 140[NO_PID]: sqlca: code: 0, state: 00000 141[NO_PID]: ecpg_process_output on line 53: OK: CLOSE CURSOR 142[NO_PID]: sqlca: code: 0, state: 00000 143[NO_PID]: ecpg_execute on line 55: query: drop table My_Table; with 0 parameter(s) on connection ecpg1_regression 144[NO_PID]: sqlca: code: 0, state: 00000 145[NO_PID]: ecpg_execute on line 55: using PQexec 146[NO_PID]: sqlca: code: 0, state: 00000 147[NO_PID]: ecpg_process_output on line 55: OK: DROP TABLE 148[NO_PID]: sqlca: code: 0, state: 00000 149[NO_PID]: ecpg_finish: connection ecpg1_regression closed 150[NO_PID]: sqlca: code: 0, state: 00000 151