DBI::db=HASH(0x268e884) trace level set to 0x0/9 (DBI @ 0x0/0) in DBI 1.616-ithread (pid 2800) -> prepare for DBD::ODBC::db (DBI::db=HASH(0x268e914)~0x268e884 'SELECT [Index Returns].[Index Number], [Index Returns].Month, [Index Returns].Return FROM [Index Returns] WHERE [Index Returns].[Index Number]=63 AND YEAR( [Index Returns].Month)=2006') thr#1dd7904 New 'DBI::st' (for DBD::ODBC::st, parent=DBI::db=HASH(0x268e884), id=undef) dbih_setup_handle(DBI::st=HASH(0x268eb54)=>DBI::st=HASH(0x268eaf4), DBD::ODBC::st, 2679a5c, Null!) dbih_make_com(DBI::db=HASH(0x268e884), 1dfa63c, DBD::ODBC::st, 236, 0) thr#1dd7904 dbih_setup_attrib(DBI::st=HASH(0x268eaf4), Err, DBI::db=HASH(0x268e884)) SCALAR(0x267997c) (already defined) dbih_setup_attrib(DBI::st=HASH(0x268eaf4), State, DBI::db=HASH(0x268e884)) SCALAR(0x26799fc) (already defined) dbih_setup_attrib(DBI::st=HASH(0x268eaf4), Errstr, DBI::db=HASH(0x268e884)) SCALAR(0x26799bc) (already defined) dbih_setup_attrib(DBI::st=HASH(0x268eaf4), TraceLevel, DBI::db=HASH(0x268e884)) 9 (already defined) dbih_setup_attrib(DBI::st=HASH(0x268eaf4), FetchHashKeyName, DBI::db=HASH(0x268e884)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0x268eaf4), HandleSetErr, DBI::db=HASH(0x268e884)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x268eaf4), HandleError, DBI::db=HASH(0x268e884)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x268eaf4), ReadOnly, DBI::db=HASH(0x268e884)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x268eaf4), Profile, DBI::db=HASH(0x268e884)) undef (not defined) initializing sth query timeout to -1 ignore named placeholders = 0 SQLPrepare SELECT [Index Returns].[Index Number], [Index Returns].Month, [Index Returns].Return FROM [Index Returns] WHERE [Index Returns].[Index Number]=63 AND YEAR( [Index Returns].Month)=2006 SQLPrepare = 0 <- prepare= ( DBI::st=HASH(0x268eb54) ) [1 items] at F:\Andrei\Covi\pl\covi_test.pl line 63 -> execute for DBD::ODBC::st (DBI::st=HASH(0x268eb54)~0x268eaf4) thr#1dd7904 +dbd_st_execute(2679a7c) dbd_st_finish(2679a7c) outparams = 0 SQLExecute/SQLExecDirect(2720478)=0 SQLRowCount=0 (rows=-1) SQLNumResultCols=0 (flds=3) dbd_describe done_desc=0 dbd_describe SQLNumResultCols=0 (columns=3) DescribeCol column = 1, name = I, namelen = 12, type = INTEGER(4), precision/column size = 10, scale = 0, nullable = 1 SQL_COLUMN_DISPLAY_SIZE = 11 SQL_COLUMN_LENGTH = 0 now using col 1: type = INTEGER (4), len = 1, display size = 12, prec = 10, scale = 0 DescribeCol column = 2, name = M, namelen = 5, type = TIMESTAMP(93), precision/column size = 19, scale = 0, nullable = 1 SQL_COLUMN_DISPLAY_SIZE = 19 SQL_COLUMN_LENGTH = 19 now using col 2: type = TIMESTAMP (93), len = 20, display size = 20, prec = 19, scale = 0 DescribeCol column = 3, name = R, namelen = 6, type = DOUBLE(8), precision/column size = 53, scale = 0, nullable = 1 SQL_COLUMN_DISPLAY_SIZE = 22 SQL_COLUMN_LENGTH = 0 now using col 3: type = DOUBLE (8), len = 1, display size = 23, prec = 53, scale = 0 -dbd_describe done_bind=0 have 3 fields -dbd_st_execute(2679a7c)=-1 <- execute= ( -1 ) [1 items] at F:\Andrei\Covi\pl\covi_test.pl line 64 -> fetchall_arrayref for DBD::ODBC::st (DBI::st=HASH(0x268eb54)~0x268eaf4) thr#1dd7904 bind_columns fbh=271e21c fields=3 Bind 1: type = CHAR(1), buf=26fd7f4, buflen=12 Bind 2: type = CHAR(1), buf=26fd800, buflen=20 Bind 3: type = CHAR(1), buf=26fd814, buflen=23 bind_columns=0 SQLFetch rc 0 dbih_setup_fbav alloc for 3 fields dbih_setup_fbav now 3 fields fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-01-31 00:00:00'(19) fetch col#3 R datalen=3 displ=23 'E-2'(3) SQLFetch rc 0 fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-02-28 00:00:00'(19) fetch col#3 R datalen=16 displ=23 '1.04229344255789'(16) SQLFetch rc 0 fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-03-31 00:00:00'(19) fetch col#3 R datalen=17 displ=23 '0.527619016616885'(17) SQLFetch rc 0 fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-04-30 00:00:00'(19) fetch col#3 R datalen=17 displ=23 '0.778996070749438'(17) SQLFetch rc 0 fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-05-31 00:00:00'(19) fetch col#3 R datalen=17 displ=23 '0.598470714678423'(17) SQLFetch rc 0 fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-06-30 00:00:00'(19) fetch col#3 R datalen=15 displ=23 '1.5153242075065'(15) SQLFetch rc 0 fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-07-31 00:00:00'(19) fetch col#3 R datalen=16 displ=23 '1.96514473171672'(16) SQLFetch rc 0 fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-08-31 00:00:00'(19) fetch col#3 R datalen=16 displ=23 '3.69323515846371'(16) SQLFetch rc 0 fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-09-30 00:00:00'(19) fetch col#3 R datalen=3 displ=23 'E-2'(3) SQLFetch rc 0 fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-10-31 00:00:00'(19) fetch col#3 R datalen=15 displ=23 '1.9777348426463'(15) SQLFetch rc 0 fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-11-30 00:00:00'(19) fetch col#3 R datalen=18 displ=23 '-0.949641474442719'(18) SQLFetch rc 0 fetch num_fields=3 fetch col#1 I datalen=2 displ=12 '63'(2) fetch col#2 M datalen=19 displ=20 '2006-12-31 00:00:00'(19) fetch col#3 R datalen=16 displ=23 '2.48912119074928'(16) SQLFetch rc 100 Getting more results: 100 No more results -- outparams = 0 dbd_st_finish(2679a7c) dbd_st_finish closed query: <- fetchall_arrayref= ( [ ARRAY(0x268ebf4) ARRAY(0x268ec94) ARRAY(0x268ed34) ARRAY(0x268ee14) ARRAY(0x268ee94) ARRAY(0x268ef14) ARRAY(0x268ef94) ARRAY(0x2690044) ARRAY(0x26900c4) ARRAY(0x2690144) ARRAY(0x26901c4) ARRAY(0x2690244) ] ) [1 items] row12 at F:\Andrei\Covi\pl\covi_test.pl line 65 -> trace for DBD::ODBC::db (DBI::db=HASH(0x268e914)~0x268e884 0) thr#1dd7904 <- trace= ( 9 ) [1 items] at F:\Andrei\Covi\pl\covi_test.pl line 67 -> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x268eaf4)~INNER) thr#1dd7904 <- DESTROY= ( undef ) [1 items]