Re: IDS 7.3 : Stored procedures tuning
From: Arnaud ANDRIEUX <arnaud.andrieux@aql.fr>
>
>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.
select current from systables where tabid = 1;
execute procedure fred("right");
select current from systables where tabid = 1;
Or some variation on that theme.
Or:
SELECT dbinfo('utc_current') in your SP.
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com