Consultor Eletrônico

Status: Unverified

GOAL:

How to obtain information about the currently connected batch clients of a database?

GOAL:

How to find out if a batch process is still running ?

FIX:

The _connect VST gives you information about the clients connected to the DB. In particular the field, _connect-batch displays batch users status as follows:

'NO' for the normal client
A different value for the batch clients.
Thus you can retrieve information about the batch clients with the following code used in a client connected against the same DB:

FOR EACH _connect WHERE _connect-batch <> ? AND _connect-batch <> 'NO':
DISPLAY _connect.
END.