>I am working under IDS 7.31 TC2 on WinNT.

>I manage to get information on response time of a few stored procedures.
>I would like to do without writting an esql/c program ; but as far as I
>can see, it is not really possible to do with SQL dans its CURRENT
>function.

>Any suggestion will be greatly appreciated.

> Or:

> SELECT dbinfo('utc_current') in your SP.

>Thanks but I  still have some troubles :

> > select current from systables where tabid = 1;
> > execute procedure fred("right");
> > select current from systables where tabid = 1;

>The CURRENT function always returns result wich precision is 'truncated' to
>second format (fraction part of datetime is always 000) : '2000-04-04
>15:21:54 000'. I get this result either in an SQL statement or in a SP. I
>read that CURRENT rely on the system date and time API ; I suppose that
>WinNT
>knows millisecond ! So I do not really understand what is the problem !

> > Or:

> > SELECT dbinfo('utc_current') in your SP.

>Wich format returns this statement (I did not find 'utc_current' in
>documentation, what is it ?) because I get an exception of bad conversion
>when I set this statement in a DATETIME YEAR TO FRACTION variable ?

-----Original Message-----

Sent: Tuesday, April 04, 2000 11:57 AM
To: Obnoxio The Clown

Subject: Re: IDS 7.3 : Stored procedures tuning
Importance: High

Thanks but I  still have some troubles :

> select current from systables where tabid = 1;
> execute procedure fred("right");
> select current from systables where tabid = 1;

The CURRENT function always returns result wich precision is 'truncated' to
second format (fraction part of datetime is always 000) : '2000-04-04
15:21:54 000'. I get this result either in an SQL statement or in a SP. I
read that CURRENT rely on the system date and time API ; I suppose that
WinNT
knows millisecond ! So I do not really understand what is the problem !

> Or some variation on that theme.

> Or:

> SELECT dbinfo('utc_current') in your SP.

Wich format returns this statement (I did not find 'utc_current' in
documentation, what is it ?) because I get an exception of bad conversion
when I set this statement in a DATETIME YEAR TO FRACTION variable ?

Thanks for your help

Arnaud

--
- -------------------------------------------------------------- -

-  Ingenieur en developpement                                    -
-  Direction Metier Industrie                                    -
- -------------------------------------------------------------- -
-  ALLIANCE QUALITE LOGICIEL                  http://www.aql.fr  -
-  Rue de la Chataigneraie                                       -
-  B.P. 127                                                      -
-  35513 CESSON SEVIGNE                                          -
-                tel : (33) (0)2.99.12.50.00                     -
-                fax : (33) (0)2.99.63.70.40                     -
- -------------------------------------------------------------- -

> In your onconfig file, set USEOSTIME to 1.

> # method for Dynamic Server to use when determining current time
> USEOSTIME       1               # 0: use internal time(fast), 1: get time
> from O
> S(slow)

> > >The CURRENT function always returns result wich precision is
>'truncated' to
> > >second format (fraction part of datetime is always 000) : '2000-04-04
> > >15:21:54 000'. I get this result either in an SQL statement or in a SP.
>I
> > >read that CURRENT rely on the system date and time API ; I suppose that
> > >WinNT
> > >knows millisecond ! So I do not really understand what is the problem !

> > In your onconfig file, set USEOSTIME to 1.

>Doesn't works!

> > > > >WinNT
> > > > >knows millisecond ! So I do not really understand what is the
>problem !
> > > > In your onconfig file, set USEOSTIME to 1.
> > >Doesn't works!
> > All together now: "USE A REAL OPERATING SYSTEM!!!" :-)

>Out of topic. We are speaking about Informix engine which can't
>get correct time from OS.

> > > > > >WinNT
> > > > > >knows millisecond ! So I do not really understand what is the
> >problem !
> > > > > In your onconfig file, set USEOSTIME to 1.
> > > >Doesn't works!
> > > All together now: "USE A REAL OPERATING SYSTEM!!!" :-)

> >Out of topic. We are speaking about Informix engine which can't
> >get correct time from OS.

> Oh dear. It's not just Londoners who have no sense of humour.

> > > >The CURRENT function always returns result wich precision is
> >'truncated' to
> > > >second format (fraction part of datetime is always 000) : '2000-04-04
> > > >15:21:54 000'. I get this result either in an SQL statement or in a SP.
> >I
> > > >read that CURRENT rely on the system date and time API ; I suppose that
> > > >WinNT
> > > >knows millisecond ! So I do not really understand what is the problem !

> > > In your onconfig file, set USEOSTIME to 1.

> >Doesn't works!

> All together now: "USE A REAL OPERATING SYSTEM!!!" :-)

> > > > >WinNT
> > > > >knows millisecond ! So I do not really understand what is the problem !
> > > > In your onconfig file, set USEOSTIME to 1.
> > >Doesn't works!
> > All together now: "USE A REAL OPERATING SYSTEM!!!" :-)

> Out of topic. We are speaking about Informix engine which can't
> get correct time from OS.

> > >But there isnt an Informix port to GNU/Hurd ;-]

> > >Connection House, 9 Selsdon Way, Cityharbour, London E14
> > ...............................................^^^^^^

> > I rest my case about Londoners, anyway... :-)

>You 'dissing me clown :-?  I *live* in Sussex I just happen to work in
>this dump ...