Posted by: Basis
Can you tell me how can I get all Centura SqlHandles of cursors connected to
Server from remote connected application(Client).
I want to get Last SQL Statement on each cursor.
I've tried do this:
1) Receive cursor number by sqlgsi(get server info) API function (
field in server info struc)
2) Put this cursor number ro API function sqlget() with parameter SQLPLSS
but result is
Than I've tried:
1) Get Cursor number like before(sqlgsi)...
2) Receive Backend cursor information by API function sqlgbi()
3) Put this BackendCur sqlget() with same parameter SQLPLSS
but... the same result
After I've found undocumented function SqlHandle SqlGetSqlHandle(Number
cursor) in CDLLI15.DLL with undepends walker for Microsoft Visual
Studio.I've never seen it in any documantation and forum. It is opposit to
known undocument Centura function .
I thought that all ok.....
But this function return me SQL Handles for cursors connected in same
application.For other cursors from server returns 0h or NULL.
May be my Centura Version is Old (CTD151).
Please help me understand SERVER WORK WITH CURSORS, relations with Cursor
Number, Cursor Handle(for Database connection), SqlHandle(for Centura) and
May be anybody knows how to get address of Input/Output Message Buffer or
other interesting and important information.
Thank's in advise