[NO_PID]: ECPGdebug: set to 1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGconnect: opening database regress1 on port [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 42: QUERY: create table meskes ( name char ( 8 ) , born integer , age smallint , married date , children integer ) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 42 Ok: CREATE TABLE [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 45: QUERY: insert into meskes ( name , married , children ) values( 'Petra' , '19900404' , 3 ) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 45 Ok: INSERT 0 1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 46: QUERY: insert into meskes ( name , born , age , married , children ) values( 'Michael' , 19660117 , 35 , '19900404' , 3 ) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 46 Ok: INSERT 0 1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 47: QUERY: insert into meskes ( name , born , age ) values( 'Carsten' , 19910103 , 10 ) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 47 Ok: INSERT 0 1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 48: QUERY: insert into meskes ( name , born , age ) values( 'Marc' , 19930907 , 8 ) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 48 Ok: INSERT 0 1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 49: QUERY: insert into meskes ( name , born , age ) values( 'Chris' , 19970923 , 4 ) on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 49 Ok: INSERT 0 1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGtrans line 52 action = commit connection = regress1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 55: QUERY: declare cur cursor for select name , born , age , married , children from meskes on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 55 Ok: DECLARE CURSOR [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 58: QUERY: move 2 in cur on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 58 Ok: MOVE 2 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 64: QUERY: fetch from cur on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 64: Correctly got 1 tuples with 5 fields [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_data line 64: RESULT: Carsten offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_data line 64: RESULT: 19910103 offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_data line 64: RESULT: 10 offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGstore_result: line 64: allocating memory for 1 tuples [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_data line 64: RESULT: offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_data line 64: RESULT: offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 64: QUERY: fetch from cur on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 64: Correctly got 1 tuples with 5 fields [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_data line 64: RESULT: Marc offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_data line 64: RESULT: 19930907 offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_data line 64: RESULT: 8 offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGstore_result: line 64: allocating memory for 1 tuples [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_data line 64: RESULT: offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_data line 64: RESULT: offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 64: QUERY: fetch from cur on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 64: Correctly got 1 tuples with 5 fields [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_data line 64: RESULT: Chris offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_data line 64: RESULT: 19970923 offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_data line 64: RESULT: 4 offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGstore_result: line 64: allocating memory for 1 tuples [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_data line 64: RESULT: offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_data line 64: RESULT: offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 64: QUERY: fetch from cur on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 64: Correctly got 0 tuples with 5 fields [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: raising sqlcode 100 in line 64, 'No data found in line 64.'. [NO_PID]: sqlca: code: 100, state: 02000 [NO_PID]: ECPGexecute line 81: QUERY: close cur on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 81 Ok: CLOSE CURSOR [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGprepare line 84: QUERY: select * from meskes where name = ? [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 88: QUERY: declare prep cursor for select * from meskes where name = 'Petra' on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 88 Ok: DECLARE CURSOR [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 94: QUERY: fetch in prep on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 94: Correctly got 1 tuples with 5 fields [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_data line 94: RESULT: Petra offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_data line 94: RESULT: offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_data line 94: RESULT: offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGstore_result: line 94: allocating memory for 1 tuples [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_data line 94: RESULT: 04-04-1990 offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGget_data line 94: RESULT: 3 offset: -1 array: Yes [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 94: QUERY: fetch in prep on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 94: Correctly got 0 tuples with 5 fields [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: raising sqlcode 100 in line 94, 'No data found in line 94.'. [NO_PID]: sqlca: code: 100, state: 02000 [NO_PID]: ECPGexecute line 110: QUERY: close prep on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 110 Ok: CLOSE CURSOR [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 113: QUERY: drop table meskes on connection regress1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGexecute line 113 Ok: DROP TABLE [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ECPGtrans line 116 action = commit connection = regress1 [NO_PID]: sqlca: code: 0, state: 00000 [NO_PID]: ecpg_finish: Connection regress1 closed. [NO_PID]: sqlca: code: 0, state: 00000