ODBC And Informix Sessions

[FluxAnomaly]

Hey there, i would like to know if there is any way
for me to know at odbc level what instructions are the
clients executing, whitout falling to the ODBC Trace,
and also i would like to know if there is any way for a user to assign an existing session as the receiver of an sql
sentece.

Thanks a lot

 

[roelwe]

You could use sqldebug. An environment variable that traces your communication between server and client.
You can also trace the parsed sql statements with onstat -g sql <sess-id>.
An existing session is already assigned to a userthread, sqlexec. check onstat -g ntt. A session is never the receiver of the sql...
I don't think I understand your second question. Sorry.