RE: IDS 7.3 : Stored procedures tuning
Try this
# method for Dynamic Server to use when determining current time
USEOSTIME 1 # 0: use internal time(fast), 1: get timefrom O
S(slow)
> N. Daniel Bonesana
> SIEMENS-ITRON BUSINESS SERVICES S.A.
> Balcarce 683, (C1064AAM) Buenos Aires, Argentina.
> * 54 (11) 4320-5456 * dbones@siemens-itron.com.ar
>
>
-----Original Message-----
From: Arnaud ANDRIEUX [mailto:arnaud.andrieux@aql.fr]
Sent: Tuesday, April 04, 2000 11:57 AM
To: Obnoxio The Clown
Cc: informix-list@iiug.org
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
--
- -------------------------------------------------------------- -
- Arnaud ANDRIEUX arnaud.andrieux@aql.fr -
- 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 -
- -------------------------------------------------------------- -
Daniel Bonesana wrote:
> Try this
>
> # method for Dynamic Server to use when determining current time
> USEOSTIME 1 # 0: use internal time(fast), 1: get time> from O
> S(slow)
Doesn't works!