accept ... from time
Hello,
I want to measure the execution time of a sql statement. Can I get the
time in milliseconds to be displayed.
I have
accept START-TIME from time
EXEC SQL SELECT ... something
accept END-TIME from time
DISPLAY "EXECUTION lasted from" START-TIME
DISPLAY " till " END-TIME
START-TIME and END-TIME is pic x(8) this is hh24:mm:ss. But I need
fractions of seconds. How can I do this. Target System is Microfocus
and AIX.
Kind Regards
Michael
.
Relevant Pages
- Re: SQL Question
... to display "X" if the field is True, ... > SQL statements to display conditional output. ... > control output based on the result of a test condition. ... > As a SQL statement for a list box, ...
(microsoft.public.access.formscoding) - Re: Get Values SQL in table
... > data set in the text box, ... > can take the results of the query and display them in columns. ... > is only capable of displaying the actual text string, ... within the SQL statement or the table that is the data source. ...
(microsoft.public.access.modulesdaovba) - Re: How do I select a certain number of records randomly from a ta
... No, it is supposed to be a SQL statement, although I forgot to put the field ... You don't indicate where you want to display these questions when you are ... If you have a database of addresses, ... Dale ...
(microsoft.public.access.queries) - RE: Multiple comboboxes filtering each other
... I would like my search form to be seperate from my display form; ... you could concantenate the First and Last name with a SQL statement ... This would display them in two separate columns, ... First Name, and are trying to set up a multi-parameter search form, Allen ...
(microsoft.public.access.forms) - ANN: Request & Response - Update Notice - 1.0.1.3
... Request & Response that offer several new features as well as correcting ... -Added display of active SQL Statement if loaded from Repository ... -Added option to save current SQL statement on exit to user login SQL ...
(borland.public.delphi.thirdpartytools.general) |
|
