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 47: query: set datestyle to iso; with 0 parameter(s) on connection ecpg1_regression
6[NO_PID]: sqlca: code: 0, state: 00000
7[NO_PID]: ecpg_execute on line 47: using PQexec
8[NO_PID]: sqlca: code: 0, state: 00000
9[NO_PID]: ecpg_process_output on line 47: OK: SET
10[NO_PID]: sqlca: code: 0, state: 00000
11[NO_PID]: ecpg_execute on line 50: query: create table family ( name char ( 8 ) , born integer , age smallint , married date , children integer ); with 0 parameter(s) on connection ecpg1_regression
12[NO_PID]: sqlca: code: 0, state: 00000
13[NO_PID]: ecpg_execute on line 50: using PQexec
14[NO_PID]: sqlca: code: 0, state: 00000
15[NO_PID]: ecpg_process_output on line 50: OK: CREATE TABLE
16[NO_PID]: sqlca: code: 0, state: 00000
17[NO_PID]: ecpg_execute on line 53: query: insert into family ( name , married , children ) values ( 'Mum' , '19870714' , 3 ); with 0 parameter(s) on connection ecpg1_regression
18[NO_PID]: sqlca: code: 0, state: 00000
19[NO_PID]: ecpg_execute on line 53: using PQexec
20[NO_PID]: sqlca: code: 0, state: 00000
21[NO_PID]: ecpg_process_output on line 53: OK: INSERT 0 1
22[NO_PID]: sqlca: code: 0, state: 00000
23[NO_PID]: ecpg_execute on line 54: query: insert into family ( name , born , married , children ) values ( 'Dad' , '19610721' , '19870714' , 3 ); with 0 parameter(s) on connection ecpg1_regression
24[NO_PID]: sqlca: code: 0, state: 00000
25[NO_PID]: ecpg_execute on line 54: using PQexec
26[NO_PID]: sqlca: code: 0, state: 00000
27[NO_PID]: ecpg_process_output on line 54: OK: INSERT 0 1
28[NO_PID]: sqlca: code: 0, state: 00000
29[NO_PID]: ecpg_execute on line 55: query: insert into family ( name , age ) values ( 'Child 1' , 16 ); with 0 parameter(s) on connection ecpg1_regression
30[NO_PID]: sqlca: code: 0, state: 00000
31[NO_PID]: ecpg_execute on line 55: using PQexec
32[NO_PID]: sqlca: code: 0, state: 00000
33[NO_PID]: ecpg_process_output on line 55: OK: INSERT 0 1
34[NO_PID]: sqlca: code: 0, state: 00000
35[NO_PID]: ecpg_execute on line 56: query: insert into family ( name , age ) values ( 'Child 2' , 14 ); with 0 parameter(s) on connection ecpg1_regression
36[NO_PID]: sqlca: code: 0, state: 00000
37[NO_PID]: ecpg_execute on line 56: using PQexec
38[NO_PID]: sqlca: code: 0, state: 00000
39[NO_PID]: ecpg_process_output on line 56: OK: INSERT 0 1
40[NO_PID]: sqlca: code: 0, state: 00000
41[NO_PID]: ecpg_execute on line 57: query: insert into family ( name , age ) values ( 'Child 3' , 9 ); with 0 parameter(s) on connection ecpg1_regression
42[NO_PID]: sqlca: code: 0, state: 00000
43[NO_PID]: ecpg_execute on line 57: using PQexec
44[NO_PID]: sqlca: code: 0, state: 00000
45[NO_PID]: ecpg_process_output on line 57: OK: INSERT 0 1
46[NO_PID]: sqlca: code: 0, state: 00000
47[NO_PID]: ECPGtrans on line 60: action "commit"; connection "ecpg1_regression"
48[NO_PID]: sqlca: code: 0, state: 00000
49[NO_PID]: ecpg_execute on line 63: query: declare cur cursor for select name , born , age , married , children from family; with 0 parameter(s) on connection ecpg1_regression
50[NO_PID]: sqlca: code: 0, state: 00000
51[NO_PID]: ecpg_execute on line 63: using PQexec
52[NO_PID]: sqlca: code: 0, state: 00000
53[NO_PID]: ecpg_process_output on line 63: OK: DECLARE CURSOR
54[NO_PID]: sqlca: code: 0, state: 00000
55[NO_PID]: ecpg_execute on line 72: query: fetch cur; with 0 parameter(s) on connection ecpg1_regression
56[NO_PID]: sqlca: code: 0, state: 00000
57[NO_PID]: ecpg_execute on line 72: using PQexec
58[NO_PID]: sqlca: code: 0, state: 00000
59[NO_PID]: ecpg_process_output on line 72: correctly got 1 tuples with 5 fields
60[NO_PID]: sqlca: code: 0, state: 00000
61[NO_PID]: ecpg_get_data on line 72: RESULT: Mum      offset: -1; array: no
62[NO_PID]: sqlca: code: 0, state: 00000
63[NO_PID]: ecpg_get_data on line 72: RESULT:  offset: -1; array: no
64[NO_PID]: sqlca: code: 0, state: 00000
65[NO_PID]: ecpg_get_data on line 72: RESULT:  offset: -1; array: no
66[NO_PID]: sqlca: code: 0, state: 00000
67[NO_PID]: ecpg_store_result on line 72: allocating memory for 1 tuples
68[NO_PID]: sqlca: code: 0, state: 00000
69[NO_PID]: ecpg_get_data on line 72: RESULT: 1987-07-14 offset: -1; array: no
70[NO_PID]: sqlca: code: 0, state: 00000
71[NO_PID]: ecpg_get_data on line 72: RESULT: 3 offset: -1; array: no
72[NO_PID]: sqlca: code: 0, state: 00000
73[NO_PID]: ecpg_execute on line 72: query: fetch cur; with 0 parameter(s) on connection ecpg1_regression
74[NO_PID]: sqlca: code: 0, state: 00000
75[NO_PID]: ecpg_execute on line 72: using PQexec
76[NO_PID]: sqlca: code: 0, state: 00000
77[NO_PID]: ecpg_process_output on line 72: correctly got 1 tuples with 5 fields
78[NO_PID]: sqlca: code: 0, state: 00000
79[NO_PID]: ecpg_get_data on line 72: RESULT: Dad      offset: -1; array: no
80[NO_PID]: sqlca: code: 0, state: 00000
81[NO_PID]: ecpg_get_data on line 72: RESULT: 19610721 offset: -1; array: no
82[NO_PID]: sqlca: code: 0, state: 00000
83[NO_PID]: ecpg_get_data on line 72: RESULT:  offset: -1; array: no
84[NO_PID]: sqlca: code: 0, state: 00000
85[NO_PID]: ecpg_store_result on line 72: allocating memory for 1 tuples
86[NO_PID]: sqlca: code: 0, state: 00000
87[NO_PID]: ecpg_get_data on line 72: RESULT: 1987-07-14 offset: -1; array: no
88[NO_PID]: sqlca: code: 0, state: 00000
89[NO_PID]: ecpg_get_data on line 72: RESULT: 3 offset: -1; array: no
90[NO_PID]: sqlca: code: 0, state: 00000
91[NO_PID]: ecpg_execute on line 72: query: fetch cur; with 0 parameter(s) on connection ecpg1_regression
92[NO_PID]: sqlca: code: 0, state: 00000
93[NO_PID]: ecpg_execute on line 72: using PQexec
94[NO_PID]: sqlca: code: 0, state: 00000
95[NO_PID]: ecpg_process_output on line 72: correctly got 1 tuples with 5 fields
96[NO_PID]: sqlca: code: 0, state: 00000
97[NO_PID]: ecpg_get_data on line 72: RESULT: Child 1  offset: -1; array: no
98[NO_PID]: sqlca: code: 0, state: 00000
99[NO_PID]: ecpg_get_data on line 72: RESULT:  offset: -1; array: no
100[NO_PID]: sqlca: code: 0, state: 00000
101[NO_PID]: ecpg_get_data on line 72: RESULT: 16 offset: -1; array: no
102[NO_PID]: sqlca: code: 0, state: 00000
103[NO_PID]: ecpg_store_result on line 72: allocating memory for 1 tuples
104[NO_PID]: sqlca: code: 0, state: 00000
105[NO_PID]: ecpg_get_data on line 72: RESULT:  offset: -1; array: no
106[NO_PID]: sqlca: code: 0, state: 00000
107[NO_PID]: ecpg_get_data on line 72: RESULT:  offset: -1; array: no
108[NO_PID]: sqlca: code: 0, state: 00000
109[NO_PID]: ecpg_execute on line 72: query: fetch cur; with 0 parameter(s) on connection ecpg1_regression
110[NO_PID]: sqlca: code: 0, state: 00000
111[NO_PID]: ecpg_execute on line 72: using PQexec
112[NO_PID]: sqlca: code: 0, state: 00000
113[NO_PID]: ecpg_process_output on line 72: correctly got 1 tuples with 5 fields
114[NO_PID]: sqlca: code: 0, state: 00000
115[NO_PID]: ecpg_get_data on line 72: RESULT: Child 2  offset: -1; array: no
116[NO_PID]: sqlca: code: 0, state: 00000
117[NO_PID]: ecpg_get_data on line 72: RESULT:  offset: -1; array: no
118[NO_PID]: sqlca: code: 0, state: 00000
119[NO_PID]: ecpg_get_data on line 72: RESULT: 14 offset: -1; array: no
120[NO_PID]: sqlca: code: 0, state: 00000
121[NO_PID]: ecpg_store_result on line 72: allocating memory for 1 tuples
122[NO_PID]: sqlca: code: 0, state: 00000
123[NO_PID]: ecpg_get_data on line 72: RESULT:  offset: -1; array: no
124[NO_PID]: sqlca: code: 0, state: 00000
125[NO_PID]: ecpg_get_data on line 72: RESULT:  offset: -1; array: no
126[NO_PID]: sqlca: code: 0, state: 00000
127[NO_PID]: ecpg_execute on line 72: query: fetch cur; with 0 parameter(s) on connection ecpg1_regression
128[NO_PID]: sqlca: code: 0, state: 00000
129[NO_PID]: ecpg_execute on line 72: using PQexec
130[NO_PID]: sqlca: code: 0, state: 00000
131[NO_PID]: ecpg_process_output on line 72: correctly got 1 tuples with 5 fields
132[NO_PID]: sqlca: code: 0, state: 00000
133[NO_PID]: ecpg_get_data on line 72: RESULT: Child 3  offset: -1; array: no
134[NO_PID]: sqlca: code: 0, state: 00000
135[NO_PID]: ecpg_get_data on line 72: RESULT:  offset: -1; array: no
136[NO_PID]: sqlca: code: 0, state: 00000
137[NO_PID]: ecpg_get_data on line 72: RESULT: 9 offset: -1; array: no
138[NO_PID]: sqlca: code: 0, state: 00000
139[NO_PID]: ecpg_store_result on line 72: allocating memory for 1 tuples
140[NO_PID]: sqlca: code: 0, state: 00000
141[NO_PID]: ecpg_get_data on line 72: RESULT:  offset: -1; array: no
142[NO_PID]: sqlca: code: 0, state: 00000
143[NO_PID]: ecpg_get_data on line 72: RESULT:  offset: -1; array: no
144[NO_PID]: sqlca: code: 0, state: 00000
145[NO_PID]: ecpg_execute on line 72: query: fetch cur; with 0 parameter(s) on connection ecpg1_regression
146[NO_PID]: sqlca: code: 0, state: 00000
147[NO_PID]: ecpg_execute on line 72: using PQexec
148[NO_PID]: sqlca: code: 0, state: 00000
149[NO_PID]: ecpg_process_output on line 72: correctly got 0 tuples with 5 fields
150[NO_PID]: sqlca: code: 0, state: 00000
151[NO_PID]: raising sqlcode 100 on line 72: no data found on line 72
152[NO_PID]: sqlca: code: 100, state: 02000
153[NO_PID]: ecpg_execute on line 89: query: close cur; with 0 parameter(s) on connection ecpg1_regression
154[NO_PID]: sqlca: code: 0, state: 00000
155[NO_PID]: ecpg_execute on line 89: using PQexec
156[NO_PID]: sqlca: code: 0, state: 00000
157[NO_PID]: ecpg_process_output on line 89: OK: CLOSE CURSOR
158[NO_PID]: sqlca: code: 0, state: 00000
159[NO_PID]: ecpg_execute on line 92: query: drop table family; with 0 parameter(s) on connection ecpg1_regression
160[NO_PID]: sqlca: code: 0, state: 00000
161[NO_PID]: ecpg_execute on line 92: using PQexec
162[NO_PID]: sqlca: code: 0, state: 00000
163[NO_PID]: ecpg_process_output on line 92: OK: DROP TABLE
164[NO_PID]: sqlca: code: 0, state: 00000
165[NO_PID]: ECPGtrans on line 95: action "commit"; connection "ecpg1_regression"
166[NO_PID]: sqlca: code: 0, state: 00000
167[NO_PID]: ecpg_finish: connection ecpg1_regression closed
168[NO_PID]: sqlca: code: 0, state: 00000
169