Kbase P147071: How to use VST's to find out what type of server (4GL or SQL) is connected to a database.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/06/2010 |
|
Status: Verified
GOAL:
How to use VST's to list the type of server currently connected to a database.
GOAL:
How to use VST's to find out what type of server is currently connected to a database.
GOAL:
How can I tell if a server connected to a database is a 4GL or SQL server?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1B
FIX:
The following program will list out the process id (PID) and server type of 4GL and SQL servers currently connected to a database. Run the following code in the procedure editor when connected to the database that you want to find the server types for:for each _connect where _connect-type = ?SERV? or _connect-type = ?SQSV?:
display _connect-pid _connect-type.
end.
4GL servers have a type of "SERV" and SQL servers have a type of "SQSV".