RE: Use of Interval Datatype

Thanks Guys, Couldn't see it for looking, I'd spent hours looking as well :( Art, I'll send the shell script over if your interested. Regards Colin There are 10 types of people in the world, those that understand binary and those that don't > Date: Tue, 1 Apr 2008 07:43:45 -0400 > From: art@oninit.com > To: cjd_1955@hotmail.com > CC: informix-list@iiug.org > Subject: Re: Use of Interval Datatype > > Colin Dawson wrote: >> Am I being a bit stupid with this...... >> > > Just a smidge dense ;-) > > log_time is defined as HOUR TO MINUTE but you load file includes seconds > for that column! This sounds like a nice extension to dostats! Have to > put it on my to-do list. > > Art S. Kagel > Oninit > >> Informix 9.40.FC8X3 >> Solaris 9 >> >> >> I have a table >> >> create table stathist >> ( >> rec_no serial not null, >> log_date date not null, >> log_time datetime hour to minute, >> run_date date not null, >> server_name char(18) not null, >> db_name char(18) not null, >> table_name char(18) not null, >> elapsed interval hour to fraction(3) >> ) extent size 1024 next size 128 lock mode page;>> >> Nice and simple so far so I thought >> >> I have some data >> 0|01/04/08|11:19:03|31/03/08|server_name|db_name|tabname1|00:00:02.327| >> 0|01/04/08|11:19:03|31/03/08|server_name|db_name|tabname2|00:00:00.586| >> 0|01/04/08|11:19:03|31/03/08|server_name|db_name|tabname3|28:50:52.828| >> >> I run dbaccess to load this data into above table, it fails with >> >> Database selected. >> >> >> 1264: Extra characters at the end of a datetime or interval.>> >> 847: Error in load file line 1. >> Error in line 1>> Near character position 62 >> >> >> Database closed. >> >> Anyone got an idea where I'm going wrong? All I want is to keep a history of how long dostats took to run on each table >> >> >> >> >> Regards >> >> Colin >> >> >> There are 10 types of people in the world, those that understand binary and those that don't >> >> >> _________________________________________________________________ >> The next generation of Windows Live is here >> http://www.windowslive.co.uk/get-live >> _______________________________________________ >> Informix-list mailing list >> Informix-list@iiug.org >> http://www.iiug.org/mailman/listinfo/informix-list >> >> >> > > _________________________________________________________________ Welcome to the next generation of Windows Live http://www.windowslive.co.uk/get-live