Logging of queries performed

[eltoni]

Hi All,

I am running an Informix database server on a HP-UX machine.
For writing sql statement I access the database by:

"dbaccess dbname -" which doesnt give me any interface or simple GUI but just writing the statement in command line.
All I want to know is if it is any possibility that all these queries I write are logged in anywhere? If yes, where?

I`d appreciate very much if anyone could reply to this message as it is an important issue for me.

Thanks and BR
Elton

 

[Drone38]

Hello,

I'm currently looking an issue to catch all queries sent to the server.
Unfortunately Ifx doesn't seem to give a simple API or anything else.
I'm afraid the only way to catch queries is to develop a kind of plug in for Ifx, but it may be a little bit to long.

Keep you informed
Regards