dbTalk Databases Forums  

capture query sent to SQL Anywhere

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss capture query sent to SQL Anywhere in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
leeaikmeng@gmail.com
 
Posts: n/a

Default capture query sent to SQL Anywhere - 10-23-2007 , 11:17 PM






Hi,

Is there any utility out there that act like the Profiler in SQL
Server for SQL Anywhere? I need to capture the query done by a
Powerbuilder Report and i do not have the source code of the program,
so I guess the only way is to capture the query and rebuild the report
myself.

Anyone any clue? Thank you.


Reply With Quote
  #2  
Old   
Frank Ploessel
 
Posts: n/a

Default Re: capture query sent to SQL Anywhere - 10-24-2007 , 03:00 AM






On Wed, 24 Oct 2007 06:17:12 +0200, <leeaikmeng (AT) gmail (DOT) com> wrote:

Quote:
Hi,

Is there any utility out there that act like the Profiler in SQL
Server for SQL Anywhere? I need to capture the query done by a
Powerbuilder Report and i do not have the source code of the program,
so I guess the only way is to capture the query and rebuild the report
myself.

Anyone any clue? Thank you.

Leeaikmeng,

Which version of SQL Anywhere are you using? In version 10, look up
"Tracing session data" in the documentation. I think these tracing
features were introduced somewhen in version 9.0.2.x

Frank


Reply With Quote
  #3  
Old   
Breck Carter [Team iAnywhere]
 
Posts: n/a

Default Re: capture query sent to SQL Anywhere - 10-24-2007 , 05:33 AM



Look up "request logging" in the Help Index tab.

Breck

On Tue, 23 Oct 2007 21:17:12 -0700, leeaikmeng (AT) gmail (DOT) com wrote:

Quote:
Hi,

Is there any utility out there that act like the Profiler in SQL
Server for SQL Anywhere? I need to capture the query done by a
Powerbuilder Report and i do not have the source code of the program,
so I guess the only way is to capture the query and rebuild the report
myself.

Anyone any clue? Thank you.
--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhe...ers_Guide.html
breck.carter (AT) risingroad (DOT) com


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.