Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Processing Time

4 posts in PB Infomaker Report Writer Last posting was on 1999-06-04 14:39:35.0Z
Christopher F Jackson Posted on 1999-06-02 01:29:41.0Z
Newsgroups: sybase.public.infomaker.general
From: "Christopher F Jackson" <cfjackson@earthlink.net>
Subject: Processing Time
Date: Tue, 1 Jun 1999 21:29:41 -0400
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
Message-ID: <348_3tkB#cJr#GA.206@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6260
Article PK: 240196

Does anyone know how or if possible to place on a report a formula to
calculate the amount of time it took a particular report to run. From the
start of the last retrieval argument entered to the time the report was
finished. I see there is a PB function called CPU() and that functions
seems to work in IM maybe its not the right function to use but there must
be a way...

Any Ideas?


Thanks


Terry Dykstra Posted on 1999-06-02 01:47:22.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Processing Time
Date: Tue, 1 Jun 1999 19:47:22 -0600
Lines: 23
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_Z11k6pJr#GA.206@forums.sybase.com>
References: <348_3tkB#cJr#GA.206@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6258
Article PK: 240195

cpu() isn't listed under available IM functions, but it indeed works.
How about last( cpu() for all ) - first( cpu() for all )

--
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.

Christopher F Jackson wrote in message
<3tkB#cJr#GA.206@forums.sybase.com>...
>Does anyone know how or if possible to place on a report a formula to
>calculate the amount of time it took a particular report to run. From the
>start of the last retrieval argument entered to the time the report was
>finished. I see there is a PB function called CPU() and that functions
>seems to work in IM maybe its not the right function to use but there must
>be a way...
>
>Any Ideas?
>
>
>Thanks
>
>


Christopher F Jackson Posted on 1999-06-03 01:10:18.0Z
Newsgroups: sybase.public.infomaker.general
From: "Christopher F Jackson" <cfjackson@earthlink.net>
Subject: Re: Processing Time
Date: Wed, 2 Jun 1999 21:10:18 -0400
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
Message-ID: <348_$8Jiz2Vr#GA.305@forums.sybase.com>
References: <348_3tkB#cJr#GA.206@forums.sybase.com> <348_Z11k6pJr#GA.206@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6252
Article PK: 240190

Terry
That works great but I didn't realize that it doesn't factor in the time it
takes for the data to be retrieved on the server, only the time it takes to
process the report on the client machine. I have to come up with some way
to capture the true start time of report.
Thanks

Terry Dykstra <tdykstra@cfol.ab.ca> wrote in message
news:Z11k6pJr#GA.206@forums.sybase.com...
> cpu() isn't listed under available IM functions, but it indeed works.
> How about last( cpu() for all ) - first( cpu() for all )
>
> --
> Terry Dykstra (TeamSybase)
> Canadian Forest Oil Ltd.
> Christopher F Jackson wrote in message
> <3tkB#cJr#GA.206@forums.sybase.com>...
> >Does anyone know how or if possible to place on a report a formula to
> >calculate the amount of time it took a particular report to run. From
the
> >start of the last retrieval argument entered to the time the report was
> >finished. I see there is a PB function called CPU() and that functions
> >seems to work in IM maybe its not the right function to use but there
must
> >be a way...
> >
> >Any Ideas?
> >
> >
> >Thanks
> >
> >
>
>


Terry Dykstra Posted on 1999-06-04 14:39:35.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Processing Time
Date: Fri, 4 Jun 1999 08:39:35 -0600
Lines: 49
X-Newsreader: Microsoft Outlook Express 4.72.3612.1700
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
Message-ID: <348_UxCdBepr#GA.206@forums.sybase.com>
References: <348_3tkB#cJr#GA.206@forums.sybase.com> <348_Z11k6pJr#GA.206@forums.sybase.com> <348_$8Jiz2Vr#GA.305@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6247
Article PK: 240182

In your select statement get the datetime from the server, e.g. in Oracle:
select a.*, sysdate from mytable a

Then on you report use the first and last row to get the actual time for the
select statement.

--
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.

Christopher F Jackson wrote in message
<$8Jiz2Vr#GA.305@forums.sybase.com>...
>Terry
>That works great but I didn't realize that it doesn't factor in the time it
>takes for the data to be retrieved on the server, only the time it takes to
>process the report on the client machine. I have to come up with some way
>to capture the true start time of report.
>Thanks
>
>Terry Dykstra <tdykstra@cfol.ab.ca> wrote in message
>news:Z11k6pJr#GA.206@forums.sybase.com...
>> cpu() isn't listed under available IM functions, but it indeed works.
>> How about last( cpu() for all ) - first( cpu() for all )
>>
>> --
>> Terry Dykstra (TeamSybase)
>> Canadian Forest Oil Ltd.
>> Christopher F Jackson wrote in message
>> <3tkB#cJr#GA.206@forums.sybase.com>...
>> >Does anyone know how or if possible to place on a report a formula to
>> >calculate the amount of time it took a particular report to run. From
>the
>> >start of the last retrieval argument entered to the time the report was
>> >finished. I see there is a PB function called CPU() and that functions
>> >seems to work in IM maybe its not the right function to use but there
>must
>> >be a way...
>> >
>> >Any Ideas?
>> >
>> >
>> >Thanks
>> >
>> >
>>
>>
>
>