Question How To Find The User Connected To Sql Secondary Broker Alone

[Reddy P]

Hi ,

I am using progress 4GL databse as a primary one and sql as secondar broker by using -m3 parameter . I would like to know all the users who are connected to sql server alone . could anyone of you please help on this ..??

 

[TomBascom]

If you are on a modern release of Progress SQL connections are indicated by _Connect._Connect-Client = "SQLC".

You can get a list of SQL connections with:

for each dictdb._Connect no-lock where _connect-client begins "SQ":
  display _Connect-id _Connect-usr _Connect-name _Connect-client.
end.

 

[Reddy P]

Hi TomBascom,

Thank You for your timely response. I am using 10.2B version of progress ..I ran the code but didnt get any output on my screen.

 

[Rob Fitzpatrick]

That means you currently have no SQL clients connected to your database.

 

[TomBascom]

Also... 10.2b is the new 9.1e

Before long I will feel compelled to tag all mentions of 10.2b as "ancient, obsolete and unsupported".