how to trace which command were received by ASE server and in which order?
just as we do in IQ "RequestLogFile" is there any similar option available in ASE?

Hi,
Please go through below article:
=============================

Version 15.0.2 of ASE comes with the new feature of 'application tracing'. This is simple mechanism to figure out what your client applications are actually doing: apptracing lets you capture the SQL submitted to the ASE server by a specific client connection, and writes it into a file.
Basically, it works as follows : there's an application connected to your ASE server with session number (spid #) 54, and you want to see what SQL it is actually executing. You run the following SQL:

set tracefile '/tmp/spid54.trace.out' for 54
set show_sqltext on

... and from here on, any SQL executed by the application on session 54 will be captured into the file /tmp/spid54.trace.out.

Source : www, sybase website
White paper acan be downloadedfrom sybase.com
http://www.sybase.com/files/White_Pa...-070507-wp.pdf

Cheers!!